Re: How to create a SQL engine like MySQL server

harryxiyou <[email protected]> writes:
> I wanna design/implement a SQL engine (a brief MySQL server, our
> project needs) which standard MySQL client could connect to this SQL
> engine. It seems that I need to dig into MySQL proxy but I am not
> sure. Would anyone please give me some suggestions?

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.

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).

c) embed a SQL database inside your application.

   Why doesn't sqlite work?


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