Metabase is the easy, open source way for everyone in your company to ask questions and learn from data.

Features:
- 5 minute setup (We're not kidding)
- Let anyone on your team ask questions without knowing SQL
- Rich beautiful dashboards with auto refresh and fullscreen
- SQL Mode for analysts and data pros
- Create canonical segments and metrics for your team to use
- Send data to Slack or email on a schedule with Pulses
- View data in Slack anytime with MetaBot
- Humanize data for your team by renaming, annotating and hiding fields
- See changes in your data with alerts

#clojure, #dashboard, #sql, #database, #data, #postgres, #metabase

SQLDelight generates typesafe kotlin APIs from your SQL statements. It verifies your schema, statements, and migrations at compile-time and provides IDE features like autocomplete and refactoring which make writing and maintaining SQL simple.

#kotlin, #jvm, #sql

cloudquery transforms your cloud infrastructure into queryable SQL tables for easy monitoring, governance and security.

cloudquery pulls, normalize, expose and monitor your cloud infrastructure and SaaS apps as SQL database. This abstracts various scattered APIs enabling you to define security,governance,cost and compliance policies with SQL.

#golang, #go, #sql, #database, #cloud, #infrastructure

rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Forming a cluster is very straightforward, it gracefully handles leader elections, and tolerates failures of machines, including the leader. rqlite is available for Linux, macOS, and Microsoft Windows.

#golang, #go, #sqlite, #sql, #database

sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester, and a broad range of switches including database fingerprinting, over data fetching from the database, accessing the underlying file system, and executing commands on the operating system via out-of-band connections.

#python, #database, #sql, #injection, #pentesting, #exploitation, #sqlmap, #takeover, #scanner

Litestream is a standalone streaming replication tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.

#golang, #go, #replication, #sql, #s3, #streaming

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

#python #orm #sql #database #toollkit

Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size and publish that as an interactive, explorable website and accompanying API.

#python #docker #json #csv #sql #datasets #asgi #api

Devops Exercises.

Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elastic, Network, Virtualization. DevOps Interview Questions.

#python #devops #git #linux #docker #kubernetes #aws #ansible #sql #azure #containers #terraform #openstack #interview #prometheus #coding #sre

The Internals of PostgreSQL.

PostgreSQL is an open source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works with each other cooperatively. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity prevent it. The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

#article #postgres #sql #book

Understand Group by in Django with SQL.

Aggregation is a source of confusion in any type of ORM and Django is no different. The documentation provides a variety of examples and cheat-sheets that demonstrate how to group and aggregate data using the ORM, but author of this article decided to approach this from a different angle.

#python #django #sql #orm #groupby #aggregation

SQLFluff is a dialect-flexible and configurable SQL linter. Designed with ELT applications in mind, SQLFluff also works with jinja templating and dbt. SQLFluff will auto-fix most linting errors, allowing you to focus your time on what matters.

#python #sql #linter #formatter

Directus is a real-time API and App dashboard for managing SQL database content.

- Free & open-source. No artificial limitations, vendor lock-in, or hidden pricing.
- REST & GraphQL API. Instantly adds a blazingly fast Node.js API layer to your database.
- Manage pure SQL. Works with existing SQL databases, or helps build new architectures from scratch.
- Choose your database. Supports PostgreSQL, MySQL, SQLite, OracleDB, MariaDB and MS-SQL.
- Allows self-hosting. Choose your hosting and infrastructure, run locally, or deeply integrate on-premises.
- Completely extensible. Built to white-label, it is easy to customize our modular platform.
- A modern dashboard. A Vue.js Admin App so safe and intuitive, non-technical users require no training.

#typescript #ts #data #platform #sql #databse #realtime #graphql #api #cms #vue #content