₦airaland Forum

I hav'nt considered sqlite, but now I think I will be needing it for some of my android apps. There is this our family computer (windows xp ) with python 3.3.3 running on it.

I import sqlite3, and try to create a simple database but not working... so please if you've ever created any successfully drop the code here. In otherwords, drop a working code for creating a simple database with the sqlite3 module.

Thanks.

Nobody?

badthinds:
I hav'nt considered sqlite, but now I think I will be needing it for some of my android apps. There is this our family computer (windows xp ) with python 3.3.3 running on it.

I import sqlite3, and try to create a simple database but not working... so please if you've ever created any successfully drop the code here. In otherwords, drop a working code for creating a simple database with the sqlite3 module.

Thanks.

i dont see why there should be a problem comnecting python with sqlite, although i havnt tried it in python 3, im sure of 2.7. however, you cannot just ask to be helped without showing the code you have actually tried, while we go through it and tell you your errors .
however, the normal syntax should be

#!/usr/bin/python
import sqlite3
conn = sqlite3.connect('test.db')

A Google search would answer your question.

sleepingdemon:
i dont see why there should be a problem comnecting python with sqlite, although i havnt tried it in python 3, im sure of 2.7. however, you cannot just ask to be helped without showing the code you have actually tried, while we go through it and tell you your errors .
however, the normal syntax should be

#!/usr/bin/python
import sqlite3
conn = sqlite3.connect('test.db')

Umm.. I think I have thesame problem with OP. now with test.db how do you store maybe a name and password there?

conn.write("name: this is my name"
type conn. Then hit ctrl + space bar, you will see all available methods.

logicalhumour:
Umm.. I think I have thesame problem with OP. now with test.db how do you store maybe a name and password there?

to store a username or password, you would have to first of all create a database table inside the test.db with coloums username and password using the create table if not exist command as you would do in normal mysql

pls any python whatsapp group..here's my number 08178275529

Please read about Python's DB API specification at https://www.python.org/dev/peps/pep-0249/
.

It is a uniform API for all standards compliant database adapters for Python.