Ask your own question, for FREE!
Computer Science 21 Online
OpenStudy (anonymous):

can anybody know about SQLLITE ??

OpenStudy (anonymous):

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

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.

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

OpenStudy (anonymous):

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

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/

OpenStudy (anonymous):

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

OpenStudy (anonymous):

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

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Latest Questions
kaelynw: who should I draw (anime characters)
19 minutes ago 12 Replies 2 Medals
kaelynw: should I post my art?
3 hours ago 11 Replies 3 Medals
danielfootball123: Question.... How much is questioncove worth if I were to buy it?
7 hours ago 5 Replies 0 Medals
HeyItsAlicia: Mits midnight!!! Happy 16th bday to me !!
4 hours ago 39 Replies 8 Medals
XShawtyX: Art
2 hours ago 2 Replies 1 Medal
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!