Archive for the ‘Database Development’ Category
Posted by jpluimers on 2024/08/07
At the time of writing a lot of this might be more recent, but for quite some time codepoints.net had not been updated with code point information newer Unicode releases.
Basically it was stuck at Unicode version 8.0 with some 120k glyphs. At the time of writing Unicode version 15.0 is in beta and the difference between 15.0 and 8.0 is some 24k glyphs.
So I had a quick twitter chat with the author and jotted down the links in this blog post so I won’t forget them.
There I learned it was open source (I think it is the only Unicode codepoint site that is).
Here it goes:
Read the rest of this entry »
Posted in *nix, *nix-tools, Apache2, codepoints.net, Conference Topics, Conferences, Database Development, Debian, Development, DVCS - Distributed Version Control, Encoding, Event, GitHub, Linux, MySQL, PHP, Power User, Scripting, Software Development, Source Code Management, Unicode, Web Development | Leave a Comment »
Posted by jpluimers on 2024/07/18
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:
Read the rest of this entry »
Posted in Database Development, Development, MySQL, SQL Server | Leave a Comment »
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”
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.
Read the rest of this entry »
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 »
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
Read the rest of this entry »
Posted in .NET, Database Development, Development, Java, Java Platform, Profiling-Performance-Measurement, Software Development | Leave a Comment »
Posted by jpluimers on 2023/11/07
From quite a while ago, and still interesting:
Why are these interesting?
For me it is because tiny hick-ups can be just as hard for senior people as for novices.
–jeroen
Posted in Database Development, Development, MySQL | Leave a Comment »
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
Posted in Conference Topics, Conferences, Database Development, Development, Event, Software Development, SQL | 1 Comment »
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
Posted in Database Development, Development, PostgreSQL, Software Development, SQL | 2 Comments »
The Wiert Corner - irregular stream of stuff 