Re: How to create a SQL engine like MySQL server

On Wed, Jan 28, 2015 at 8:44 AM, Stewart Smith
<[email protected]> wrote:
Hi Stewart,

>
> Your question is a bit ambiguous. Are you:
>
> a) Trying to write a new storage backend (StorageEngine) for MySQL?
>
>    If so, look at the EXAMPLE, ARCHIVE, CSV and InnoDB engines for
>    HOWTO.
>    Yes, the API is damn awful and has never been cleaned up.

My current problem is to design/implement a SQL engine like MySQL
server especially for its proxy so that my server side could be
connected by standard MySQL client side. For the storage engine part,
we have implemented portions. To be more exact, I am not sure how to
implement a proxy to be connected by standard MySQL cilent (We need
standard MySQL client protocol).

>
> b) Trying to write a database server that's a bit like MySQL (that
> speaks the MySQL protocol)?
>
>    The MySQL protocol isn't that hard to implement yourself. Have a look
>    at libdrizzle and libattachsql for liberally licensed implementations
>    of client side (and some older libdrizzle versions, server side).
>

Yes, exactly, I wanna know how to design/implement light-weight MySQL
server side proxy so that standard MySQL client could connect to it.
It seems that libdrizzle and libattachsql are all MySQL client side,
right?

> c) embed a SQL database inside your application.
>
>    Why doesn't sqlite work?

Nope, it is not embed one.


Thanks, Harry

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals