README.md

Copyright(c) 2020-
Author: Chaitanya Tejaswi (github.com/CRTejaswi)    License: GPL v3.0+

Databases

Personal notes.

Index

• Setup
• Templates
• Challenges
• SQLite

Setup

SQLite

SQLServer

MySQL

PostGreSQL

MongoDB

Templates

• TASK: Write classes to CRUD SQL databases. (Entries are from this dataset.)

SQLite

• Implement outCsv method.
• Modify methods to automate CRUDing using a CSV file.

Challenges

Refer: [1] [2]

SQLite

Task	Command
Open file	sqlite3 file.db
	.open file.db
Exit	.exit
List all commands	.help
List all databases	.database
List tables from current database	.table [PATTERN]
Show structure of all tables	.fullschema
Show structure of a table	.schema TABLENAME
Save query-results (one/more) to file	.once FILENAME
	.output FILENAME
Execute SQL queries from file	.read FILENAME