Getting AI to write good SQL: Text-to-SQL techniques explained
Link: https://cloud.google.com/blog/products/databases/techniques-for-improving-text-to-sql
Discussion: https://news.ycombinator.com/item?id=44009848
Show HN: SQL-tString a t-string SQL builder in Python
Link: https://github.com/pgjones/sql-tstring
Discussion: https://news.ycombinator.com/item?id=44004827
Missed the #LPI 25th anniversary giveaway? We’ve extended the deadline!
To show our appreciation for the community that makes our efforts to support #FOSS possible: every 25th candidate who takes an #LPI exam Jan. 1 - June 30 will receive a free voucher for their next exam!
Learn more: https://lpi.org/7ivv
SQLx integration in Axum:
SQLx is an awesome crate for interacting with databases in Rust with compile time checks. In this blog post, we will learn how to use it in an Axum backend to store and retrieve data from a database.
– by @mo8it (2023-05-29)
Formes normales : guide pratique pour développeurs https://www.journalduhacker.net/s/ha17ui/formes_normales_guide_pratique_pour_d https://blog.idriss-code.fr/formes-normales-guide-pratique-pour-developpeurs/ #sql
Launch HN: ParaQuery (YC X25) – GPU Accelerated Spark/SQL
Discussion: https://news.ycombinator.com/item?id=43964505
ToyDB rewritten: a distributed SQL database in Rust, for education
Link: https://github.com/erikgrinaker/toydb
Discussion: https://news.ycombinator.com/item?id=43956547
Data7 v0.10.0 has been released 
It now includes a "stream" command to export configured datasets to regular files 
I make websites. Sometimes I toot about it.
#eleventy #webc #php #statamic #laravel #tailwindcss #alpinejs uhhh whatever #sql and I guess #nginx #docker and all that crap all the way down. #fullstack
I play RPGs with friends. Sometimes I toot about it.
#ttrpg #dnd #pathfinder #5e #pf2e
I am my group's sysadmin. Sometimes I toot about it.
#selfhosted #plex #lemmy #mastodon #pihole and throw some darts at https://selfh.st and you catch the rest.
Hot takes, bad jokes, etc.
Tech life is rarely dull. Partly because so many "great advice" articles I see don't accord with my experiences.
For example, in one of my feeds is a piece: "SQL Query Optimization for Data Engineers" of which half the things in it would be bad advice in my work.
Data engines and query optimisers vary so much that many "expert" assumptions prove false on them.
There's really no substitute for:
- understanding how your platform really works;
- trying out multiple ways.
#datawork #SQL
PostgreSQL, we've generally heard, is "good enough" for most intents and purposes.
We'd love to know what YOU think. What's stopped you from using #PostgreSQL in the past, and what solution did you choose instead? When have you opted for #Postgres where it turned out better than expected? 
Show HN: TextQuery – Query CSV, JSON, XLSX Files with SQL
Link: https://textquery.app/
Discussion: https://news.ycombinator.com/item?id=43897129
#OpenToWork | Data Engineer | ETL & Contrôle Qualité
CV PDF : http://gabriel.chandesris.free.fr/gabysblog/docs/CVGabrielChandesris.pdf
Expert #ETL #Python #SQL #DataQuality #BigData
Prêt à optimiser vos pipelines de données !
RT plz #i4emploi #Recrutement #Emploi #DataEngineering #Spark #Scala ...
I am getting into writing PostgreSQL functions in the C language and I am particularly interested in ordered-set aggregate functions.
Is there anyone out here who can direct me in the right direction?
https://www.europesays.com/2048578/ Top YouTube Channels to Master Data Analytics Skills in 2025 #BestYouTubeChannelsForDataAnalytics #Data #DataAnalytics #FreeDataScienceCourses #python #SQL #Youtube
Aviation weather for San Carlos airport (USA) is “KSQL 010455Z AUTO 16004KT 10SM CLR 14/11 A2996 RMK AO2” : See what it means on https://www.bigorre.org/aero/meteo/ksql/en #sancarlos #usa #sancarlosairport #ksql #sql #metar #aviation #aviationweather vl
I'm so happy I had to do this I could punch someone
PS: I'd love to see vibe coders deal with data sanitization in prod
️ 
Кейси виявлення та усунення вразливостей, таких як 
🅸🅶
🆁🆁🅴.
☭