If you need a sample database to run some quick tests in SQLite, here are a couple of options.
SQLite uses a different syntax for creating databases to what many other relational database management systems use.
Most of the popular relational database management systems such as MySQL, SQL Server, PostgreSQL, and so on, use the CREATE DATABASE statement to create a database.
When you create a database with SQLite however, you do so by simply providing a filename.
When you create a table in SQLite, you can create it as a permanent table or as a temporary table.
When you create a table in a database that you’ve created, that would be a permanent table. A temporary table is created in the temp database.
To create a temporary table, you use the same syntax as creating a regular table. The difference is that you use either the TEMP or TEMPORARY keyword. You can also (or alternatively) prefix the table name with temp, which indicates that it will be created in the temporary database.
When using SQLite, you can use the ATTACH DATABASE statement to add a database file to the current database connection.
When you do this, you attach a database file name and provide a name for the database. If the file exists it will be attached with your chosen name, otherwise it will be created and attached with your chosen name.
In PostgreSQL you can use the EXTRACT() function to get the month from a date.
You can also use the DATE_PART() function to do the same thing.
You can use the following code examples in PostgreSQL if you have a month number but you want the month name instead.
In PostgreSQL, if you already have a month name, but you want to convert that name to the month number, you can do this with the EXTRACT() function.