alasql
Presto
| alasql | Presto | |
|---|---|---|
| 4 | 14 | |
| 6,898 | 15,603 | |
| 0.3% | 0.5% | |
| 9.0 | 9.9 | |
| 3 days ago | 4 days ago | |
| JavaScript | Java | |
| MIT License | Apache License 2.0 |
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.
alasql
- AlaSQL Db for Browser and Node
- Alasql.js – JavaScript SQL database for browser and Node.js
- Let's write a compiler, part 5: A code generator
-
Hosting SQLite databases on GitHub Pages (or any static file hoster)
For similar results, you can use SQL with IndexedDB running fully client-side: https://github.com/agershun/alasql
Presto
-
Multi-Database Support in DuckDB
We have some of this functionality in Presto (https://github.com/prestodb/presto), but it takes fair bit of work to implement it for all the different backends.
-
Rust std:fs slower than Python
Note that glibc has a similar problem in multithreaded contexts. It strands unused memory in thread-local pools, which grows your memory usage over time like a memory leak. We got lower memory usage that didn't grow over time by switching to jemalloc.
Example of this: https://github.com/prestodb/presto/issues/8993
- Ask HN: What are some SQL transpilers?
-
Cheat sheet for quotes usage?
I look at the grammar. Here is preto's grammar which is mostly similar to other sql engines: https://github.com/prestodb/presto/blob/master/presto-parser/src/main/antlr4/com/facebook/presto/sql/parser/SqlBase.g4
-
After a few recent events, opening a Linux terminal in public places is a big no-no
export MVNW_VERBOSE=true git clone https://github.com/prestodb/presto.git cd presto bash ./mvnw clean install
- presto: The official home of the Presto distributed SQL query engine for big data
- Compile the Minecraft Server (Java Edition) to Native with GraalVM Native Image
-
What are y'all learning right now?
more specifically, recently started learning about Presto [paper], and have been diving deeper into [source] code.
-
DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It
Presto
- Let's write a compiler, part 5: A code generator
What are some alternatives?
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
sqlparse - A non-validating SQL parser module for Python
Apache Phoenix - Apache Phoenix
zetasql - ZetaSQL - Analyzer Framework for SQL
Apache Calcite - Apache Calcite
go-mysql-server - A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
JSqlParser - JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
jOOQ - jOOQ is the best way to write SQL in Java
datasette - An open source multi-tool for exploring and publishing data
Spring Data JPA - Simplifies the development of creating a JPA-based data access layer.