Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 20
Next »
Table of contents
Child pages
Best practices
Specific DBs
MySQL
- How to get your database to allow emojis and other unusual characters:
ALTER DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
SQLite
- Installation
- Go to SQLite3 download page
- Go down to the “Precompiled Binaries For Windows” section.
- Download “sqlite-shell” and “sqlite-dll” archive files.
- sqlite-dll-win64-x64-3160200.zip
- Download the sqlite tools .zip
- sqlite-tools-win32-x86-3160200.zip
- Unpack everything in C:\sqlite folder.
- Add that folder to your PATH.
- Creating the empty .db file:
- Hit the Windows key, type 'cmd', then right-click the 'Command Prompt' result and select 'Run as Administrator'.
- Navigate to the folder where you want the db to be.
- Type 'sqlite3 name_of_the_db.db' and hit 'Enter'.
- Simple example of a schema file:
CREATE TABLE salespeople (
id INTEGER PRIMARY KEY,
first_name TEXT NOT NULL,
last_name TEXT NOT NULL,
commission_rate REAL NOT NULL
);
Good to know
- SQLite will allow you to insert a string into an integer field. (Source)
MongoDB
Using MongoDB:
- Import a bson file into your Mongo /data/ folder: mongorestore -d db_name -c collection_name "C:\path\to\export.bson"
- Make sure to add your MongoDB's 'bin' folder to the PATH to get mongorestore to work from a command prompt.
- Run Mongod: "C:\Program Files\MongoDB\Server\4.0\bin\mongod.exe" --dbpath="c:\data\db"
- Run MongoDB shell: "C:\Program Files\MongoDB\Server\4.0\bin\mongo.exe"
- Show list of dbs: 'show dbs'
- Switch to using a particular db: 'use <db>'
- Show list of collections for the active db: 'show collections'
- Get all records from a particular collection once you're switched to a particular db: 'db.<collection_name>.find()'