Difference between revisions of "Relational and non-relational databases"

Revision as of 14:01, 27 August 2013

import sqlite3 import MySQLdb import psycopg2

s_con = sqlite3.connect(database='/tm/student.db')

m_con = MySQLdb.connect(host='localhost', user='student', passwd='student', db='student', )

p_con = psycopg2.connect('host=localhost user=student password=student dbname=student')

s_con.close() m_con.close() p_con.close()

CREATE TABLE test_table (id integer, name varchar(255));

Hosts:

ssh <username>@<host>.scc.kit.edu -p24

@@ Line 1: / Line 1: @@
+import sqlite3
+import MySQLdb
+import psycopg2
+s_con = sqlite3.connect(database='/tm/student.db')
+m_con = MySQLdb.connect(host='localhost', user='student', passwd='student', db='student', )
+p_con = psycopg2.connect('host=localhost user=student password=student dbname=student')
+s_con.close()
+m_con.close()
+p_con.close()
+CREATE TABLE test_table (id integer, name varchar(255));
 Hosts: