Crate
sql2o
Our great sponsors
| Crate | sql2o | |
|---|---|---|
| 6 | 1 | |
| 3,955 | 1,130 | |
| 1.4% | - | |
| 9.9 | 7.6 | |
| about 9 hours ago | 5 days ago | |
| Java | Java | |
| Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Crate
- FLaNK AI - 01 April 2024
-
Creating an advanced search engine with PostgreSQL
I'm wondering if CrateDB [https://github.com/crate/crate] could fit your use case.
It's a relational SQL database which aims for compatibility with PostgreSQL. Internally it uses Lucene as a storage and such can offer fulltext functionality which is exposed via MATCH.
-
Distributed query execution in CrateDB: What you need to know
A logical execution plan does not take into account the information about data distribution. CrateDB is a distributed database and data is sharded: a table can be split into many parts - so-called shards. Shards can be independently replicated and moved from one node to another. The number of shards a table can have is specified at the time the table is created.
- Parser generators vs. handwritten parsers: surveying major languages in 2021
-
Querying time series data with SQL: examples
PD: If you liked this post... We'd really appreciate a ⭐️ in Github!
-
What is CrateDB? 🤔 FAQ
But there's nothing better than trying things by yourself... So Download CrateDB, experiment, and tell us what you think! 😁
sql2o
-
Are there recommended approach working with Database except Panache/Hibernate ?
Mostly i think because in our Kubernetes - the max resources allocated for single service instance - 2gb ram + 4vcore (2vcore, for 4 there is special agreement process). Under load i often see high memory pressure (gc count, high pauses, etc.). But handling http requests and dealing with CRUD is not a big problem. The huge difference appears during data batch upload into big-data system. The only service which was able to upload it's database faster than 300k record/s+ (peak ingestion) is using https://github.com/aaberg/sql2o + https://vertx.io/docs/vertx-pg-client/java/ . I don't remember numbers for services which use hibernate, but they mostly are very low.
What are some alternatives?
Presto - The official home of the Presto distributed SQL query engine for big data
JDBI - The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
OrientDB - OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries.
jOOQ - jOOQ is the best way to write SQL in Java
MapDB - MapDB provides concurrent Maps, Sets and Queues backed by disk storage or off-heap-memory. It is a fast and easy to use embedded Java database engine.
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
H2 - H2 is an embeddable RDBMS written in Java.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
Querydsl - Unified Queries for Java