New release of free Database Workbench Lite Edition for #Firebird and #MySQL/#MariaDB.
Additional database systems supported in Basic, Pro and Enterprise editions: #SQLServer #oracle #sqlite #PostgreSQL #postgres #interbase #nexusdb
New release of free Database Workbench Lite Edition for #Firebird and #MySQL/#MariaDB.
Additional database systems supported in Basic, Pro and Enterprise editions: #SQLServer #oracle #sqlite #PostgreSQL #postgres #interbase #nexusdb
Eventually, I came with my own solution to handle `MIN` and `MAX` in #PostgreSQL with UUID columns (with UUID v7).
https://darkghosthunter.medium.com/postgresql-using-min-max-on-uuid-columns-51e52927e6a0
It's with my utter dissatisfaction to confirm y'all that PostgreSQL 18 doesn't support `MAX|MIN` aggregates over a UUID column.
This means, you will need to creates the functions I already described... or just plug in Microsoft SQL Server, MySQL or MariaDB as alternatives.
How difficult can be creating an hypertable in TimescaleDB?
It seems that pretty much of a fucking lot.
Totally forgot that Laravel News published my new package for modernising the old Laravel Seeder:
Jerry Nixon gives 'A Developer's Guide to Database Patterns' July 24th at Nebraska.Code().
ANN: Database Workbench 6.7.0 released
- ability to view vector embeddings in PostgreSQL
- quick CSV import/export
- faster foreign key creation
- bugfixes in PostgreSQL, Firebird, InterBase and SQLite modules
https://www.upscene.com/news/item/20250425
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
After #TaylorOtwell suggested it, I'm releasing my super-charged #Laravel Seeder.
Seed steps wrapped into transactions
Continue incomplete seeding
Push arguments to each seed step
Retrocompatible with the old `run()`
... and a lot of more features.
SQL JSON Conversion: Efficiently Converting SQL Query Results to JSON
Master SQL JSON conversion for efficient database development! Learn techniques for transforming SQL query results into JSON, improving code readability & security. #SQLJSONConversion #JSONData #DatabaseDevelopment #SQLServer #DataTransformation #Programming
https://tech-champion.com/database/sql-server/sql-json-conversion-efficiently-converting-sql-query-results-to-json/
...
Efficient DB2 SQL Function: Single-Row Table Creation
Master DB2 SQL Function creation for efficient data manipulation! Learn to build functions returning single-row tables & explore various approaches for optimal performance. #DB2SQLFunctions #SQLTips #DatabaseDevelopment #DataManipulation #DB2Tutorial #Coding
https://tech-champion.com/database/db2luw/efficient-db2-sql-function-single-row-table-creation/
...
SQLite Transactions and Virtual Tables
https://misfra.me/2025/sqlite-transactions-and-virtual-tables/
Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.
https://www.youtube.com/watch?v=ZnFf4sj8jro
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Video: Convert a #MySQL database to #PosgreSQL using Database Workbench.
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
SQL JSON Conversion: Efficiently Converting SQL Query Results to JSON
Master SQL JSON conversion for efficient database development! Learn techniques for transforming SQL query results into JSON, improving code readability & security. #SQLJSONConversion #JSONData #DatabaseDevelopment #SQLServer #DataTransformation #Programming
https://tech-champion.com/database/sql-server/sql-json-conversion-efficiently-converting-sql-query-results-to-json/
...
Efficient DB2 SQL Function: Single-Row Table Creation
Master DB2 SQL Function creation for efficient data manipulation! Learn to build functions returning single-row tables & explore various approaches for optimal performance. #DB2SQLFunctions #SQLTips #DatabaseDevelopment #DataManipulation #DB2Tutorial #Coding
https://tech-champion.com/database/db2luw/efficient-db2-sql-function-single-row-table-creation/
...
Efficient DB2 SQL Function: Single-Row Table Creation
Master DB2 SQL Function creation for efficient data manipulation! Learn to build functions returning single-row tables & explore various approaches for optimal performance. #DB2SQLFunctions #SQLTips #DatabaseDevelopment #DataManipulation #DB2Tutorial #Coding
https://tech-champion.com/database/db2luw/efficient-db2-sql-function-single-row-table-creation/
...
Video: Creating an #SQLite database with tables and foreign key relationships.
https://www.youtube.com/watch?v=w88NySp6Ydk
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Quick Clip: object list filtering in Database Workbench
https://www.youtube.com/watch?v=XseaNdp8oGM
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#SQLite
#databasetools #databasedevelopment #DatabaseWorkbench
It's easy to use a #FirebirdSQL server and database with #DatabaseWorkbench - check the video here!
https://www.youtube.com/watch?v=ZCzW0Du2D-w