[LostIt]

I needed to be able to read the XBMC databases in a program of mine but I couldn't find anything that worked (for Free.) I did, however, stumble onto someone else's tutorial on how to convert the SQLite dll source so that when compiled it's usable in VB. Their tutorial had a few errors and was also missing some needed information to successfully complete the project so I wrote my own tutorial.

I also wrote a test application in VB6 briefly giving an example of how to use the new DLL.

The tutorial and all related files (Sources and Binaries) can be found on this page
SQLite3VB - Making SQLite VB Compatible

Hope this helps someone as much as it's helped me.

[evilhomeruk]

That's an interesting guide, nice one.

I was interested in having a peep at my XBMC music db and used both Perl and Python to probe them, both are free solutions.

Python ran a lot faster than my perl one, but I chose Perl first because it comes pre-build with the SQLite plugins.

I got a pre-built sqlite-python addon for python and my little programme below worked out of the box.

from pysqlite2 import dbapi2 as sqlite

con = sqlite.connect("MyMusic6.db")

# Get a Cursor object that operates in the context of Connection con:
cur = con.cursor()

# Execute the SELECT statement:
#
# example one, list of genres
#
#cur.execute("SELECT idGenre,strGenre FROM genre Order by idGenre")
#
# example two, old songs
cur.execute("select * from songview WHERE iyear < 1970")

# Retrieve all rows as a sequence and print that sequence:
print cur.fetchall()