Day 123 - Broken cloud, windy, cool, damp
A gentle Wilbur dog dawdle around the usual circuit. Groin strain improving. I have a need to learn SQL. Anybody know good #SQL resources (for optimising/reducing a wordpress database)?
#running #runsky #runningpunks #5kaday
A gentle Wilbur dog dawdle around the usual circuit. Groin strain improving. I have a need to learn SQL. Anybody know good #SQL resources (for optimising/reducing a wordpress database)?
#running #runsky #runningpunks #5kaday
May 3, 2025 at 9:42 AM
Day 123 - Broken cloud, windy, cool, damp
A gentle Wilbur dog dawdle around the usual circuit. Groin strain improving. I have a need to learn SQL. Anybody know good #SQL resources (for optimising/reducing a wordpress database)?
#running #runsky #runningpunks #5kaday
A gentle Wilbur dog dawdle around the usual circuit. Groin strain improving. I have a need to learn SQL. Anybody know good #SQL resources (for optimising/reducing a wordpress database)?
#running #runsky #runningpunks #5kaday
Good morning,
Still searching for a new job.
If you know of positions available for Snowflake SQL engineer, let me know.
UK/remote preferred but happy to relocate wherever I can work which includes the EU.
#snowflake #sql
Still searching for a new job.
If you know of positions available for Snowflake SQL engineer, let me know.
UK/remote preferred but happy to relocate wherever I can work which includes the EU.
#snowflake #sql
November 14, 2024 at 9:34 AM
Good morning,
Still searching for a new job.
If you know of positions available for Snowflake SQL engineer, let me know.
UK/remote preferred but happy to relocate wherever I can work which includes the EU.
#snowflake #sql
Still searching for a new job.
If you know of positions available for Snowflake SQL engineer, let me know.
UK/remote preferred but happy to relocate wherever I can work which includes the EU.
#snowflake #sql
upd as I had switched from unity's visualscripting sql lib to #Sqlite .net, I can say that
💥 all issues in repost still apply...
BUT
sqlite net is better because:
✅ never breaks on bulk inserts
✅ fully supports enum properties
✅ NotNull attribute really works
#buildinpublic #sql #orm #database
💥 all issues in repost still apply...
BUT
sqlite net is better because:
✅ never breaks on bulk inserts
✅ fully supports enum properties
✅ NotNull attribute really works
#buildinpublic #sql #orm #database
working with #unity3d #ORM (sqlite-net, Sql4Unity3d) after backend and #EntityFramework is a very interesting experience
💥 no foreign keys/navigational properties
💥 no composite primary keys
💥 can't specify default property value
💥 breaks from math in queries
#buildinpublic #gamedev #sql #database
💥 no foreign keys/navigational properties
💥 no composite primary keys
💥 can't specify default property value
💥 breaks from math in queries
#buildinpublic #gamedev #sql #database
September 25, 2026 at 12:54 AM
upd as I had switched from unity's visualscripting sql lib to #Sqlite .net, I can say that
💥 all issues in repost still apply...
BUT
sqlite net is better because:
✅ never breaks on bulk inserts
✅ fully supports enum properties
✅ NotNull attribute really works
#buildinpublic #sql #orm #database
💥 all issues in repost still apply...
BUT
sqlite net is better because:
✅ never breaks on bulk inserts
✅ fully supports enum properties
✅ NotNull attribute really works
#buildinpublic #sql #orm #database
omg we've gone full circle and Information Retrieval is back to boolean operators. #lucene #solr #sql #nltk #askjeeves
This paper introduces a logical reasoning framework for retrieval systems, improving their ability to handle complex queries with negations and conjunctions. By integrating logical reasoning into retrieval, we surpass traditional vector models, boosting efficiency. https://arxiv.org/abs/2503.17860
Enhancing Retrieval Systems with Inference-Time Logical Reasoning
ArXiv link for Enhancing Retrieval Systems with Inference-Time Logical Reasoning
arxiv.org
March 25, 2025 at 10:17 PM
omg we've gone full circle and Information Retrieval is back to boolean operators. #lucene #solr #sql #nltk #askjeeves
#defcon #anon #anonymous #graphicdesign #programing #coding #engineers #nerds #tech #technology #hacker #hacking #python #linux #c #rust #binary #HCI #XXE #sql #security
March 20, 2025 at 3:39 AM
My LinkedIn Learning course, SQL AI Agents in Production, is available for free for a limited time at the link below:
www.linkedin.com/feed/update/...
#ai #datascience #sql #python
www.linkedin.com/feed/update/...
#ai #datascience #sql #python
My recent LinkedIn Learning course, SQL AI Agents in Production, just reached 4,000 learners 🚀, and it is now open for free for a limited time with the link below 👇🏼
What does production mean… | Rami...
My recent LinkedIn Learning course, SQL AI Agents in Production, just reached 4,000 learners 🚀, and it is now open for free for a limited time with the link below 👇🏼
What does production mean when wo...
www.linkedin.com
September 24, 2026 at 1:58 PM
My LinkedIn Learning course, SQL AI Agents in Production, is available for free for a limited time at the link below:
www.linkedin.com/feed/update/...
#ai #datascience #sql #python
www.linkedin.com/feed/update/...
#ai #datascience #sql #python
I'm currently seeking my next role as a Developer Advocate or Software Developer ( #JavaScript, #TypeScript, #Nodejs, #csharp, #SQL, #electron). I also welcome opportunities that leverage my illustration, graphic design, and musical abilities. Every connection helps! Thank you!
November 19, 2024 at 3:57 PM
I'm currently seeking my next role as a Developer Advocate or Software Developer ( #JavaScript, #TypeScript, #Nodejs, #csharp, #SQL, #electron). I also welcome opportunities that leverage my illustration, graphic design, and musical abilities. Every connection helps! Thank you!
Mindmap to learn SQL!
amazon.com/Python-Program…#pythono#programmingn#developere#programmere#codingn#codere#softwaredevelopere#computersciencec#webdeve#webdevelopere#webdevelopmentn#pythonprogrammingn#pythonquizi#aia#mlm#machinelearningn#datasciencec#sqlq#nosqlq#mysqlq#databasese
amazon.com/Python-Program…#pythono#programmingn#developere#programmere#codingn#codere#softwaredevelopere#computersciencec#webdeve#webdevelopere#webdevelopmentn#pythonprogrammingn#pythonquizi#aia#mlm#machinelearningn#datasciencec#sqlq#nosqlq#mysqlq#databasese
November 21, 2024 at 6:58 PM
Dont Stop Believing Anonymous
youtu.be/9HK-MLamafs?...
#anon #anonymous #graphicdesign #programing #coding #engineers #nerds #tech #technology #hacker #hacking #python #linux #c #rust #binary #HCI #XXE #sql #security
youtu.be/9HK-MLamafs?...
#anon #anonymous #graphicdesign #programing #coding #engineers #nerds #tech #technology #hacker #hacking #python #linux #c #rust #binary #HCI #XXE #sql #security
Dont Stop Believing Anonymous 2025 chapter 4
YouTube video by The Prophecy
youtu.be
March 20, 2025 at 7:10 PM
Dont Stop Believing Anonymous
youtu.be/9HK-MLamafs?...
#anon #anonymous #graphicdesign #programing #coding #engineers #nerds #tech #technology #hacker #hacking #python #linux #c #rust #binary #HCI #XXE #sql #security
youtu.be/9HK-MLamafs?...
#anon #anonymous #graphicdesign #programing #coding #engineers #nerds #tech #technology #hacker #hacking #python #linux #c #rust #binary #HCI #XXE #sql #security
SQL + ggplot2 = ggsql ❤️
It is hard to find new and exciting open-source projects that aren't related to AI or the agents hype, but this one definitely looks amazing. ggsql is a new open-source project from Posit that implements the grammar of graphics with SQL syntax.
#sql #dataviz #rstats
It is hard to find new and exciting open-source projects that aren't related to AI or the agents hype, but this one definitely looks amazing. ggsql is a new open-source project from Posit that implements the grammar of graphics with SQL syntax.
#sql #dataviz #rstats
April 21, 2026 at 4:03 PM
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
❗️Our next workshop will be on December 12th, 6 pm CET on Big data made small: Harness the power of #SQL via #Python (through DuckDB) by @alemartinello.com !
Register or sponsor a student by donating to support 🇺🇦!
Details: bit.ly/3wBeY4S
Please share!
#AcademicSky #EconSky
Register or sponsor a student by donating to support 🇺🇦!
Details: bit.ly/3wBeY4S
Please share!
#AcademicSky #EconSky
December 2, 2024 at 10:23 AM
❗️Our next workshop will be on December 12th, 6 pm CET on Big data made small: Harness the power of #SQL via #Python (through DuckDB) by @alemartinello.com !
Register or sponsor a student by donating to support 🇺🇦!
Details: bit.ly/3wBeY4S
Please share!
#AcademicSky #EconSky
Register or sponsor a student by donating to support 🇺🇦!
Details: bit.ly/3wBeY4S
Please share!
#AcademicSky #EconSky
RedMimicry is hiring: Software Developer (#Go) - Security Analytics #RemoteWork #Berlin 🇩🇪 #golang #sql #javascript
🇩🇪 Remote Golang job: Software Developer (Go) - Security Analytics at RedMimicry (Berlin, Germany) | Salary: 69,000 – 77,000 EUR
Software Developer (Go) - Security Analytics Location: Mostly remote (within Germany), with monthly in-person collaboration at our Berlin office Hours: Full-time, 40 hours per week Contract: Fixed-term Salary: EUR 69,000 – 77,000 We are building a new capability that turns fragmented, noisy sec
www.golangprojects.com
September 22, 2026 at 8:55 AM
RedMimicry is hiring: Software Developer (#Go) - Security Analytics #RemoteWork #Berlin 🇩🇪 #golang #sql #javascript
Why SQL won 🏁
In this interview with Let's Data Science, #DuckDB co-creator @hannes.muehleisen.org argues that the data industry misdiagnosed SQL’s problems a decade ago.
What developers *actually* hated in 2013 was the install, the server, and the client protocol, not the language itself.
#SQL
In this interview with Let's Data Science, #DuckDB co-creator @hannes.muehleisen.org argues that the data industry misdiagnosed SQL’s problems a decade ago.
What developers *actually* hated in 2013 was the install, the server, and the client protocol, not the language itself.
#SQL
DuckDB's creator tells LDS why SQL won
Hannes Muhleisen, creator of DuckDB, told Lets Data Science that the industry misdiagnosed SQL a decade ago: what developers hated in 2013 was the install, the server and the client protocol, not the ...
letsdatascience.com
August 13, 2026 at 8:38 PM
Why SQL won 🏁
In this interview with Let's Data Science, #DuckDB co-creator @hannes.muehleisen.org argues that the data industry misdiagnosed SQL’s problems a decade ago.
What developers *actually* hated in 2013 was the install, the server, and the client protocol, not the language itself.
#SQL
In this interview with Let's Data Science, #DuckDB co-creator @hannes.muehleisen.org argues that the data industry misdiagnosed SQL’s problems a decade ago.
What developers *actually* hated in 2013 was the install, the server, and the client protocol, not the language itself.
#SQL
Interesting discovery: there are roughly 9,000 accounts within 5 hops of those I currently follow! 🚀 (I assume I didn't mess up the data gathering)
Powered by @duckdb.org with the seamless #SQL/ #PGQ syntax supported in the #DuckPGQ extension. Amazing what you can uncover with the right tools!
Powered by @duckdb.org with the seamless #SQL/ #PGQ syntax supported in the #DuckPGQ extension. Amazing what you can uncover with the right tools!
October 30, 2024 at 4:19 PM
Interesting discovery: there are roughly 9,000 accounts within 5 hops of those I currently follow! 🚀 (I assume I didn't mess up the data gathering)
Powered by @duckdb.org with the seamless #SQL/ #PGQ syntax supported in the #DuckPGQ extension. Amazing what you can uncover with the right tools!
Powered by @duckdb.org with the seamless #SQL/ #PGQ syntax supported in the #DuckPGQ extension. Amazing what you can uncover with the right tools!
#anon #anonymous #graphicdesign #programing #coding #engineers #tech #technology #hacker #hacking #python #linux #c #rust #sql #security #png #image #pic #picture
April 3, 2025 at 12:55 AM
@niallmcp.bsky.social showing how to use vector_distance to do semantic search with #SQL
This enables you to compare vector embeddings to find rows related to your search
#DOAG2024
This enables you to compare vector embeddings to find rows related to your search
#DOAG2024
November 21, 2024 at 9:31 AM
@niallmcp.bsky.social showing how to use vector_distance to do semantic search with #SQL
This enables you to compare vector embeddings to find rows related to your search
#DOAG2024
This enables you to compare vector embeddings to find rows related to your search
#DOAG2024
Announcing posit::glimpse() May 2026! ✨
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
posit::glimpse() Newsletter - May 2026
We’re introducing new packages like ggsql and raghila, alongside major updates to Quarto and many other open-source packages.
posit.co
May 6, 2026 at 2:45 PM
Announcing posit::glimpse() May 2026! ✨
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
Hey #100Devs - let's set up a database with @supabase.com and #SQL! If you're curious about how to create and query data directly in a relational database, join us as we build our project backend. Going live today (02/09) at 3:00 ET!
www.twitch.tv/mayanwolfe
www.twitch.tv/mayanwolfe
Mayanwolfe - Twitch
Hey friends! I'm a software engineer! I am currently a Senior SQL Developer for a major university and a community educator for 100Devs. https://leonnoel.com/100devs/ I enjoy streaming about coding co...
www.twitch.tv
February 9, 2025 at 4:38 PM
Hey #100Devs - let's set up a database with @supabase.com and #SQL! If you're curious about how to create and query data directly in a relational database, join us as we build our project backend. Going live today (02/09) at 3:00 ET!
www.twitch.tv/mayanwolfe
www.twitch.tv/mayanwolfe
Super #SQL brainteaser for your Tuesday that kept a few folks on our team thinking pretty hard until someone made an elegant solution.
The desired behavior per unit:
* First event qualifies
* Subsequent events qualify only if it's been more than 90 days since the last
Sample dates below #dataBS
The desired behavior per unit:
* First event qualifies
* Subsequent events qualify only if it's been more than 90 days since the last
Sample dates below #dataBS
December 10, 2024 at 8:12 PM
The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite github.com/launchbadge/...
#rustlang #opensource #sql
#rustlang #opensource #sql
GitHub - launchbadge/sqlx: 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. - launchbadge/sqlx
github.com
July 29, 2025 at 5:51 PM
The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite github.com/launchbadge/...
#rustlang #opensource #sql
#rustlang #opensource #sql
🌟 The non-positional INSERT #SQL statement will hopefully change the way how we write INSERT statements forever. I'm proud that I was directly involved in this effort.
🧠 This blog post is a "brain dump" recounting that journey.
🧠 This blog post is a "brain dump" recounting that journey.
Non-Positional INSERT statement – the insider story
Oracle Database 23.9 implements the non-positional INSERT statement. In my social media posts, I called out that Oracle Database is the first and only database to support this functionality, and by that, I mean not only the SET clause but the entirety of that feature set. There is a lot that can be done now, and this blog post provides the backstory of how this feature came about, what it does, and when you should use it.
www.geraldonit.com
August 26, 2025 at 1:00 PM
🌟 The non-positional INSERT #SQL statement will hopefully change the way how we write INSERT statements forever. I'm proud that I was directly involved in this effort.
🧠 This blog post is a "brain dump" recounting that journey.
🧠 This blog post is a "brain dump" recounting that journey.
Here is the CLI + SQL crossover you didn't see coming! 🤯
📁 fselect: Find files with SQL-like queries
🔥 Supports human-friendly queries, metadata search, interactive mode, diverse outputs
🦀 Written in Rust!
⭐ GitHub: github.com/jhspetersson...
#rustlang #commandline #find #sql #query #opensource
📁 fselect: Find files with SQL-like queries
🔥 Supports human-friendly queries, metadata search, interactive mode, diverse outputs
🦀 Written in Rust!
⭐ GitHub: github.com/jhspetersson...
#rustlang #commandline #find #sql #query #opensource
January 12, 2025 at 7:11 PM
Here is the CLI + SQL crossover you didn't see coming! 🤯
📁 fselect: Find files with SQL-like queries
🔥 Supports human-friendly queries, metadata search, interactive mode, diverse outputs
🦀 Written in Rust!
⭐ GitHub: github.com/jhspetersson...
#rustlang #commandline #find #sql #query #opensource
📁 fselect: Find files with SQL-like queries
🔥 Supports human-friendly queries, metadata search, interactive mode, diverse outputs
🦀 Written in Rust!
⭐ GitHub: github.com/jhspetersson...
#rustlang #commandline #find #sql #query #opensource
From shower idea to #Shiny app in 2 days. 😅 Little late for last week’s #TidyTuesday but I couldn’t stop adjusting! Movable Data Type explores Gutenberg data across backends, comparing structure, running queries, and visualizing distributions. #RStats #SQL jmclawson.shinyapps.io/movable-data...
June 11, 2025 at 4:50 PM
From shower idea to #Shiny app in 2 days. 😅 Little late for last week’s #TidyTuesday but I couldn’t stop adjusting! Movable Data Type explores Gutenberg data across backends, comparing structure, running queries, and visualizing distributions. #RStats #SQL jmclawson.shinyapps.io/movable-data...