I'd like to have an in-memory databaes, that is

  • open-sourced
  • written in C++
  • light-weighted (as I'm to be maintain the code) and
  • C++ code can easily access it calling SQL commands

I hope the speed is fast. Function-wise, I'm only looking into basic CRUD operations, stored procedure support would be a bonus.

Pls kindly recommend.

  • 1
    There is no such thing as a light-weight DBMS - in any language. A DBMS is a large-to-huge, and complex, software system. I would also not entertain the hope of maintaining the code of a DBMS yourself - that's not going to happen. Having said that, if you are interested on working on DBMSes, maybe we should talk (it's my field of research). ... So, essentially, you need to change your requirements or settle for a "no" answer. – einpoklum - reinstate Monica Apr 6 '17 at 20:58
  • how could we talk? – athos Apr 7 '17 at 8:15
  • Agreed. OP does not want to consider mainting the code (why would he?). So, the answer is probably sqlite.org/inmemorydb.html – Mawg Apr 7 '17 at 10:01
  • @Mawg clarify: I do intend to maintain the code. That's why I'm looking into minimum code base and minimum function – athos Apr 7 '17 at 10:21
  • 1
    @athos: (1) Visit chat.stackexchange.com (2) Create an account (3) Enter the chatroom named "einpoklum_and_athos_2017" (4) Write me a message. I should be notified and show up (hopefully quickly, although it depends). – einpoklum - reinstate Monica Apr 7 '17 at 11:01

The closes that I can think is SQLite: https://www.sqlite.org/index.html

But it has not all the feature you need.

  • mind to hint which feature(s) SQLite does not support? – athos Apr 7 '17 at 9:45
  • The main point was "in memory". For which, see sqlite.org/inmemorydb.html – Mawg Apr 7 '17 at 10:24
  • @athos It is written in C, not C++. – user_0 Apr 7 '17 at 10:42
  • @athos would that be a problem for you? – Mawg Apr 9 '17 at 8:42
  • 1
    See my comment 4 above this one - sqlite.org/inmemorydb.html But, are you ok with is being coded in C, or do you insist on C++ ? – Mawg Apr 9 '17 at 13:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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