SQLite: the overlooked workhorse
SQLite is the most used database in the world, but mostly unknown. (In this it has a resemblance with Linux.)
SQLite is used in:
- Firefox
- Android
- Skype
- Adobe Reader
- …
Some advantages of SQLite:
- Works with ‘all’ operating systems.
- Most languages have drivers.
- Self contained
- Server-less
- Portable
- No configuration
- Ideally to transfer things from one system to another.
- Perfectly fitted to replace a bunch of configuration files
- Perfect to use with logging.
Makes it a lot easier and faster to find things.
In this presentation I will show how easy it is to use SQLite. I will at least show the usage from Python and Java, but if you would like samples in another language: let me know.
Some of the things I have done with it:
- Logging system metrics.
- Storing measurements.
- Send a new Dutch proverb to someone who wants to learn Dutch.
- Storing messages.
- …
If you would like a particular problem tackled: let me know: I could try to fit it in the presentation.
If you want to reach me about the presentation (before or after T-DOSE):
T-DOSE@Decebal.nl.