Mirror of forum.nim-lang.org

3048 :: In-Memory Database

• alfrednewman (orginal) [2017-07-14T05:36:55+02:00] view original

  Hello, Is there any In-Memory Database project around for Nim ? Or any wrapper available for any of these https://githubreviews.com/explore/databases/popular-in-memory ? TIA

---

• sky_khan (orginal) [2017-07-14T08:00:29+02:00] view original

  I dont know any of them on that list but are you aware of that you can use sqlite as in-memory database by just using ":memory:" as database name?

---

• cdome (orginal) [2017-07-14T10:12:30+02:00] view original

  Do

  nimble search XXXX
  Run

  There are definately bindings for redis and several others.

---

• Krux02 (orginal) [2017-07-14T14:36:22+02:00] view original

  Well there are tables all in memory, just not very persistent :P

---

• euant (orginal) [2017-07-14T16:34:11+02:00] view original

  There are semi-official Redis bindings here: https://github.com/nim-lang/redis

  Redis would probably be my recommended approach, as it can do replication and all sorts of fancy things. The semi-official just recently got async support too.

---

• stevo (orginal) [2017-07-15T00:26:30+02:00] view original

  I've recently been working with LMDB. While it is not in memory, it is light weight and uses smart btree based memory mapping. Let me know if you want some examples of how to use it or would like to find out more.

---

• alfrednewman (orginal) [2017-07-16T15:20:07+02:00] view original

  Thank you all !

  @Stevo, can you pls provide some examples of how to use it ?

---

• jlp765 (orginal) [2017-07-17T02:19:21+02:00] view original

  For SQLite, have a look at the doco db_sqlite

  import db_sqlite, math
  
  let theDb = open(":memory:",nil,nil,nil)
  #
  # now do create tables, insert data, select data, ....
  # using SQL (sqlite flavoured)
  #
  theDb.exec(sql"Drop table if exists myTestTbl")
  theDb.exec(sql("""create table myTestTbl (
       Id    INTEGER PRIMARY KEY,
       Name  VARCHAR(50) NOT NULL,
       i     INT(11),
       f     DECIMAL(18,10))"""))
  
  theDb.exec(sql"BEGIN")
  for i in 1..1000:
    theDb.exec(sql"INSERT INTO myTestTbl (name,i,f) VALUES (?,?,?)",
          "Item#" & $i, i, sqrt(i.float))
  theDb.exec(sql"COMMIT")
  
  for x in theDb.fastRows(sql"select * from myTestTbl"):
    echo x
  
  theDb.close()
  
  Run

---