open -new followed by the database file name you wish to use: To make SQLite write to a new database file, type. This means that it is not reading from or writing to a file currently. Notice that SQLite is currently using an in-memory database. If you click the sqlite3.exe application, a new window will appear with an interactive SQLite session: For example, to extract the content to the Windows Desktop, select This PC followed by Desktop:Ī new folder should be created at the location you specified containing the SQLite tools: to select a convenient location to extract the archive's content. to bring up a new extract window:Ĭlick Browse. Right-click the file and select Extract All.
Next, open the File Explorer on your computer and navigate to the location of the zip file you downloaded:
The archive file you need is under the Precompiled Binaries for Windows section and begins with sqlite-tools: Visit the SQLite download page to find a link to the zip file. The SQLite project provides a zipped bundle of tools that include the sqlite.exe file that you need to create and interact with SQLite databases from the command line. Prisma is an open-source database toolkit for Typescript and Node.js that aims to make app developers more productive and confident when working with databases.
How to query and filter documents in MongoDB.How to manage databases and collections in MongoDB.How to manage authorization and privileges in MongoDB.How to manage users and authentication in MongoDB.Introduction to provisioning MongoDB Atlas.
How to update existing data with SQLite.How to perform basic queries with `SELECT` with SQLite.Inserting and deleting data with SQLite.Creating and deleting databases and tables with SQLite.An introduction to MySQL column and table constraints.How to create and delete databases and tables in MySQL.An introduction to PostgreSQL column and table constraints.An introduction to PostgreSQL data types.How to create and delete databases and tables in PostgreSQL.How to configure a PostgreSQL database on RDS.
Comparing relational and document databases.Glossary of common database terminology.Comparing database types: how database types evolved to meet different needs.