Social 📸 Photography

5 posts5 participants1 post today

Rob PumphreyErrors in SQL can cause unnecessary stress. Consider select username,email, password_hash from users;against select username, email password_hash from users;<a href="https://mastodonapp.uk/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodonapp.uk/tags/DevLife" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevLife</a>

João SantosI just ruined a very time consuming <a href="https://social.jsantos.eu/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> transaction because I mistyped `COMMIT`. How's your Thursday going?<a href="https://social.jsantos.eu/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://social.jsantos.eu/tags/FML" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FML</a> <a href="https://social.jsantos.eu/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>

Christos Argyropoulos MD PhDIt is all <a href="https://mastodon.social/tags/rstats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rstats</a> fun and giggles until the dataset is too big to fit in memory. Then, it is time for the database servers and <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> to save the day.

Marcos DioneNot sure if I asked this before: Does anyone use anything in particular to inject <a href="https://en.osm.town/tags/apache" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#apache</a> logs into <a href="https://en.osm.town/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> databases? I have been looking around and asking around and the only solid I got was "do not expect an apache module for that; it would introduce too much latency to each request" in <a href="https://en.osm.town/tags/httpd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#httpd</a>@libera.chat.<a href="https://en.osm.town/tags/SysAdmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SysAdmin</a> <a href="https://en.osm.town/tags/SRE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SRE</a>

Cédric BelinI use Entity Framework... because it's the standard. But frankly, I much prefer Dapper and good old SQL.<a href="https://github.com/DapperLib/Dapper" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/DapperLib/Dapper</a><a href="https://mastodon.social/tags/CSharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CSharp</a> <a href="https://mastodon.social/tags/dotNet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotNet</a> <a href="https://mastodon.social/tags/ORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ORM</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a>

Markus RathMan sollte bei der Nutzung von <a href="https://norden.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a>-Datenbanken häufiger mal die Struktur überprüfen. Oder auch "Spare minütliche FullTableScans von Tabellen mit Millionen Datensätzen in Produktion mit einem kleinen Index."

Flasche_Chris (Chrissy)Question, my colleague want's a small database with only a few tables ( <a href="https://social.tchncs.de/tags/Mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Mariadb</a> / <a href="https://social.tchncs.de/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://social.tchncs.de/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> ) - Data pushed with PowerShell ScriptsHe also wants a small Web UI to search in this database with "basic" filteringI've found <a href="https://social.tchncs.de/tags/Adminer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Adminer</a> (<a href="https://www.adminer.org/de/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.adminer.org/de/</a>) which looks simpler then things like phpMyAdminIs this a good choice ? thx

bucketchallenge<a href="https://infosec.exchange/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> Dump in the <a href="https://infosec.exchange/tags/s3" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#s3</a> <a href="https://infosec.exchange/tags/bucket" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#bucket</a> of today with md5-hashed passwords AND the cleartext password next to it. 🤫 I do recommend:* to change the permissions of the bucket * change all passwords of the users on your platform * don't store plaintext passwords of your users

Kingsley Uyi IdehenHere’s another dashboard variant built using Claude Desktop as the MCP client and the virtual Northwind Knowledge Graph, derived from underlying Northwind tables. This edition adds both a Company and Employee dimension:<a href="https://claude.site/artifacts/7c4f5e75-d33a-4902-8a83-ed095de146a2" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://claude.site/artifacts/7c4f5e75-d33a-4902-8a83-ed095de146a2</a><a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MCP</a> <a href="https://mastodon.social/tags/HowTo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HowTo</a> <a href="https://mastodon.social/tags/KnowledgeGraph" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#KnowledgeGraph</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/SPARQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SPARQL</a>

SecretAntelope 🌈☕I really hate the term "vibe coding" - particularly because there is an assumption that it's easy to get usable and bug-free code out of an LLM. I use it as a tool to bounce ideas off of and spend most of my time telling it how wrong it is. Occasionally, you get some great results in a much faster way. It's definitely not plug and play - or a substitute for experience.<a href="https://covertcreatures.xyz/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://covertcreatures.xyz/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#llm</a> <a href="https://covertcreatures.xyz/tags/chatgpt" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#chatgpt</a> <a href="https://covertcreatures.xyz/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://covertcreatures.xyz/tags/datascience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#datascience</a> <a href="https://covertcreatures.xyz/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>

weirdjokesHacking in movies. <a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Coding</a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IT</a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Tech</a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Software</a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Computer</a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdevelopment</a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Statistics</a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataAnalysis</a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MachineLearning</a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataScience</a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Jokes</a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Memes</a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Funny</a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NeuralNetworks</a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SEO</a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevOps</a> 💻 Python Knowledge Base <a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://python-code.pro/</a>

weirdjokes<a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Coding</a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IT</a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Tech</a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Software</a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Computer</a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdevelopment</a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Statistics</a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataAnalysis</a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MachineLearning</a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataScience</a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Jokes</a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Memes</a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Funny</a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NeuralNetworks</a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SEO</a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevOps</a> 💻 Python Knowledge Base <a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://python-code.pro/</a>

Reuben Walker aka mobileatomOne SQL Query That Could Destroy Your Entire Database (And How Hackers Use It). <a href="https://flipboard.com/tag/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://flipboard.com/tag/php" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a><a href="https://dev.to/yuvasec/one-sql-query-that-could-destroy-your-entire-database-and-how-hackers-use-it-2ld7?utm_source=flipboard&utm_medium=activitypub" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yuvasec/one-sql-query-that-could-destroy-your-entire-database-and-how-hackers-use-it-2ld7?utm_source=flipboard&utm_medium=activitypub </a>Posted into SYMFONY FOR THE DEVIL <a href="https://flipboard.com/@mobileatom/symfony-for-the-devil-allupr6jz" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@symfony-for-the-devil-mobileatom</a>

Kingsley Uyi IdehenThis week’s edition of my <a href="https://mastodon.social/@linkedin" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@linkedin</a> newsletter shines a light on the impact of the Model Context Protocol (MCP) across multiple computing eras—leading right up to today.We’ve arrived at a moment where loose coupling principles are cool (and super useful) again.Naturally, there are some live demo nuggets in the post to help bring it all to life:🔗 <a href="https://www.linkedin.com/pulse/model-context-protocol-bridging-generational-computing-idehen-qdtce/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.linkedin.com/pulse/model-context-protocol-bridging-generational-computing-idehen-qdtce/</a><a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://mastodon.social/tags/GenAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GenAI</a> <a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MCP</a> <a href="https://mastodon.social/tags/KnowledgeGraph" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#KnowledgeGraph</a> <a href="https://mastodon.social/tags/LinkedData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LinkedData</a> <a href="https://mastodon.social/tags/SemanticWeb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SemanticWeb</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/SPARQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SPARQL</a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DBMS</a> <a href="https://mastodon.social/tags/DataConnectivity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataConnectivity</a>

weirdjokesProduct manager. <a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Coding</a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IT</a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Tech</a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Software</a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Computer</a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdevelopment</a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Statistics</a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataAnalysis</a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MachineLearning</a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataScience</a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Jokes</a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Memes</a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Funny</a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NeuralNetworks</a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SEO</a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevOps</a> 💻 Python Knowledge Base <a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://python-code.pro/</a>

David Wilson🔴 On today's Crafter Hours stream, we'll continue working on porting over the Discourse Single-Sign On authentication that I implemented in JavaScript for another version of the System Crafters site.Let's see how things look when we reimplement this in Guile Scheme!Join us here:- <a href="https://youtube.com/live/OFBCZ1uMBWk" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://youtube.com/live/OFBCZ1uMBWk</a> - <a href="https://twitch.tv/SystemCrafters" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://twitch.tv/SystemCrafters</a><a href="https://fosstodon.org/tags/guile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#guile</a> <a href="https://fosstodon.org/tags/scheme" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#scheme</a> <a href="https://fosstodon.org/tags/guix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#guix</a> <a href="https://fosstodon.org/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://fosstodon.org/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>

Ryan KennedyWas reminded the hard way today that…SELECT columnname = NULL FROM tablenamewill never never produce what you want and will also never/rarely produce a warning or error.<a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a>

Data QuineThanks to a live Data Camp session I found out that there are helper aggregate functions for linear regression in SQL in DuckDBe.g. regr_slope() regr_intercept()<a href="https://duckdb.org/docs/stable/sql/functions/aggregates.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/docs/stable/sql/functions/aggregates.html</a><a href="https://datasci.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://datasci.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a>

Recent searches

Search options

Administered by:

Server stats:

#sql

Recent searches

Search options

Administered by:

Server stats:

Sql

#sql