Accessing a database simultaneously from multiple applications using Sequel

Question

If I use Sequel in a Ruby app like this:

DB = Sequel.sqlite('testdb.db')

does it make the database shared? Can I acces this same file from a different ruby app AT THE SAME TIME and get the database to perform locking etc?

I'm thinking probably not and i'd have to actually have a separate instance of the database running.

Jeremy Evans · Accepted Answer · 2009-11-25 19:29:19Z

1

Yes, if you use a file backed database, you can access it by multiple processes. They don't even have to be ruby processes. Note that in SQLite, writers block all readers, so multi-process or multi-threaded write performance is not very good.

answered Nov 25, 2009 at 19:29

Jeremy Evans

12.2k31 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mladen Jablanović · Accepted Answer · 2009-11-24 09:59:45Z

0

This is not up to neither Ruby nor Sequel. It's up to sqlite. Take a look at sqlite FAQ, and see whether it answers your question.

answered Nov 24, 2009 at 9:59

Mladen Jablanović

44.2k13 gold badges92 silver badges113 bronze badges

Collectives™ on Stack Overflow

Accessing a database simultaneously from multiple applications using Sequel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related