Flat file DB guidance

[Hamster]

Hamster gets herpes when it comes to Redis, we've been through numerous discussions about it.

Only if it is a small project not in need of another server component running, just like etcd isn't the ideal config solution. Sometimes a low-tech solution like sqlite is enough, but I'm a simpleton from the I-hate-yet-another-bloody-point-of-failure Village

 

[Hamster]

This is one of my arrays:

array (size=1)
  0 => 
    array (size=16)
      'id' => string '888357114685955' (length=15)
      't' => string 'DBXWD' (length=5)
      'e' => string 'JSE' (length=3)
      'l' => string '2,426.00' (length=8)
      'l_fix' => string '2426.00' (length=7)
      'l_cur' => string 'ZAC2,426.00' (length=11)
      's' => string '0' (length=1)
      'ltt' => string '3:29PM GMT+2' (length=12)
      'lt' => string 'Dec 12, 3:29PM GMT+2' (length=20)
      'lt_dts' => string '2016-12-12T15:29:11Z' (length=20)
      'c' => string '+17.00' (length=6)
      'c_fix' => string '17.00' (length=5)
      'cp' => string '0.71' (length=4)
      'cp_fix' => string '0.71' (length=4)
      'ccol' => string 'chg' (length=3)
      'pcls_fix' => string '2409' (length=4)

If I want ZAC2,426.00 to display as R 2 426 I assume I will have to do preg_replace correct?

Or just use the l_fix value?

 

[Thor]

Or just use the l_fix value?

how on earth did I miss that. Tad bit embarrassing, guess staying awake the whole time is in fact bad.

 

[Batista]

Just use MYSQL db with WAMP, no reason in this day and age to not use a proper database.

 

[Hamster]

1 step forward, 5 years back...

 

[Hamish McPanji]

Just use MYSQL db with WAMP, no reason in this day and age to not use a proper database.

Maybe the idea is not to use a database for fast changing Information only

 

[Batista]

Maybe the idea is not to use a database for fast changing Information only

That is something I wouldnt do, writing to flat files, what about multiple users.

 

[Thor]

That is something I wouldnt do, writing to flat files, what about multiple users.

Won't affect the users if they read from the file only. It is just the cronjob that will write to the file.

BUT I have opted for memory in this case

https://dev.mysql.com/doc/refman/5.6/en/memory-storage-engine.html

 

[Hamish McPanji]

That is something I wouldnt do, writing to flat files, what about multiple users.

If it's cached in memory, as discussed earlier in this thread, it will be quick, and multi users wouldn't have an issue

 

[animal531]

Only if it is a small project not in need of another server component running, just like etcd isn't the ideal config solution. Sometimes a low-tech solution like sqlite is enough, but I'm a simpleton from the I-hate-yet-another-bloody-point-of-failure Village

Hehe, yeah my biggest issue with it last time I played with it was having to install a service, since I was looking at a desktop app that just needed some local storage.
I ended up using LMDB which suited my needs nicely...I could just compile it straight into my app.