Accessing a DB through C..accomplished..

[TheMagicM]

..somewhat.. same concept...

I tried SQLite3 on my linux box..its basically creating a database as a single file..yet it supports a variety of SQL commands..indexes etc.. so I created a silly db just to see if it works..so I modified a example code that opens a the sqlite database, runs a command against it and brings back the result..

SQLite:
http://www.sqlite.org

sample output..

themagicm@linux:~/workspace/test> ./test testdb.db
Usage: ./test DATABASE SQL-STATEMENT
themagicm@linux:~/workspace/test> ./test testdb.db "select * from test;"
name = SideWinder
disk_num = 1
comment = rox
type = G
themagicm@linux:~/workspace/test>

I tried MySQL but am having problems setting it up so I looked around and found this as a good replacement. I'll setup a real db and run some speed tests on it to see how it works under load.
the above url has sample C code that does the above..I used their example and put it in my code to accomplish the above.  (not difficult..pull stuff from example..paste in code..modify to suit needs. LOL)



-Alex

[Karlos]

You should just make a web based front end and use php/mysql. It's a doddle :-D

[TheMagicM]

yea I know.. since I cant get it working properly (MySQL)..I wanted to try this out to see how it works..