Goals: Add links that are reasonable and good explanations of how stuff works. No hype and no vendor content if possible. Practical first-hand accounts of models in prod eagerly sought.
| #!/bin/bash | |
| # A simple script for converting files between CSV and Parquet formats using DuckDB. Requires DuckDB installation. | |
| convert_file() { | |
| local input_file="$1" | |
| local output_extension="$2" | |
| # Extracting the filename without extension | |
| local base_name=$(basename -- "$input_file") | |
| local name="${base_name%.*}" |
| -- When SQLite is compiled with the JSON1 extensions it provides builtin tools | |
| -- for manipulating JSON data stored in the database. | |
| -- This is a gist showing SQLite return query data as a JSON object. | |
| -- https://www.sqlite.org/json1.html | |
| -- An example table with some data | |
| CREATE TABLE users ( | |
| id INTEGER PRIMARY KEY NOT NULL, | |
| full_name TEXT NOT NULL, | |
| email TEXT NOT NULL, |
<hash> with your gist's hash):
# with ssh
git clone [email protected]:<hash>.git mygist
# with httpsgit clone https://gist.github.com/.git mygist
| Write a program that does what it’s supposed to do | |
| Write idiomatic code | |
| Debug a program that you wrote | |
| Debug a program someone else wrote | |
| Debug the interaction between a system you wrote and one you didn’t | |
| File a good bug report | |
| Modify a program you didn’t write | |
| Test a program you wrote | |
| Test a program you didn’t write | |
| Learn a new programming language |