recentpopularlog in

sql

« earlier   
Show HN: SQL Trainer – Learn SQL by doing live data exercises | Hacker News
Some other similar tools from a similar thread: https://news.ycombinator.com/item?id=17905666

Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/

Select STAR SQL - https://selectstarsql.com/

SQL Bolt - https://sqlbolt.com/ - Learn SQL with simple, interactive exercises

SQL Window functions - https://www.windowfunctions.com/

PostgreSQL Exercises - https://pgexercises.com/

SQL Zoo - http://sqlzoo.net/

SQL Teaching - https://www.sqlteaching.com/
sql  via:lena 
2 hours ago by pgt150
Knex Query Lab
Experiment with the knex API to build SQL
playground  orm  javascript  sql 
8 hours ago by bradendouglass
10 Most Useful PostgreSQL Commands with Examples | Postgres Tutorials
SELECT datname,usename,client_addr,client_port FROM pg_stat_activity ;
postgresql  lists  commands  howto  tutorial  sql 
12 hours ago by po
Run SQL directly on CSV files | Text as Data | q
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.

stars: 5435
python  csv  sql  cli  tools  windows  github  via:eriwst 
16 hours ago by Spark
Run SQL directly on CSV files | Text as Data | q
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.
python  csv  sql  cli  tools  windows 
17 hours ago by eriwst
Run SQL directly on CSV files with q | Lobsters
Sqlite can actually read most common CSV directly!
sqlite  tips  sql  lobsters  comment 
20 hours ago by mechazoidal
Run SQL directly on CSV files | Text as Data | q
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs
sql  csv  data 
yesterday by dexter

Copy this bookmark:





to read