OpenStudy (anonymous):

can anybody know about SQLLITE ??

6 years ago
OpenStudy (anonymous):

I worked a lot in SQLite, what do you want to know?

6 years ago
OpenStudy (anonymous):

i am going to build a dynamic web project and my guide asked me to use SQLite or HSQL for database. i want to know working with SQLite or HSQL is similar as sqlserver 2000 like function syntax and one more thingh is there any limitationt of using SQLite.

6 years ago
OpenStudy (anonymous):

You can check out the differences here: http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.compactframework/2005-12/msg00019.html the most important for me were: - SQLite is portable and needs no dedicated server to function - SQLite does not enforce data type constraints - SQLite doesn't support stored procedures - The most annoying thing in SQLite for me was it's limited ALTER TABLE support that only supports adding a new column changing the name of a table. For everything else You need to recreate the table. For more info You can check out the official FAQ: http://www.sqlite.org/faq.html

6 years ago
OpenStudy (anonymous):

As for the syntax it's very similar there shouldn't be any problems. Also I'm not familiar with HSQL

6 years ago
OpenStudy (anonymous):

Also I recommend downloading a SQLite database management tool. The ones I used are here (they are freeware): http://sqliteman.com/ http://sqlitestudio.one.pl/ http://sqliteadmin.orbmu2k.de/

6 years ago
OpenStudy (anonymous):

thanku very much sir for your reply this information is very usefull for us.

6 years ago
OpenStudy (anonymous):

No problem, I hope Your project turns out well. Good luck

6 years ago
Similar Questions: