PySqlLite Database Paths on Windows

[sean d]

This is probably obvious to all who have used pysqlite, but I
experienced problems when trying to set the correct path for a sqlite
database on my Windows box. Here's a summary of what I've found in
case you're having trouble too:

Say you want to store your database at "C:\data\projects\www\wiki20",
with a name of "wiki20db". The correct way to set this in the
turbogears *.cfg file is as follows:

sqlobject.dburi="sqlite:///data/projects/www/wiki20/wiki20db"

I had some difficulty in finding the correct format for the connection
string because I wanted to add 'c:' to the beginning of the path. If
you do try to use 'c:' in the path (e.g.
sqlobject.dburi="sqlite:///C:/data/projects/www/wiki20/wiki20db"), you
will receive an error.

Other correct ways to specify the path:

sqlobject.dburi="sqlite:///./wiki20db"
sqlobject.dburi="sqlite:///wiki20db"

Both of these entries will place the database file at the root of the
drive.

Thanks,

Sean

[Waldemar Osuch]

One more way if the database sits on something different than C:
sqlite://D|data/projects/www/wiki20/wiki20.db

There is PIPE instead of COLON. I wish it was mentioned somwhere in
documentation.

Waldemar

[Uwe Grauer]

Yes, i also had to resolve this for myself.
In fact, the Pipe-Notion for the ':' isn't something which you are aware
of normally.
Could this go into the 20 Minute wiki?
It would even be better sticking a comment into dev.cfg.

Uwe

[sean d]

Thanks for the note on the pipe. I was wondering how to specify a
different drive letter.

[Kevin Dangoor]

On 10/2/05, Uwe Grauer <mailin...@onlinehome.de> wrote:
> Yes, i also had to resolve this for myself.
> In fact, the Pipe-Notion for the ':' isn't something which you are aware
> of normally.
> Could this go into the 20 Minute wiki?
> It would even be better sticking a comment into dev.cfg.

I've just added a note to the config file.

Kevin

--
Kevin Dangoor
Author of the Zesty News RSS newsreader

email: k...@blazingthings.com
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com