The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 9 HTML SQL Projects
-
System.Linq.Dynamic.Core
The .NET Standard / .NET Core version from the System Linq Dynamic functionality.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
Podje.li
Podjeli is file sharing on your terms, encode your file into URLs. SPA written in JavaScript with JQuery.
-
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.
-
graphql-w-persistent
This is an updates page and an example repository for the GraphQL SQL database service package graphql-w-persistent.
Project mention: Postgres + Marten + DynamicLinq... Exceptions after upgrad to NET 6 | /r/dotnet | 2023-07-06We have an app that was written with core 3.1 and uses Postgres and Marten to create a document store. I have several tables with filtering functionality that uses DymanicLinq (https://dynamic-linq.net/) to generate queries. As 3.1 is EOL, we are upgrading to NET 6 but doing so seems to have broken the queries. I now get exceptions saying the Specified Method is unsupported. Anyone have any idea how to fix this?
Project mention: Loading a trillion rows of weather data into TimescaleDB | news.ycombinator.com | 2024-04-16TimescaleDB primarily serves operational use cases: Developers building products on top of live data, where you are regularly streaming in fresh data, and you often know what many queries look like a priori, because those are powering your live APIs, dashboards, and product experience.
That's different from a data warehouse or many traditional "OLAP" use cases, where you might dump a big dataset statically, and then people will occasionally do ad-hoc queries against it. This is the big weather dataset file sitting on your desktop that you occasionally query while on holidays.
So it's less about "can you store weather data", but what does that use case look like? How are the queries shaped? Are you saving a single dataset for ad-hoc queries across the entire dataset, or continuously streaming in new data, and aging out or de-prioritizing old data?
In most of the products we serve, customers are often interested in recent data in a very granular format ("shallow and wide"), or longer historical queries along a well defined axis ("deep and narrow").
For example, this is where the benefits of TimescaleDB's segmented columnar compression emerges. It optimizes for those queries which are very common in your application, e.g., an IoT application that groups by or selected by deviceID, crypto/fintech analysis based on the ticker symbol, product analytics based on tenantID, etc.
If you look at Clickbench, what most of the queries say are: Scan ALL the data in your database, and GROUP BY one of the 100 columns in the web analytics logs.
- https://github.com/ClickHouse/ClickBench/blob/main/clickhous...
There are almost no time-predicates in the benchmark that Clickhouse created, but perhaps that is not surprising given it was designed for ad-hoc weblog analytics at Yandex.
So yes, Timescale serves many products today that use weather data, but has made different choices than Clickhouse (or things like DuckDB, pg_analytics, etc) to serve those more operational use cases.
Project mention: Backdoor in upstream xz/liblzma leading to SSH server compromise | news.ycombinator.com | 2024-03-29clickhouse has pretty good github_events dataset on their playground that folks can use to do some research - some info on the dataset https://ghe.clickhouse.tech/
Example of what user JiaT75 did so far:
https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...
pull requests mentioning xz, 5.6 without downgrade, cve being mentioned in the last 60 days:
https://play.clickhouse.com/play?user=play#U0VMRUNUIGNyZWF0Z...
HTML SQL related posts
- Everything You Always Wanted to Know About GitHub (But Were Afraid to Ask)
- Stargazers intersections for most popular GitHub projects in Venn diagrams
- Everything You Always Wanted to Know About GitHub (But Were Afraid to Ask)
- Getting 10TB of GitHub Logs and Extracting Details of All Users and Repositories
- ServerLess OLAP with Chdb
- Everything you always wanted to know about GitHub (but were afraid to ask)
- Everything You Always Wanted to Know About GitHub (But Were Afraid to Ask)
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Index
What are some of the best open-source SQL projects in HTML? This list will help you:
Project | Stars | |
---|---|---|
1 | System.Linq.Dynamic.Core | 1,500 |
2 | ClickBench | 570 |
3 | introduction-to-sql | 287 |
4 | github-explorer | 129 |
5 | chadbaldwin.github.io | 26 |
6 | scanSQL | 20 |
7 | Podje.li | 17 |
8 | DevDum | 11 |
9 | graphql-w-persistent | 10 |
Sponsored