SQLite

SQLite.  What do you think of it?

[ ] Yes, SQLite is sufficient for anus haxxing.
[ ] No, SQLite is insufficient for anus haxxing.

I don't see the difference between this and MySQL.

sqlite is close to being as useful as SQL is going to get. I use it all the time.

>>2
Hush, child. The grownups are talking.

I use SQLite as an embedded database for my program, and it's not bad for that purpose. The untyped storage thing is a bit odd, though.

>>3,4
Cool.  Is there anything about it that would make you guys want to choose a different SQL implementation if you were working on something really important ?

>>5
If database load is so significant that it'd be a good idea to split it off to a separate database server, or if several different applications have to interact with one central database at the same time, I would consider a more ``traditional'' server/client database like Postgres.

I write a lot more applications that use databases in the same way Firefox and progscrape use them, though, for which a serverless SQL implementation like sqlite is perfect.

>>3
say that to my face fucker and not online and see what happens

>>7
I wish I had a face fucker.

>>5
This is really the crucial question. MySQL and Postgres have way too much overhead for a neat little script that only runs on your desktop machine, and SQLite is certainly not beefily robust enough to hold up the weight of the internet all by its lonesome self (ie. you shouldn't run a Rails app on it).

If you've already decided on SQL, then it's just a question of where you're deploying your system, really.

>>9
Are you implying MySQL is beefily robust enough?
Even for the circumstances described in >>6, if my only options were SQLite and MySQL, I'd pick SQLite every single time. Even if it can't deal with concurrency very well, at least it respects the data.

lol y check out http://oggfrog.com/

There's not even a reason to go with MySQL anymore, given the shaky future with Sun/Oracle and the fucking retarded-shit licensing used for its official connectors.

>>12
There was no reason before the Oracle takeover either.

>>5
It's not great at concurrency. I'd use a proper database¹ for a website, unless it's a small website.

IOW, what >>6 said.
__
_{¹ This excludes MySQL.}

>>14
Concurrency is overrated. Multicore programming is a fad.

>>15
Looking forward to your CPUs made entirely out of unobtainium, to keep Moore's law intact without multicores.

>>16
You don't understand Moore's law.

>>17
You haven't looked at the data recently.

20 Name: Anonymous 2011-02-04 18:15

Don't change these.

Name:		Email:
Entire Thread Thread List

All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -