current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.
up vote 1 down vote favorite

I am working on a system where I am replacing and existing Cobol system with C#. For the database I have hit some requirement which I am having a hard time to find complete support for (tried SQLite which was not suitable):

  1. Allow Read while locking a record from other Reads
  2. Allow Update (read, modify and write) while locking a record from other Write
  3. Lock database completely for an indefinite amount of time

The system should be accessible from multiple clients both over LAN and also on same workstation.

Any suggestions of DBs which would suit these criteria? Both SQL and NOSQL based are ok...

I am looking for something relatively light weight as the amount of records are < 100000 and maximum 5-10 concurrent clients accessing the DB.

share|improve this question

closed as off-topic by Bart van Ingen Schenau, GlenH7, Dan Pichelman, MichaelT, gnat Oct 6 '14 at 3:47

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking us to recommend a tool, library or favorite off-site resource are off-topic for Programmers as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – Bart van Ingen Schenau, GlenH7, Dan Pichelman, MichaelT, gnat
If this question can be reworded to fit the rules in the help center, please edit the question.
    
meta.programmers.stackexchange.com/questions/6483/… –  gnat Oct 6 '14 at 3:52

1 Answer 1

up vote 1 down vote

Considering the good support for both Relational-based and JSON/Document-based paradigms, PostgreSQL could be a good choice. Here is a reference on the lock modes available: http://www.postgresql.org/docs/9.1/static/explicit-locking.html

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.