I love how Kris answers with these concise bits of SQL query results, this time about the sleep function and expression reuse of function results:
Archive for the ‘Database Development’ Category
MySQL function result reuse in expressions?
Posted by jpluimers on 2024/07/18
Posted in Database Development, Development, MySQL, SQL Server | Leave a Comment »
Lots of interesting programming learning games links via b0rk on Twitter
Posted by jpluimers on 2024/06/25
Every once in a while, b0rk (Julia Evans, of [Wayback/Archive] wizard zines fame) asks interesting questions like below that results in lot of cool links.
I have blogged assemblies of them before (see for instance Lots of interesting git links via b0rk on Twitter) and this one is no different:
[Wayback/Archive] Julia Evans on Twitter: “what are some helpful programming learning games? thinking of things like mystery.knightlab.com for SQL, and flexboxfroggy.com, and ohmygit.org especially interested in games that have helped you learn something”
- [Wayback/Archive] The SQL Murder Mystery
- [Wayback/Archive] Flexbox Froggy – A game for learning CSS flexbox
- [Wayback/Archive] Oh My Git!
The response was overwhelmingly good (I tried to indicate when games are not free or not playable from a web browser). I summarised it below.
Share this:
Posted in *nix, *nix-tools, Conference Topics, Conferences, CSS, Database Development, Development, DVCS - Distributed Version Control, Event, Games, git, Multi-Threading / Concurrency, Power User, RegEx, Scripting, sh, Sh Shell, Software Development, Source Code Management, SQL, Web Development | Leave a Comment »
How NOT to Measure Latency
Posted by jpluimers on 2024/05/15
According to @isotopp (Kristian Köhntopp ), this is one of the most important talks to watch regarding performance issues: [Wayback/Archive.is] How NOT to Measure Latency
Gil Tene provides an in-depth overview of Latency and Response Time Characterization, including proven methodologies for measuring, reporting, and investigating latencies, and overview of some common pitfalls encountered (far too often) in the field. Tene also covers specific considerations in garbage collected environments (such as Java).
It is on YouTube (embedded below the signature) as well, but the above link as synchronised slides plus video.
More places where you can get it:
Via [Archive.is] Kristian Köhntopp on Twitter: “… Dieser Talk ist einer der wichtigsten Talks überhaupt, wenn es um das debuggen von “Performance Problemen” oder SLOs geht.”
–jeroen
Share this:
Posted in .NET, Database Development, Development, Java, Java Platform, Profiling-Performance-Measurement, Software Development | Leave a Comment »
Do you need to patch PostgreSQL to show beer o’clock?
Posted by jpluimers on 2024/02/27
One might think a PostgreSQL patch is needed for [Wayback/Archive] Devrim Gündüz on Twitter: “Just forked PostgreSQL, and fixed a problem: …”
Share this:
Posted in Database Development, Development, PostgreSQL, Software Development | Leave a Comment »
A while ago it was “Kris is on a MySQL blogging spree” day (:
Posted by jpluimers on 2023/11/07
From quite a while ago, and still interesting:
- Via [Wayback/Archive] Kris on Twitter: “… In which we show a weird SQL error message, and what really was wrong.”:
[Wayback/Archive] Truncated incorrect DOUBLE value | Die wunderbare Welt von Isotopp which is actually a correct but confusing error when performing a
SET…WHEREand you get theANDin the wrong place. - [Wayback/Archive] Kris on Twitter: “… In which we try to access the (possibly generated) raw SQL sent to the database, even in the face of Syntax error, using Python.”
[Wayback/Archive] Debugging SQL in Python | Die wunderbare Welt von Isotopp on being “able to see the actual SQL string that has been sent to the database in order to facilitate interactive debugging” for mysqlclient and the the official MySQL 8 Connector/Python package.
Why are these interesting?
For me it is because tiny hick-ups can be just as hard for senior people as for novices.
–jeroen
Share this:
Posted in Database Development, Development, MySQL | Leave a Comment »
Via isotopp: Yes, I can connect to a DB in CSS
Posted by jpluimers on 2023/06/22
Boy, I wonder what can go wrong with [Wayback/Archive] Yes, I can connect to a DB in CSS
Via: [Wayback/Archive] Kris on Twitter: “… “Yes, I can connect to a DB in CSS” Abusing houdini.how, and using a JS version of Sqlite, CSS can connect to a DB.” / Twitter
Related:
- [Wayback/Archive] Houdini.how
- [Wayback/Archive] Memeloper on Twitter: “Recruiters be like: We’re looking for someone who can connect to the database using CSS.” / Twitter
–jeroen
Share this:
Posted in CSS, Database Development, Development, Software Development, SQLite, Web Development | Leave a Comment »
The SQL Murder Mystery
Posted by jpluimers on 2023/01/17
After last week’s posts PostgreSQL Exercises and SQLZOO: Interactive SQL tutorials (no login required), I did a Twitter search:
This got me to [Wayback/Archive] The SQL Murder Mystery (which is fun!).
I got there via [Archive] Lætitia on Twitter: “@nthonynowocien I’d say pgexercises is a good start for SQL pgexercises.com Even though, the last exercises are not beginner level. The SQL murder mystery is more fun mystery.knightlab.com” / Twitter
–jeroen
Share this:
Posted in Conference Topics, Conferences, Database Development, Development, Event, Software Development, SQL | 1 Comment »
SQLZOO: Interactive SQL tutorials (no login required)
Posted by jpluimers on 2023/01/12
[Wayback/Archive] SQLZOO has an extensive set of interactive tutorials spread over these topics:
- basic SQL tutorials gradually getting more difficult (including some Covid-19 materials)
- SQL “how to” style questions
- More involved examples from easy via medium to hard
- A White Christmas challenge
So the above is kind of a continuation of my series of games to learn software and database development PostgreSQL Exercises.
I found it via the first reaction to [Archive] Steve Polito on Twitter: “If you’re like me and want to level up your SQL game, give PostgreSQL Exercises a try. …” / Twitter (which initiated yesterday’s post):
[Archive] Loumarven Payot on Twitter: “@stevepolitodsgn I’ve also tried sqlzoo.net. Almost done with it. Next on my list are dataschool.com and selectstarsql.com” / Twitter
Which means I’ve more sites to try.
These will be the next: [Wayback/Archive] Learn SQL: Interactive SQL Book, from dataschool and [Wayback/Archive] Select Star SQL (which is an interactive book that I should be able to finish in a day full of reading and experimenting).
–jeroen
Share this:
Posted in Conference Topics, Conferences, Database Development, Development, Event, Software Development, SQL | 1 Comment »
PostgreSQL Exercises
Posted by jpluimers on 2023/01/11
[Wayback/Archive] PostgreSQL Exercises
This site was born when I noticed that there’s a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing. PGExercises provides a series of questions and explanations built on a single, simple dataset.
It was funny, as I bummped into right after writing the article Enabling GitHub pages to a HTML or markdown GitHub project is dead easy: Delphi deadlockempire is now hosted on github.io (which reached the top of the blog queue yesterday).
After reading the [Wayback/Archive] PostgreSQL Exercises: Getting Started, start the exercises at [Wayback/Archive] PostgreSQL exercises: basic exercises.
There is no login needed, which I really like.
Note that some of the assignments are hard, and can have multiple results, see for instance [Archive] Fahru on Twitter: “this: … I FINALLY completed it, and any win is worth telling🥳 took me like one hour on and off. The “more than 30$” requirement is bizarre 😂 a bit different than the official answer so I’m digging up more about this learned a heck ton, worth the time! ” / Twitter
Via: [Archive] Steve Polito on Twitter: “If you’re like me and want to level up your SQL game, give PostgreSQL Exercises a try. …” / Twitter
–jeroen
Share this:
Posted in Database Development, Development, PostgreSQL, Software Development, SQL | 2 Comments »
Securely Connecting to Autonomous DB Without a Wallet (Using TLS)
Posted by jpluimers on 2022/12/20
[Wayback/Archive] Securely Connecting to Autonomous DB Without a Wallet (Using TLS)
It is about moving from mTLS to TLS on Oracle Autonomous DB and at the same time IP-whitelisting the client IP addresses.
[Archive] Chris Bensen on Twitter: “This is extremely useful so I figured I’d share in the hopes it helps someone else “
–jeroen
Share this:
Posted in Cloud, Cloud Development, Database Development, Development, Infrastructure, OracleDB, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 