sqlite expert professional what version of sqlite

TablePlus includes a lot of security to protect your database, including native … TablePlus is a native app that allows you to easily edit database information and structure. PRO Edition adds Report Editor and Form Editor with JavaScripting and dozens … See Version Numbers in SQLite on the SQLite website for more information about this.Īlso, here’s a History of SQLite Releases in case you’re interested.Best list of SQLite Professional Alternatives in 2022ĭB Browser for SQLite (DB4S) is a high quality, visual open source tool for creating, designing and editing database files compatible with SQLite.įREE native database manager for SQLite, MySQL, PostgreSQL, SQL Server and Valentina DB.

Prior to version 3.9.0, SQLite employed a version identifier that contained between two and four numbers. Starting from version 3.9.0, SQLite uses semantic versioning, which presents the major version number, followed by the minor version number, followed by the patch number. Result on my system: 3.28.0 Numbering System If you’re already connected to SQLite, you can find out which version it is with the version_number() function. sqlite3 -version The version_number() Function You can also use the following command if you just want to check the version without actually connecting to SQLite. However, once connected, you then see the full version number. Perhaps slightly paradoxically, this obviously requires that you enter the major version number anyway. Use '.open FILENAME' to reopen on a persistent database.

Result on my system: SQLite version 3.28.0 14:49:49Ĭonnected to a transient in-memory database. When you first connect to SQLite using a command line interface (such as Terminal on the Mac), the first thing you should see is the version number. In any case, if you found this page, maybe you need another method to check your SQLite version. Here are a few ways to check your version of SQLite.Īctually, you probably already saw which version you were using when you connected to SQLite.

Sqlite expert professional what version of sqlite