Turns out SQL SELECT statements are more powerful than I thought, you could basically use them as a calculator or for manipulating dates and they don't necessarily need to fetch data, you can use them just for calculations and depending on your db there are a lot of functions you could use within them.
#SQL #Databases #PostgreSQL
#SQL #Databases #PostgreSQL
๐3
A couple of weeks ago the wonderful people at Execute Program gave me free access ๐๐ to their SQL course and I am happy to report that I have finished the course.
I finished all 212 code examples in Execute Program's SQL course!
https://www.executeprogram.com/courses/sql
#Databases #SQL
I finished all 212 code examples in Execute Program's SQL course!
https://www.executeprogram.com/courses/sql
#Databases #SQL
Executeprogram
Execute Program
Learn it. Code it. Remember it.
๐6๐1
Frectonz
My nixpkgs PR got merged after 2 weeks. I packaged my ethiopian calendar TUI app mekuteriya for nix. nix shell nixpkgs#mekuteriya I'm officially a NixOS package maintainer now. https://github.com/NixOS/nixpkgs/pull/333690 ๐๐๐
After one failed PR and more than 2 months of waiting. My SQL Studio PR got merged into nixpkgs.
SQL Studio is now available in the nix distribution. Nix users can now use the following command to run SQL Studio.
https://github.com/NixOS/nixpkgs/pull/341807
๐๐๐
SQL Studio is now available in the nix distribution. Nix users can now use the following command to run SQL Studio.
nix run nixpkgs#sql-studio
https://github.com/NixOS/nixpkgs/pull/341807
๐๐๐
GitHub
sql-studio: init at 0.1.27 by frectonz ยท Pull Request #341807 ยท NixOS/nixpkgs
Description of changes
This PR packages SQL Studio. It is a web based SQL database explorer that supports SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB and ClickHouse.
Things done
Built on p...
This PR packages SQL Studio. It is a web based SQL database explorer that supports SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB and ClickHouse.
Things done
Built on p...
๐ฅ35๐19๐2๐1