SQLite In-Memory Database (VERY FAST )

thanos · Post by **thanos** » Sun Sep 28, 2008 7:20 am

pdwyer wrote:not really, no.

You'd need a middle tier to serialise the requests. selects can run together but updates and inserts etc can't

Thanks for the post.
Do you have any suggestion?
I have some experience in MsSQL, mySQL and Firebird.
I prefer something with zero administration, if it is possible.
Regards

Thanos

pdwyer · Post by **pdwyer** » Sun Sep 28, 2008 7:24 am

for zero admin I don't know. Maybe something like Tsunami but its not SQL I don't think.

Personally I like MS SQL server but my experience isn't so much with 2005, I haven't had a chance to keep up to date on that platform. MSDE was free and good if you didn't need it to scale too big but I'm not sure what became of that with the sql2005 platform, probably had it's name changed again

blueb · Post by **blueb** » Sun Sep 28, 2008 4:03 pm

Paul Squires and Fred Meier are working on a Sqlite server (open source) that appears to be working quite nicely.

(PowerBASIC source, but the conversion should be easy, if you just need the DLL)

see: http://planetsquires.com/sqlite_client_server.htm

--blueb

thanos · Post by **thanos** » Sun Sep 28, 2008 7:19 pm

blueb wrote:Paul Squires and Fred Meier are working on a Sqlite server (open source) that appears to be working quite nicely.

(PowerBASIC source, but the conversion should be easy, if you just need the DLL)

see: http://planetsquires.com/sqlite_client_server.htm

--blueb

Thanks.
I visited the site and this project seems to be very interesting.
I will check it out.
Regards.

Thanos