7 ms·
SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.
by thechangelog 15y ago
SQLite all over the place – it's great having a super portable DB format for quick little hits.
There's nothing quite like sending a DB as an email attachment.
- SwellJoe 15y agoSQLite is so pervasive that I'm pretty sure everyone uses it at some point. It's in client applications, it's used by yum (the package manager found on CentOS/RHEL/Scientific Linux systems), it's part of many web applications, it's part of many spam filtering systems, it's part of Android (maybe iOS, too?), it's basically impossible to avoid it if you're a nerd. Also, it's awesome.
- Skroob 15y agoSQLite is indeed built into iOS and Mac OS X as well. Core Data's store uses SQLite as an option (XML and Binary are the others), and it is accessible via third party frameworks like FMDB.
- enjo 15y agoIt's also built into Android.
- sshumaker 15y agoUnfortunately, it's quite slow on Android. And make sure never to put your db on the sdcard, or else your whole phone becomes unusable while doing writes to the db.
- daliusd 15y agoSQLite is overall slow if you are writing item-by-item. Does not matter what platform you use. Write multiple items in single transaction. As well understand what you get and what you loose by writing all items in single transaction.
- gaius 15y agoAnd iPhones, and BlackBerries. It is by far the most widely use relational DB in the world (despite what the MySQL people claim on their website, they're not even close)
- shizcakes 15y agoFirefox uses it.
- rwmj 15y agoIndeed ... http://berrange.com/posts/2011/06/22/firefox-form-data-history-a-goldmine-of-unencrypted-sensitive-personal-data/ http://berrange.com/posts/2011/06/22/firefox-form-data-histo...
- theanti9 15y agoSo does Chrome
- nakkiel 15y agoSo does Chrome. Actually, this comes in handy: http://sqlite.org/famous.html http://sqlite.org/famous.html
- vijaydev 15y agoSo good to see Sun's logo there :)
- alextingle 15y agoThey should replace it with Oracle's logo now. Just for giggles.
- paulnelligan 15y agoOuch, Php got a mention, but they snubbed Rails, despite the fact that it comes bundled ... DHH won't like that one bit!
- deleted 15y ago[deleted]
- chrisjsmith 15y agoAlso damn useful when plugged into NHibernate for bringing up test cases using in memory databases for performance.
- michaelschade 15y agoLove SQLite when doing some Django development. Great to easily scrap the database with a quick `rm` and repopulate with good data.
- sc68cal 15y agoI've been breaking myself of that habit: I try and use the flush command so I don't have to keep doing the superuser creation step. https://docs.djangoproject.com/en/dev/ref/django-admin/?from=olddocs#flush https://docs.djangoproject.com/en/dev/ref/django-admin/?from...
- michaelschade 15y agoGood point, as the superuser creation bit does tend to get annoying. But you have to admit–there's something much more fun about getting to rm your db ;)
- gusi 15y agoyeah, but if you are modifying the schema and are not using south or something like that, you will still want to rm & syncdb again....
- gord 15y agoFor me JSON has replaced SQLLite, with a large reduction in code and complexity. [ Admittedly I've written my own routines to access it more simply/directly on iOS ]
- mmaunder 15y agoYeah and like HTML5 has totally replaced our web server.
- jemfinch 15y agoHe means a flat file of JSON records. Your sarcasm is unnecessary and uncharitable.
- deleted 15y ago[deleted]
- stfp 15y agoAND fun
- sausagefeet 15y agoHow do you know he means that?
- jemfinch 15y agoBecause it's the only interpretation that makes sense, and charitable discussion demands that I assume my interlocutors are reasonable people who say things that make sense until I have evidence to the contrary.
- statictype 15y agoThe sarcasm was perhaps a little mean but he has a point. If a flat text file storing JSON could replace your database, then you probably never needed a DB in the first place.
- dorkitude 15y agoIt's also worth noting that SQLite is, for the time being, the underlying store for Membase
- eipipuz 15y agoYou mean the eventual persistance store.
- lukencode 15y agoIn the microsoft world SQL CE 4 is pretty nice for doing the same sort of thing.
- josephcooney 15y agoI still much prefer to use SQLite on the MS stack, given how reliable and ubiquitous it is.
- sharjeel 15y agoIn some scenarios I prefer Microsoft Excel over SQLite. Yes, Excel can be used as a database as well!
- arethuza 15y agoDo you mean as a database engine using the ODBC driver for Excel or as a database-like application?
- farktronix 15y agoAgreed. SQLite also has a great copyright notice in its headers: ** The author disclaims copyright to this source code. In place of ** a legal notice, here is a blessing: ** ** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. (http://www.sqlite.org/src/artifact?name=a8571665d43ff18f89a49d47a281605ce5ea825e http://www.sqlite.org/src/artifact?name=a8571665d43ff18f89a4...)