#sql

👋 Hi, Mastodon! This is SQLtest.online, a free SQL trainer that runs in your browser. • 480+ practice tasks with instant automatic checks • Real database engines: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Firebird, DuckDB • A step-by-step SQL course, a skills test and an interview simulator • No install, no paywall, open source Here we'll share new lessons, tasks and SQL tips. Questions welcome! https://sqltest.online #SQL #LearnSQL #PostgreSQL #MySQL #Database #Introduction

I know, sounds strange, but: Microsoft SQL Server can be installed on Linux. Some people told me it's a bad idea as it works quite badly. Is it true? Did any of you try it? What's your experience with it? #SQL #IT #SysAdmin

Pendo is hiring Senior Software Engineer (Backend) 🔧 #cplusplus #golang #java #python #api #aws #gcp #nosql #sql #seniorengineer 🌎 Raleigh, North Carolina ⏰ Full-time 🏢 Pendo Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-backend-at-pendo-io-jul-20-2026-48e61a?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring

SQLite for Everything https://joecode.com/2026-08-19-sqlite3/ We have so many remarkable tools that we avoid using because something else has a shiner marketing budget. (Though SQLite's type system is pretty mediocre.) #programming #sql #sqlite

If I want to support both SQLite and Postgres, do I have to resort to having two parallel sets of scripts basically? Is there a way, inside a .sql script, to determine which database backend I’m running and branch to at least keep the parts that differ in the same file? #LazyWeb #SQL #SQLite #Postgres

"Using #AI to Update Audit Triggers After Schema Changes" Generating an audit trigger is only the beginning. As a database evolves, tables change, new columns are added, and existing audit triggers need to evolve with them. This is another area where AI can save developers valuable time. https://www.upscene.com/articles/article/8/ai-to-update-triggers-after-database-schema-changes #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment #sqlite #sqlserver #PostgreSQL #FirebirdSQL #mysql #MariaDB #sqlserver #oracle #InterBase

I do enjoy doing fun #SQL tricks to clean up a database. 😌

Fun fact: if you have a newline-separated list of identifiers you need to use in a query, you can turn it into comma separated by piping it to tr '\n' ','. Then you can use it in a SQL IN clause.

But beware that this only works if your list contains nothing but integers! Otherwise you need to wrap string quotes around the lines first, escape them, etc, lest you fall prey to SQL injection.

#database #programming

Another fun fact: you can start a transaction, make some changes, check that the changes had the effect you intended, and then commit or rollback. Transactions aren't just for applications! You can use them interactively too. #SQL #database #programming

SP Page Builder 6.7.1: Update schließt vier Sicherheitslücken - Schwachstellen: SQL-Injection ohne Anmeldung - Offenes Mail-Relay ohne Anmeldung - SQL-Injection mit Autoren-Zugang - Löschen beliebiger Dateien mit Autoren-Zugang https://www.all-about-security.de/sp-page-builder-6-7-1-update-schliesst-vier-sicherheitsluecken/ #itsecurity #sql #cybersecurity

Also, if you're a .NET developer unafraid of dragons and mountains of SQL, I'm looking for 1-2 of you! ⛰️🐉🤺 You'd get to work with @davidvedvick@fosstodon.org and @too_little_caffeine@dotnet.socialhttps://billee.applytojob.com/apply/vahnKtLmvK/Senior-Backend-NET-Developer #getfedihired #dotnet #sql

#SQL aus jahrzehntelang produktivem Projekt:

SELECT * FROM rechte WHERE … AND id LIKE '7%' AAAAAAAAAAAAAAAHHHHHH

"Accelerating Database Development with #AI: Automating Repetitive Tasks" While AI is often associated with complex data analysis or machine learning, one of its most valuable applications is far more practical: automating repetitive development tasks. https://www.upscene.com/articles/article/7/ai-for-automating-repetitive-database-development-tasks #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment

Using #AI to speed up your #SQL development: here's how AI can help you. ✨ "The Future of SQL Development Is Database-Aware AI" ✨ https://www.upscene.com/articles/article/4/ai-chatbot-speeds-up-sql-development #DatabaseWorkbench #databasedevelopment #databasetools #MySQL #MariaDB #Firebird #SQLite #PostgreSQL #SQLServer #Oracle #InterBase #NexusDB

Automatisierung ist Queen - Dank Claude mehr Zeit zum Shoppen. Nur Witze kann die KI noch nicht richtig erzeugen. Oder spricht sie nur eine andere Sprache? Fragen! #linuxprosa #sql #mariadb #bizzfed #blog #ki #arbeit

Backstage access: an unauthenticated SQL injection in Front Gate Tickets https://ian.sh/frontgate #Security #SQL #Vulnerability

Ray Tracer in SQL https://github.com/ClickHouse/RayTracer #HackerNews #Tech #SQL

For @teruterubozu@toot.wales who always pronounces SQL as "Squirrel". #SQL #OReillyMedia #Marvel #squirrelGirl #Parody

Bootcamp Back-end com Java & QA Gratuito: 64h com Projetos e Portfólio na DIO https://guiadeti.com.br/bootcamp-back-end-com-java-qa-dio-almaviva/#backend #bootcamp #dio #java #junit #qa #springboot #sqlhttps://guiadeti.com.br/bootcamp-back-end-com-java-qa-dio-almaviva/?fsp_sid=1297

Hej, leci z nami ktoś z doświadczeniem z łączeniem #SQLite i #Python 'a? #SQL

Certificação em Bancos de Dados Relacionais da freeCodeCamp: Curso Gratuito com Projetos Práticos https://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/#bancodedados #bash #certificacao #freecodecamp #postgresql #programacao #sqlhttps://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/?fsp_sid=1050