Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Rqlite v4.0 – With node-to-node encryption

github.com

Post reply on HN
Print view View original

11–20 of 24 posts

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#11

Post by simlevesque »

reitanqild wrote: post #10
bauerd wrote: post #7

Congrats on the release! A bit unrelated, but the README says Windows is an officially supported platform, and I've seen this be the case on many Go projects. I know very little about the Windows platform, can you comment on how painless supporting Windows is really with Go? Do you have e.g. CI runs on Windows? With most of the compiled stuff I worked on Windows was mostly an afterthought and always yes-it-should-run…

I know very little about the Windows platform As someone who started in the 90ies this makes me smile. Year of the linux desktop or not: something has changed. (Quite aware that the bauerd might be using something else.)

He could be a Mac user for all we know.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#12

Post by cmorelli »

Honest question: why would I want a distributed scale-out RDBMS based on SQLite when there are others based on more performant server-based solutions (see Citus for PostgreSQL, Galera for MySQL, etc)

My understanding/recollection of SQLite is that it has significant performance issues with high concurrency. Great for a database on a pocket device, not the best choice for a horizontal scale-out high-concurrency system. At what point do I need horizontal scalability, but not care about concurrency on any one node?

Again, honest question - I'm not doubting the project or its value, I just don't get it.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#13

Post by reitanqild »

simlevesque wrote: post #11
reitanqild wrote: post #10

Earlier quoted context omitted.

I know very little about the Windows platform As someone who started in the 90ies this makes me smile. Year of the linux desktop or not: something has changed. (Quite aware that the bauerd might be using something else.)

He could be a Mac user for all we know.

Yes, I tried to mention that.

My point is the Windows monopoly is almost broken and I think everyone including Windows users benefit from that.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#14

Post by hamandcheese »

cmorelli wrote: post #12

Honest question: why would I want a distributed scale-out RDBMS based on SQLite when there are others based on more performant server-based solutions (see Citus for PostgreSQL, Galera for MySQL, etc) My understanding/recollection of SQLite is that it has significant performance issues with high concurrency. Great for a database on a pocket device, not the best choice for a horizontal scale-out high-concurrency system…

I think you're misunderstanding the goals of the project. It's not to create a horizontally scalable DB. Write perflrmance will not scale horizontally at all with this database.

The goal is to create something more like an etcd that can hold structured data.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#15

Post by justinsaccount »

cmorelli wrote: post #12

Honest question: why would I want a distributed scale-out RDBMS based on SQLite when there are others based on more performant server-based solutions (see Citus for PostgreSQL, Galera for MySQL, etc) My understanding/recollection of SQLite is that it has significant performance issues with high concurrency. Great for a database on a pocket device, not the best choice for a horizontal scale-out high-concurrency system…

From the README:

Why?

rqlite gives you the functionality of a rock solid, fault-tolerant, replicated relational database, but with very easy installation, deployment, and operation. With it you've got a lightweight and reliable distributed relational data store. Think etcd or Consul, but with relational data modelling also available.

You could use rqlite as part of a larger system, as a central store for some critical relational data, without having to run a heavier solution like MySQL.

Performance

rqlite replicates SQLite for fault-tolerance. It does not replicate it for performance. In fact performance is reduced somewhat due to the network round-trips.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#16

Post by otoolep »

bauerd wrote: post #7

Congrats on the release! A bit unrelated, but the README says Windows is an officially supported platform, and I've seen this be the case on many Go projects. I know very little about the Windows platform, can you comment on how painless supporting Windows is really with Go? Do you have e.g. CI runs on Windows? With most of the compiled stuff I worked on Windows was mostly an afterthought and always yes-it-should-run…

Yes, the project employs Appveyor to ensure that the project can be built on Windows at all times.

https://github.com/rqlite/rqlite/blob/master/appveyor.yml

https://ci.appveyor.com/project/otoolep/rqlite

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#18

Post by otoolep »

rcarmo wrote: post #6
v4n4d1s wrote: post #4

Can this be used as a "drop-in" replacement for sqlite or do I have to modify my application for it?

For Python at least, there's a "normal" driver that is pretty much a drop-in. Am curious as to how it will work in practice myself, since I usually rely on an ORM these days.

You can find various client libraries here: https://github.com/rqlite

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#19

Post by krylon »

reitanqild wrote: post #13
simlevesque wrote: post #11

Earlier quoted context omitted.

He could be a Mac user for all we know.

Yes, I tried to mention that. My point is the Windows monopoly is almost broken and I think everyone including Windows users benefit from that.

> the Windows monopoly is almost broken

Oh, how I wish that were true.

In some areas, yes, but there so many line-of-business applications that are only available for Windows that even if Microsoft stopped developing Windows, people would continue to use it for a very long time.

I am not at all a fan of Steven Ballmer, but he got it right - if you get the developers to flock to your platform, you win. Microsoft did that in the desktop space, Apple did it in the mobile space.

Re: Show HN: Rqlite v4.0 – With node-to-node encryption

#20

Post by otoolep »

hamandcheese wrote: post #14
cmorelli wrote: post #12

Honest question: why would I want a distributed scale-out RDBMS based on SQLite when there are others based on more performant server-based solutions (see Citus for PostgreSQL, Galera for MySQL, etc) My understanding/recollection of SQLite is that it has significant performance issues with high concurrency. Great for a database on a pocket device, not the best choice for a horizontal scale-out high-concurrency system…

I think you're misunderstanding the goals of the project. It's not to create a horizontally scalable DB. Write perflrmance will not scale horizontally at all with this database. The goal is to create something more like an etcd that can hold structured data.

Exactly.
Post reply on HN