Question

can anybody know about SQLLITE ??

Answer 1

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

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

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/

Answer 6

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

Answer 7

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