[Locomotive-users] SQLite3 db is "locked" issue

[Scott Tamosunas]

Installing MySQL on a Mac is easy. They have binary packages or you
can compile the source. Have a look at:

http://developer.apple.com/internet/opensource/osdb.html

It should point you in the right direction. Don't use SQLlite.

Scott

On 3/5/07, Eric Baker <ericwaynebaker at gmail.com> wrote:
> Only because the Mac is shared, having an encapsulated Rails
> environment that I can spin up/down easily is ideal. I'm not as competent on
> the Mac as my Win box, but I guess that I can run Mamp (or something
> similar) alongside Locomotive, or am I over-complicating this?
>
> Regards,
>
> Eric
>
>
> On 3/5/07, Lori M Olson <loriolson at mac.com> wrote:
> > The problem here is the database.   Don't use SQLite.  If you started
> > out on Windows using MySQL (as you stated in your first post), then
> > why would you not stick with MySQL?
> >
> > Regards, Lori
> >
> > On 5-Mar-07, at 10:10 AM, Eric Baker wrote:
> >
> > > Wow (that hurts). Thank you for the information. So my question
> > > would then be, do most people used cookie-based sessions when
> > > working with Locomotive?
> > >
> > >
> > >
> > > On 3/5/07, Niko Dittmann < ni-di at web.de> wrote: Hi Eric.
> > >
> > >
> > > The (only really bad IMHO) problem with sqlite is that it doesn't
> > > have row based locking but db (or table?) based locking.  This means,
> > > the whole DB is locked if s/b is writing into one table/row/field.
> > > And the database connector by default give up after the first time
> > > when it tries to write and the DB is locked.  So adding the timeout
> > > option to your database.yml may help _most_ of the time:
> > >
> > > development:
> > >    adapter: sqlite3
> > >    database: db/development.sqlite3
> > >    timeout: 5000
> > >
> > >
> > > timeout is in ms.
> > >
> > > Kind regards, Niko.
> > >
> > >
> > >
> > > _______________________________________________
> > > Locomotive-users mailing list
> > > Locomotive-users at lists.raaum.org
> > >
> http://lists.raaum.org/mailman/listinfo/locomotive-users
> >
> > _______________________________________________
> > Locomotive-users mailing list
> > Locomotive-users at lists.raaum.org
> > http://lists.raaum.org/mailman/listinfo/locomotive-users
> >
>
>
> _______________________________________________
> Locomotive-users mailing list
> Locomotive-users at lists.raaum.org
> http://lists.raaum.org/mailman/listinfo/locomotive-users
>
>