Tag Archives: SQLite

Top 5 Most Popular Databases 2014

While parsing the data for Top 10 Most Popular Programming Languages 2014 I decided to make another chart that would illustrate which are the top 5 most popular databases in 2014.

As I have mentioned in the post above as well, the chart below is nowhere near 100% accurate as there are a lot of variations for each tag.

For my findings I used Stack Overflow’s database to query the posts that were created in 2014, then split and shorted the tags based on how many times they appeared in the posts. After parsing and processing 9307 unique tags with a total of 97386 occurrences, these are the results.

Top 5 Databases 2014

Raw Data

Tag NameTag Count
MySQL54894
SQL-Server25164
MongoDB7605
SQLite5090
PostgreSQL4633

How to create and connect to an SQLite database in C#

The aim of this tutorial is to teach you how to create a new SQLite database from scratch, create a new table in it, insert and read values from it. This is merely an entry level example to give you an idea on how to start.

First you will need System.Data.SQLite library from system.data.sqlite.org. Head over to their download section and download the libraries that best suit your need depending on the .NET Framework you want to target and the Windows bit version.

Extract the file and add System.Data.SQLite.dll as a reference in your project. Keep in mind that SQLite.Interop.dll also needs to be in your executables directory but doesn’t need to be added as a reference in your project. Moreover, if your application is targeting Any CPU it is likely that you will get an exception. So make sure to navigate to Project properties -> Build and set the Platform target to the bit version of the System.Data.SQLite.dll binary you have downloaded.

Visual Studio application build settings - Platform target

Finally, the snippet below should give you the general idea on the main functions you will need to learn first, mainly

  • Creating a file for your database
  • Creating a table in your database
  • Inserting information in the database
  • Retrieving information from the database