Re: [Sqlalchemy-users] trouble creating a new sqlite database

Hi Mike, On Sat, 2006-07-01 at 00:01 -0400, Michael Bayer wrote: > i am mostly in favor of whatever rfc1738 says. > > though its not clear what is. does "foo/bar" mean "/foo/bar" > on disk ? or "/foo/bar" ? its not so clear. > intuition would say the former. however on pretty much any we

Re: [Sqlalchemy-users] trouble creating a new sqlite database

i am mostly in favor of whatever rfc1738 says. though its not clear what is. does "foo/bar" mean "/foo/bar" on disk ? or "/foo/bar" ? its not so clear. intuition would say the former. however on pretty much any web browser ive used, a url such as "file:///somewhere/foo" means the abs

Re: [Sqlalchemy-users] trouble creating a new sqlite database

On Jun 30, 2006, at 2:10 PM, William K. Volkman wrote: > On Thu, 2006-06-29 at 21:05, Daniel Miller wrote: >> Michael Bayer wrote: >>> well, the url is broken out like this: >>> >>> dbtype:// / >> >> Why is the third slash necessary if its not part of the path? I >> think the conventional wa

Re: [Sqlalchemy-users] trouble creating a new sqlite database

On Thu, 2006-06-29 at 21:05, Daniel Miller wrote: > Michael Bayer wrote: > > well, the url is broken out like this: > > > > dbtype:// / > > Why is the third slash necessary if its not part of the path? I think the > conventional way is to parse paths like this: Please refer to http://www.rfc

Re: [Sqlalchemy-users] trouble creating a new sqlite database

Michael Bayer wrote: > well, the url is broken out like this: > > dbtype:// / Why is the third slash necessary if its not part of the path? I think the conventional way is to parse paths like this: dbtype:// Examples: linux absolute (relative to root of current drive on windows): dbtyp

Re: [Sqlalchemy-users] trouble creating a new sqlite database

well, the url is broken out like this: dbtype:// / so when you put four slashes, your database is "/tmp/foo.db". three slashes, your database is "tmp/foo.db". that gets sent to the sqlite engine as the file to use. we can just say, sqlite databases get a slash prepended, unless it st

Re: [Sqlalchemy-users] trouble creating a new sqlite database

OK. I found the problem, but it's not exactly what I'd expect. Apparently, to take a path from the root for an sqlite file you need *four* slashes. sqlite:tmp/foo.db It's nice being able to do relative paths (something that SQLObject's URIs don't let you do), but 4 slashes just seems excessi

[Sqlalchemy-users] trouble creating a new sqlite database

I'm having some trouble making a new sqlite database. I can create in-memory databases just fine, but I can't seem to create one on disk. I am certain that I have permissions to the file i'm trying to create. Unfortunately, the error and the code don't give me anything to work with for troubleshoo