It's true with database design too.

#Databases
#RDBMS
#SQL

Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.

#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration

https://www.youtube.com/watch?v=Su6aUb2yM1g&t=64s

A Relational Model of Data for Large Shared Data Banks - E.F. Codd, 1970

* introduced a revolutionary approach to database design
* fundamentally changed how we store/access data
* rather than complex hierarchical structures, organized data into tables (relations) w. rows/columns
* manipulated through well-defined operations
...

https://fermatslibrary.com/s/a-relational-model-of-data-for-large-shared-data-banks#email-newsletter

New problem, new library! This time, I made a small utility for Laravel to limit a group of models on the table.

https://github.com/Laragear/Capstone

I talked about the implementation on my Medium blog, but in a nutshell, it uses a subquery to keep only the records you don't want to delete, like the latest five.

Ugh. We have > 7,000 database tables with a column named [ID].

This is true, even on days not dated April 1st.

#NotJoking
#RDBMS

Here's the TSQL thing I mentioned a day or two ago: a stored procedure that performs an assessment of an existing database table.

So far, it does the following:
Checks for the presence/absence of certain criteria:
A Primary Key and/or Unique Key.
A clustered index.
Compression (if any).
Total number of rows.
Create date.
Columns with deprecated data types.
Columns with ambiguous names.

https://codeberg.org/DaveMasonDotMe/SQL-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql

#SQLServer
#Database
#RDBMS
#TSQL

Softr Expert certification

What do you need help with?

Bring your Baserow projects to me

Baserow certifications:

Fundamentals
Advanced
Expert (on release)

Firebird Project is happy to announce general availability of Firebird 5.0.2 — the latest minor release in the Firebird 5.0 series.

This minor release offers bug fixes as well as a few improvements, please refer to the Release Notes for the full list of changes.

Binary kits for Windows, Linux, MacOS and Android platforms are immediately available for download.

https://firebirdsql.org/en/news/firebird-5-0-2-minor-release-is-available

Hey Data/UIUX folks, how do you handle preferred pronouns on an input form that feeds into a database? Obviously, a drop-down menu is too limited, but free-form text input is too unruly. RegEx validation of some kind, perhaps?

Firebird Project is happy to announce general availability of Firebird 5.0 — the latest major release of the Firebird relational database for Windows, Linux, MacOS and Android platforms.

This release introduces improvements in areas of performance, multithreaded processing (including backup, restore, sweep), SQL queries profiling, with better scalability and numerous enhancements in SQL language.

#Firebird5 #FirebirdSQL #SQL #RDBMS #opensource
https://firebirdsql.org/en/news/firebird-5-0-0-is-released/