Ask your own question, for FREE!
Computer Science
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
Can't find your answer? Make a FREE account and ask your own question, OR you can help others and earn volunteer hours!
Latest Questions
MrMudd183: boooooooooored
45 minutes ago 0 Replies 0 Medals
lilywolfuchiha: Which expression is equivalent to 36/25 sqrt
52 minutes ago 0 Replies 0 Medals
iamjustmea: "My love is like a red, red rose" is a simile.
3 hours ago 13 Replies 2 Medals
iamjustmea: The most common foot in English poetry is the _
3 hours ago 0 Replies 0 Medals
lindey: Given the system mc022-1.jpg, which is true?
1 hour ago 2 Replies 1 Medal