Do you like the SQL language? Here is the FSQL console tool, that allows you to search files on your local computer using SQL-like queries. Say, the query
$ fsql "SELECT name FROM ~/Downloads WHERE name LIKE %csc%"
returns all the downloaded files that contain "csc" in their name.
#go #cli #sql
https://github.com/kshvmdn/fsql
$ fsql "SELECT name FROM ~/Downloads WHERE name LIKE %csc%"
returns all the downloaded files that contain "csc" in their name.
#go #cli #sql
https://github.com/kshvmdn/fsql
GitHub
GitHub - kashav/fsql: Search for files using a fun query language
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
Release: CockroachDB 2.0 Has Arrived! 🎉
CockroachDB (★ 13037 on GitHub) is the open source, cloud-native SQL database.
CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.
#release #sql #cloud #db
CockroachDB (★ 13037 on GitHub) is the open source, cloud-native SQL database.
CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.
#release #sql #cloud #db
SQL Explain Plan Visualizer by Datadog.
This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:
The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.
#sql #report #analyse #postgresdb #mysql
This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:
EXPLAIN (ANALYSE, FORMAT JSON, VERBOSE, BUFFERS) [your query]The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.
#sql #report #analyse #postgresdb #mysql
👍2