alasql vs swifties

alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel. (by AlaSQL)

Suggest topics

Source Code

alasql.org

Suggest alternative

Edit details

swifties

a custom language construction kit (by codr7)

Suggest topics

Source Code

Suggest alternative

Edit details

SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App

With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

surveyjs.io

featured

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

alasql		swifties
	Project
4	Mentions	5
6,898	Stars	11
0.3%	Growth	-
9.0	Activity	0.0
3 days ago	Latest Commit	over 2 years ago
JavaScript	Language	Swift
MIT License	License	-

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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

Posts with mentions or reviews of alasql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-19.

AlaSQL Db for Browser and Node
1 project | news.ycombinator.com | 30 Apr 2023
Alasql.js – JavaScript SQL database for browser and Node.js
1 project | news.ycombinator.com | 2 Mar 2023
Let's write a compiler, part 5: A code generator
14 projects | news.ycombinator.com | 19 Aug 2021
Hosting SQLite databases on GitHub Pages (or any static file hoster)
11 projects | news.ycombinator.com | 2 May 2021

For similar results, you can use SQL with IndexedDB running fully client-side: https://github.com/agershun/alasql

swifties

Posts with mentions or reviews of swifties. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-19.

Let's write a compiler, part 5: A code generator
14 projects | news.ycombinator.com | 19 Aug 2021

Depends on the complexity of your queries, but if you have a narrow subset that you're interested in, implementing a recursive descent parser for just those parts of the syntax that fits your problem like a glove could be a better solution.
https://github.com/codr7/swifties
Show HN: Swifties – a custom language construction kit in Swift
1 project | news.ycombinator.com | 18 Aug 2021

1 project | news.ycombinator.com | 9 Aug 2021

1 project | news.ycombinator.com | 6 Aug 2021
Let's write a compiler, part 3: A parser
4 projects | news.ycombinator.com | 16 Aug 2021

What few seem to realize is that it's perfectly possible to abstract out some of the work and create an extensible foundation for manual parsers.
Since it's all regular code, you can use the full power of the host language to deal with the problem.
https://github.com/codr7/swifties/blob/main/Sources/Swifties...

What are some alternatives?

When comparing alasql and swifties you can also consider the following projects:

sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages

sqlite-parser - JavaScript implentation of SQLite 3 query parser

sqlparse - A non-validating SQL parser module for Python

langjam

zetasql - ZetaSQL - Analyzer Framework for SQL

pl0c - Self-hosting PL/0 to C compiler to teach basic compiler construction from a practical, hands-on perspective.

go-mysql-server - A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.

rhizome - A JIT for Ruby, implemented in pure Ruby

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

datasette - An open source multi-tool for exploring and publishing data

vitess-sqlparser - simply SQL Parser for Go ( powered by vitess and TiDB )