MySQL --> SQLite

zippo · Post by **zippo** » 20.03.2010, 10:28

Hi!

I'm trying to extend my program to off-line functionalities. Since mysql embedded is commercial (

) I opted for SQLite. But there's a problem - I want the SQLite DB to be created dynamically (in case the main server DB gets updated I will not have to worry about changes). As I can see the create syntax is not usable from MySQL in SQLite. Did someone had a similar issue? Can the Zeos metadata component be used in this case?

Wild_Pointer · Post by **Wild_Pointer** » 20.03.2010, 10:38

Hello zippo,

You should check http://zeos.firmos.at/viewtopic.php?t=2627&highlight= . Id does not answer how to create DB for SQLite, but I think you will find the analogy.

Good luck!

zippo · Post by **zippo** » 20.03.2010, 10:46

Thanx! I will check it immediately!

Post by **mdaems** » 21.03.2010, 22:35

Since mysql embedded is commercial ( )

Not sure if that one's true. If I'm correctly informed the mysql embedded server library is freely available and under GPL licence in the 5.1 and 5.5 releases. (It wasn't in 5.0 because of stability issues)

The commercial offering is about a real server product for ISV's and OEM's and is (stupidly) named very similar to the 'dll server'.

Mark