Differences

This shows you the differences between two versions of the page.

--- swdev:sqlite:start [2018/04/26 21:33]
smayr [Create Database]
+++ swdev:sqlite:start [2018/07/18 14:07] (current)
smayr [References]
@@ Line 3: / Line 3: @@
   * [[http://sqlite.org/download.html|SQLite database engine]]
   * [[http://sqlitebrowser.org|DB Browser for SQLite]]
+  * [[https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/|SQLite Manager (Firefox)]]
@@ Line 21: / Line 22: @@
 $ sqlite3 mydatabase.db
 sqlite> CREATE TABLE product (
-   ...>   id int(11) primary key,
+   ...>   id int(11) primary key autoincrement,
-   ...>   name varchar(30)
+   ...>   name varchar,
    ....>  description text,
    ...>   price real
@@ Line 35: / Line 36: @@
 sqlite> .import C:/work/somedata.csv tab1
 </code>
+== Alter Table ==
+<code bash>
+ALTER TABLE table_name
+  ADD new_column_name column_definition;
+</code>
+== SQLite Client ==
+  * [[swdev:sqlite:Custom client in Csharp|Custom client in C#]]
 == References ==
   * CLI: [[http://sqlite.org/cli.html]]
+  * [[https://www.techonthenet.com/sqlite|TechOnTheNet: SQLite]]
+  * [[https://www.scriptol.com/sql/sqlite-async-await.php|SQLite async/await]]
+  * [[https://www.geeksforgeeks.org/using-async-await-in-node-js|Node JS using async/await]]
+  * [[https://github.com/mapbox/node-sqlite3/wiki/API|SQLite3 API for Node JS]]
+  * [[https://github.com/mapbox/node-sqlite3/blob/master/examples/simple-chaining.js|SQLite3 Simple Chaining in Node JS]]