sqlfluff
Apache Cassandra
Our great sponsors
sqlfluff | Apache Cassandra | |
---|---|---|
35 | 35 | |
7,199 | 8,510 | |
2.1% | 0.9% | |
9.6 | 9.9 | |
6 days ago | 2 days ago | |
Python | 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.
sqlfluff
-
🐍🐍 23 issues to grow yourself as an exceptional open-source Python expert 🧑💻 🥇
Repo : https://github.com/sqlfluff/sqlfluff
-
SQL Reserved Words – The Empirical List
I'm surprised sqlfluff hasn't been mentioned yet. Perhaps not a comprehensive list, but it's worked for everything I've thrown at it. There's an ANSI keyword list [0], and then dialect-specific lists for everything from DB2 [1] to Snowflake [2].
[0]: https://github.com/sqlfluff/sqlfluff/blob/main/src/sqlfluff/...
-
Show HN: Postgres Language Server
It has tons of annoying quirks, but I couldn't imagine running a DBT project without it: https://github.com/sqlfluff/sqlfluff
-
Front page news headline scraping data engineering project
Move SQL queries to sql files and read from files (Use sqlfluff to lint the code https://github.com/sqlfluff/sqlfluff)
- Anything like SQLFluff written in Rust?
-
Code autoformatter for SQL in VSCode that plays nicely with dbt
SQLFluff is a good CLI tool for this and includes support for jinja and dbt. I don't think there's a VSCode plugin for it yet.
-
Ask HN: How do you test SQL?
This linter can really enforce some best practices https://github.com/sqlfluff/sqlfluff
A list of best practices:
-
What is something you would learn at college but not a bootcamp (hard skills)
BigQuery SQL and SQLFluff
-
Is the knowledge on how Compilers work applicable to the role of a Data Engineer?
There's a SQL parser/linter called SQLFluff that my team uses for our CI/CD. I've made a few pull requests to fix the parser for the particular SQL dialect we used, and my college compiler classes definitely helped.
-
sqlfluff VS ANTLR - a user suggested alternative
2 projects | 12 Dec 2022
Apache Cassandra
-
How to Choose the Right MQTT Data Storage for Your Next Project
Apache Cassandra{:target="_blank"} is a highly scalable and fault-tolerant database that can handle large volumes of data across multiple nodes or clusters. It provides fast read and write operations, making it suitable for real-time analytics or applications with high throughput requirements.
- 10+ Open-Source Projects For Web Developers In 2023
-
Database 101: Data Consistency for Beginners
Wide Column: Apache Cassandra, ScyllaDB and DynamoDB
-
In One Minute : Hadoop
Cassandra, a replicated, fault-tolerant, decentralized and scalable database system.
-
Build Your First App with JavaScript, Node.js, and DataStax Astra DB
A popular database you might already be familiar with is Apache Cassandra®, which powers high-performing applications for thousands of companies including Hulu, Netflix, Spotify, and Apple. While this free, open-source database is known for its high availability, scalability, and resilience; the downside is that it’s also notoriously complex to set up and manage.
- Reducing logging cost by two orders of magnitude using CLP
-
Baeldung Series Part 2: Build a Dashboard With Cassandra, Astra and CQL – Mapping Event Data
In our previous article, we looked at augmenting our dashboard to store and display individual events from the Avengers using DataStax Astra, a serverless DBaaS powered by Apache Cassandra using Stargate to offer additional APIs for working with it.
-
System Design: CAP theorem
Example: Apache Cassandra, CouchDB.
-
Deploy a TikTok Clone with Node.js, Netlify, and DataStax Astra DB
For our TikTok database, we’re using DataStax Astra DB: a cloud-based database that fully manages Apache Cassandra®, one of the most robust and scalable NoSQL databases around.
-
System Design: The complete course
Data partitioning in Apache Cassandra.
What are some alternatives?
vscode-sqlfluff - An extension to use the sqlfluff linter in vscode.
Druid - Apache Druid: a high performance real-time analytics database.
sqlparse - A non-validating SQL parser module for Python
LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
dbt-utils - Utility functions for dbt projects.
Scylla - NoSQL data store using the seastar framework, compatible with Apache Cassandra
ale - Check syntax in Vim/Neovim asynchronously and fix files, with Language Server Protocol (LSP) support
delta - An open-source storage framework that enables building a Lakehouse architecture with compute engines including Spark, PrestoDB, Flink, Trino, and Hive and APIs
soda-sql - Data profiling, testing, and monitoring for SQL accessible data.
Apache HBase - Apache HBase
Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
Event Store - EventStoreDB, the event-native database. Designed for Event Sourcing, Event-Driven, and Microservices architectures