SQLite: the overlooked workhorse

  • Posted on: 2 October 2015
  • By: CecilWesterhof
Track: 
Software Development
Day: 
Sunday
Author: 
Cecil Westerhof
Room: 
Track 3 (right)
Undefined
Paper: 

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.

Time: 
11:00 - 12:00 hrs
field_vote: 
0
No votes yet