3 ms·
This is very impressive work! Do you plan to make WorldQL highly available? It seems like if it died you'd loose the server.
by gravypod 5y ago
This is very impressive work! Do you plan to make WorldQL highly available? It seems like if it died you'd loose the server.
- Jaxkr 5y agoThank you for your kind words! WorldQL uses Postgres under-the-hood to store permanent information. I was inspired by companies like TimescaleDB which build new functionality on top of Postgres’s rock-solid base. Any high-availability solution for Postgres will also be available for WQL.
- gravypod 5y agoDo the clients of WorldQL (the workers) know how to gracefully fail over when WorldQL fails?
- Jaxkr 5y agoNo. They fail very ungracefully. But it’s something I’m planning to implement in the future.
- xupybd 5y agoDo you use postgis for spatial queries?
- Jaxkr 5y agoNo. All spatial queries use WorldQL’s in-memory k-d tree implementation and are not used for permanent world alterations. For the Minecraft world catch-up example, it’s as simple as querying Postgres for block records in a certain chunk after a certain timestamp. No fancy spatial stuff happens on the Postgres side.
- steve-chavez 5y agoCould yo elaborate on why you don't use PostGIS? I've always assumed its C algorithms are high-performance.