Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-23 Thread arief . hasani
Hi, This would be a great combination, good luck with your attempt. If you could, please share with us on the outcome of your experiment and or implementation, should it got into production Cheers -- You received this message because you are subscribed to the Google Groups "H2 Database"

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread Evgenij Ryazanov
Hello. Standalone MVStore is not a database at all. It's just a copy-on-write key-value storage with multiple maps and optional transactions (with TransactionStore). Of course, you can iterate over MVMap from MVStore by your own code and perform some computations, but I guess it's not that you

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread Gopalakrishnan Subramani
Hi, Thank you for your write, this is encouraging, using H2 in RaspberryPIs. Will MVStore support aggregate queries? From H2 Website, I read, MVStore is a default storage engine 1.4 onwards. We want to perform aggregation over sum/count,min/max, etc with Window functionalities, I could not find

[h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread arief . hasani
Hi, If you could go lower level MVStore is your best friend mate, specially with its blazing fast in-memory. I use it at RPi for around 5 millions log records at around 3000 records/min (i batch write every 1 minute write). Row size is around 60 bytes and with compression my data size is a

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-15 Thread Gopalakrishnan Subramani
Yes considered Redis, one issues is that we bring an external server to embedded boards, stop/start/restart issues, database corruptions and issues on unattended systems deployed unknown places, factories on extremely low cost Linux boards. We use Akka framework, with H2 our confident is when we

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-15 Thread stig . christensen
Redis? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-15 Thread Gopalakrishnan Subramani
1. Implementing Aggregation in DB will help in multiple ways, especially when the application crashes and rebooted, we have some source at least. 2. Right now, we use Config file, plan json files, but we would like to encrypt and store them in db so that the files cannot be edited, swapped. Also

[h2] Re: H2 for Raspberry PI and ARM

2019-04-15 Thread stig . christensen
1. Serialize as json/xml and write to a new file each time, read latest file on start-up. Do no use DB for this. 2. Why not keep all in memory (50Mb-100Mb) and do the aggregation calculation on the fly? Do not use a DB for this. mandag den 15. april 2019 kl. 14.47.30 UTC+2 skrev Gopalakrishnan