Our great sponsors
-
PostgreSQL
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
sqlitebrowser
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
In Go, you need to install the go-sqlite3 package first. After that, it’s pretty straightforward to use as well:
However, despite of all the positive aspects of SQLite there are also some disadvantages. Without doubt, the most important one is that SQLite does not allow concurrent writing processes (reading is no problem). If concurrent writing is what you need, you can take a look at PostgreSQL, which is also open-source. Also, SQLite databases has limited data types (e.g. missing a type for dates or times) and its SQL dialect has some limitations compared to standard SQL.
SQLite database files are a recommended storage format by the US Library of Congress and a popular and excellent choice as an Application File Format. For instance, let’s say you are writing a Contacts app for smartphones. Besides a pretty user interface you will need a reliable, fast, lightweight database to store your contacts’ data. Et voilà, enter SQLite… And this is precisely what happens. Smartphones, gadgets, desktop applications — there are literally tens of billions of SQLite database files in use daily. To cite only one more example, SQLite is also the default database engine for apps made with Django, a popular Python web framework.
First of all, we should point out that SQLite can also easily be manipulated by non-technical users. There are several, excellent open-source SQLite “browsers” or “editors” available that allow for a graphical user interface to manipulate SQLite databases. Two notable examples are, DB Browser and Sqlite Viewer.