Re: Using SQLite as a multi-user database?

2010-11-23 Thread Fredrik Andersson
Björnke von Gierke skrev 2010-11-23 19.24: I think fredrik just uses installed programs and a sqlite file on a network share. Which is a smart way to circumvent "no server" rules, and sqlite seems to be able to do that. Yep, that's how I planned it. Previously I've mostly used text files to h

Re: Using SQLite as a multi-user database?

2010-11-23 Thread Fredrik Andersson
Hehe, Well, no 1 is not an option and no 2 is a bit difficult. I'm making a small in-house application behind the back of the giant IT-department (1500 or so people). If I let them know what I'm up to they might begin to crack down on my (and my other IT-savvy collegues) other applications. W

Re: Using SQLite as a multi-user database?

2010-11-23 Thread Fredrik Andersson
Thanks for the suggestions, I wouldn't have though of that! Unfortunately I don't think I could run any kind of serverlike program on our network. I'm actually contemplating using some kind of lock-file that is created whenever someone is writing to the database (or perhaps I'll even use some

Using SQLite as a multi-user database?

2010-11-23 Thread Fredrik Andersson
Hello, >From reading on the SQLite website I get the impression that it IS possible to >use SQLite as a multi-user database even though it's not its primary purpose. >I recently made a small application that was used by very few people and the >app didn't implode or anything. My question is: D