Archive for the ‘Database Development’ Category
Posted by jpluimers on 2026/11/03
Choose your prefixes by default, especially if you name them after someone else’s product.
In this case, SQLite suffered from McAfee starting to use sqlite_ as prefix for temporary files in 2016.
SQLite had been using that prefix for a long time, and properly cleaned up these files during application shutdown.
McAfee didn’t cleanup after themselves which, after a long track record of dissatisfying users – [Wayback/Archive] The McAfee update mess explained | Reuters – wasn’t an incident, didn’t surprise techies, but prompted regular users to blame SQLite, some even tracking down their developers and call harass them.
McAfee apparently was deaf for a warning that then had been present for more than 10 years, as this got changed change in 20040522:
Read the rest of this entry »
Posted in C, Database Development, Development, Software Development, SQLite | Tagged: 218 | Leave a Comment »
Posted by jpluimers on 2026/10/27
During a private conversation, someone mentioned that there is a storm of CVEs and someone else asked if this was because people have been sloppy in programming for a very long time.
Luckily [Wayback/Archive] CVE: Common Vulnerabilities and Exposures has a table of Published CVE Records with totals which I have copied:
Read the rest of this entry »
Posted in Agile, Code Quality, Database Development, Development, JavaScript/ECMAScript, jq, JSON, PostgreSQL, Power User, Scripting, Security, Software Development | Leave a Comment »
Posted by jpluimers on 2026/10/08
A friend is starting a new business, so I am curious to what [Wayback/Archive] Sonde — Arriving soon will bring (or brought if this post scheduling arrives later than their release).
Looking at the taglines below, I think is that this is an intelligent (unlike LLM “intelligent”) source analysis/probing tool.
The Arrival animation sequence at [Wayback/Archive] Sonde — Arrival attributes the software development past in 29 stages, all the way back from FORTRAN till the more recent Swift until finally showing the moon, hopefully indicating a release before the Artemis IV will land people on the moon:
Read the rest of this entry »
Posted in .NET, AI and ML; Artificial Intelligence & Machine Learning, bash, BASIC, C, C#, C++, COBOL, CSS, Dart, Database Development, dBase, Delphi, Development, Elixir, Erlang, F#, Fortran, Functional Programming, Generative AI, Go (golang), Groovy, Haskell, History, Java, Java Platform, JavaScript/ECMAScript, Kotlin, Less (Less language), Lightweight markup language, LLM, MarkDown, ObjectiveC, Pascal, PHP, Python, R (R lang), Ruby, Rust, Scala, Scripting, SCSS, Software Development, Swift, Turbo Pascal, TypeScript, VB.NET, VB6, Visual BASIC, Web Development, xBase | Leave a Comment »
Posted by jpluimers on 2026/05/26
Interesting article: [Wayback/Archive] Stack Overflow’s forum is dead thanks to AI, but the company’s still kicking… thanks to AI – Sherwood News. with this important quote:
The complex questions still get asked on Stack because there’s no other place. If the LLMs are only as good as the data, which is typically human curated, we’re one of the best places for that, if not the best for technology.
I wonder about how far it has declined now, and also think these are reasons for the decline as well:
Anyway, the graph in that post is just a sexy version of a query you can create yourself on the SEDE (Stack Exchange Data Explorer). That’s why I included both below.
Read the rest of this entry »
Posted in AI and ML; Artificial Intelligence & Machine Learning, Database Development, Development, DVCS - Distributed Version Control, GitHub, GitHub Copilot, GitLab, LLM, Pingback, Software Development, Source Code Management, SQL, SQL Server, StackExchange, Stackoverflow | Tagged: edit, executionPlan, graph, messages, query, result, results, resultSets, site, SQL, switch, ThisIsWhyWeCantHaveNiceThings | 2 Comments »
Posted by jpluimers on 2025/12/24
Before Firebird version 1.0 got released, a gaping security hole that InterBase introduced in 1994 before InterBase 6.0 (mostly written in C) got open sourced in 2000 was detected by the team that frantically tried the Firebird fork to first get building on various platforms, then released.
It had a maximum CVSS score of 10.0 because it could access the security database in read/write mode, thereby allowing adding users with SYSDBA privileges.
The detection is now about 25 years ago; on 20260109 the publication (by IBPhoenix) of the bug will be 25 years ago too.
So below are some links, including the original InterBase 6 source which was hard to find as the attachments of the original release links had not been archived in the Wayback Machine.
But first some of the code parts, which also shows the source file I did find back:
Read the rest of this entry »
Posted in C, Database Development, Development, Firebird, History, InterBase, Software Development | Tagged: define | Leave a Comment »
Posted by jpluimers on 2025/07/08
While writing Some SQLite things I recently learned a while ago I bumped into SQLite extending the SQL syntax allowing SELECT column aliases in WHERE and ON conditions of JOIN clauses whereas standard SQL only allows it in the HAVING clause (some other DMBS allow this as well).
It reminded I never wrote a blog post about WHERE versus HAVING, which can be phrased into just two points:
WHERE is applied before the SELECT is assembled
HAVING is applied after the SELECT is assembled
This also means WHERE has a lot more influence on performance than HAVING, so using HAVING just so you can use aliases there instead of in the WHERE clauses is not a smart idea unless you verify in the query plan and query optimisation output of our DBMS this has no influence (some DBMS even allow you to see the results of query rewriting which you can use to verify if two queries really are equivalent from the DBMS perspective).
Since HAVING can be used without GROUP BY, many people work around the WHERE alias limitation. Given the above effects on performance, this is not a wise idea, despite the same end-results. See the example below that uses the [Wayback/Archive] MySQL :: Sakila Sample Database: customer table.
Luckily there has been enough other material explaining WHERE versus HAVING, so I can reference it from here, for instance (note note limited to MySQL/MariaDB) [Wayback/Archive] mysql – WHERE vs HAVING – Stack Overflow (thanks [Wayback/Archive] baloo and [Wayback/Archive] Fishdrowned):
Read the rest of this entry »
Posted in Conference Topics, Conferences, Database Development, Development, Event, MariaDB, MySQL, SQL, SQLite | Tagged: 1054, this | Leave a Comment »
Posted by jpluimers on 2025/07/03
Almost 3 years ago, I wrote about some database/SQL fiddle sites in Database fiddle sites (which covers [Wayback/Archive] two different [Wayback/Archive] dbfiddle sites and the [Wayback/Archive] SQL Fiddle site).
In the meantime, I figured out that [Wayback/Archive] Toolbox for Developers has a few fiddle pages and database/SQL tools online (in their order, which is not alphabetical):
Read the rest of this entry »
Posted in Database Development, Development, JavaScript/ECMAScript, MariaDB, MongoDB, MySQL, NoSQL, PHP, PostgreSQL, Scripting, Software Development, SQL Server, SQLite, TypeScript | Leave a Comment »
Posted by jpluimers on 2025/07/02
Since I keep forgetting which DBMS uses which method to select just a plain value without a table. I always remember it as my search phrase [Wayback/Archive] SELECT from DUAL, but actually better titled like the question below:
[Wayback/Archive] sql – SELECT from nothing? – Stack Overflow
Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MariaDB, MySQL, OracleDB, PL/SQL, PostgreSQL, SQL, SQL Server, SQLite | Leave a Comment »
Posted by jpluimers on 2025/05/27
This case, it was C# accessing a SQL back-end, but the responses to the Tweet how so many more examples not even related to software development.
Remember that plane crashing because they overloaded while they thought the fuel load numbers were in Imperial pounds where in fact they were in metric kilograms?
That’s why naming things that contain numbers should contain the unit in their name!
Related blog post: Watch “Felienne Hermans: How patterns in variable names can make code easier to read” on YouTube
Tweet: [Wayback/Archive] Nick Craver on Twitter: “Troubleshooting a hanging test suite and godDAMMIT. “In seconds”. Integer timeouts should be a felony offense punishable by an indeterminate amount of seconds/milliseconds/hours/fortnights/whatever the judge chooses.”

var csb = new SqlConnectionStringBuilder(TestConfig.Current. SQLServerConnectionString) { ConnectTimeout = 2000 }; int SqlConnectionStringBuilder.ConnectTimeout { get; set; } Gets or sets the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Returns: The value of the SqlConnectionStringBuilder, ConnectTimeout property, or 15 seconds if no value has been supplied.
Read the rest of this entry »
Posted in .NET, Agile, C#, Code Quality, Conference Topics, Conferences, Database Development, Development, Event, Software Development, SQL, SQL Server, Systems Architecture | Leave a Comment »
Posted by jpluimers on 2025/05/14
A few years back I bumped in this cool [Wayback/Archive] Thread by @asadotzler on Thread Reader App on early Firefox history (from before it was called Phoenix or Firebird, heck from before Phoenix was created!).
It is important to keep telling these bits of history as they are fundamental to understand the Web Browser landscape as it is now.
Great material that complements Wikipedia articles like these:
Read the rest of this entry »
Posted in Database Development, Development, Firebird, Firefox, History, Power User, Web Browsers | Leave a Comment »