can anybody know about SQLLITE ??
I worked a lot in SQLite, what do you want to know?
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.
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
As for the syntax it's very similar there shouldn't be any problems. Also I'm not familiar with HSQL
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/
thanku very much sir for your reply this information is very usefull for us.
No problem, I hope Your project turns out well. Good luck
Join our real-time social learning platform and learn together with your friends!