#databasedevelopment

Upscene Productionsupscene@mstdn.business
2025-04-28

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

upscene.com/news/item/20250425

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Screenshot of Database Workbench displaying vector embeddings in PostgreSQL
2025-04-25

After suggested it, I'm releasing my super-charged 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.

github.com/Laragear/Populate

2025-04-19

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.
tech-champion.com/database/sql
...

2025-04-19

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.
tech-champion.com/database/db2
...

2025-03-29

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.
tech-champion.com/database/sql
...

2025-03-29

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.
tech-champion.com/database/db2
...

2025-03-29

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.
tech-champion.com/database/db2
...

2025-02-24

Conditionally Create Stored Procedures in SQL Server: A Comprehensive Guide
Learn how to create Conditional SQL Stored Procedures in SQL Server efficiently! Manage database schema evolution & avoid conflicts. This guide covers various methods, including dynamic SQL & schema versioning, with best practices for error handling.
tech-champion.com/database/con...

2025-02-24

Adding User-Defined Functions to DB2 Databases
Master DB2 User Defined Functions (UDFs) to enhance your database applications! Learn to create & use these powerful tools for improved code readability & efficiency.
tech-champion.com/database/add
Learn how to add user-defined functions to your DB2 database. This guide covers creating functions implementation details ...

Upscene Productionsupscene@mstdn.business
2025-02-12

Upscene releases free Database Workbench Lite for personal non-commercial use.

There's a version for #Firebird and a version for #MySQL/#MariaDB.

#database #databasetools #databasetool #databasedevelopment

firebirdnews.org/free-database

Upscene Productionsupscene@mstdn.business
2025-02-11

Upscene releases free Database Workbench Lite for personal non-commercial use.

There's a version for #Firebird and a version for #MySQL.

#database #databasetools #databasetool #databasedevelopment

firebirdnews.org/free-database

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst