Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
social.tchncs.de is one of the many independent Mastodon servers you can use to participate in the fediverse.
A friendly server from Germany – which tends to attract techy people, but welcomes everybody. This is one of the oldest Mastodon instances.

Administered by:

Server stats:

3.8K
active users

social.tchncs.de: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#storedprocedures

1 post1 participant0 posts today
Public
zartom

DB2 Scheduled Data Deletion: Automating Record Removal at Midnight
Learn how to automate DB2 Scheduled Data Deletion using stored procedures! This ensures efficient database management & prevents performance bottlenecks. Master techniques like conditional purging & logging for optimal performance & data integrity. DB2 #DataDeletion #DatabaseManagement #Automation #StoredProcedures #SQL
tech-champion.com/database/db2...

Public
zartom

DB2 Scheduled Data Deletion: Automating Record Removal at Midnight
Learn how to automate DB2 Scheduled Data Deletion using stored procedures! This ensures efficient database management & prevents performance bottlenecks. Master techniques like conditional purging & logging for optimal performance & data integrity. DB2 #DataDeletion #DatabaseManagement #Automation #StoredProcedures #SQL
tech-champion.com/database/db2...

Public
zartom

DB2 Scheduled Data Deletion: Automating Record Removal at Midnight
Learn how to automate DB2 Scheduled Data Deletion using stored procedures! This ensures efficient database management & prevents performance bottlenecks. Master techniques like conditional purging & logging for optimal performance & data integrity. DB2 #DataDeletion #DatabaseManagement #Automation #StoredProcedures #SQL
tech-champion.com/database/db2...

Public
zartom

Creating MySQL Stored Procedures from PHP: A Step-by-Step Guide
Learn to create & utilize MySQL Stored Procedures in PHP! This guide covers creation, execution, error handling, & best practices, including prepared statements & multiple result sets. #MySQL #PHP #StoredProcedures #Database #Programming #SQL
tech-champion.com/database/cre
Learn how to create MySQL stored procedures from PHP. This guide provides a step-by-step ...

TECH CHAMPION · Creating MySQL Stored Procedures from PHP: A Step-by-Step GuideCreate MySQL stored procedures within your PHP applications. This guide offers a practical solution addressing limitations of single-command execution. MySQL Stored Procedure PHP.
Public
zartom

Calling MySQL Stored Procedures from Perl: A Comprehensive Guide
Learn to call MySQL stored procedures from your Perl scripts! This guide covers basic calls, handling multiple parameters, efficient data retrieval, and error handling. Master Perl MySQL Stored Procedures for robust database apps. #PerlMySQL #StoredProcedures #Database #Perl #MySQL #Programming
tech-champion.com/database/cal
Learn how to call MySQL stored pro...

Public *
alexanderadam

Interesting blog post "Supercharge #SQLite with #Ruby Functions" by @julik

blog.julik.nl/2025/01/supercha

Instead of #storedprocedures you can use user defined procedures (#udf).

Julik Tarkhanov · Supercharge SQLite with Ruby FunctionsAn interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations. By the way, the talk about the system that made me me to explore SQLite in anger can now be seen here. Normally it is your Ruby (or Python, or Go, or whatever) program which calls SQLite to make it “do stuff”. Most calls will be mapped to a native call like sqlite3_exec() which will do “SQLite things” and return you a result, converted into data structures accessible to your runtime. But there is another possible direction here - SQLite can actually call your code instead.
#rubylang#database
Replied in thread
Public *
LisPi

@lewdthewides Wait what the fuck? en.wikipedia.org/wiki/2023_MOV

How in the hell do you still have #SQLInjection vulnerable frontends in this day and age in government-used systems? Has no one heard of #PreparedQueries / #PreparedStatements (yay type-safety) and #StoredProcedures? What, did they hire some intern with no supervision for writing a high-liability system?

en.wikipedia.org2023 MOVEit data breach - Wikipedia
#SQL#SQLI
Public
Ænðr E. Feldstraw

I'm planning on writing a book. I've developed a #halfDAO, a #software #architecture #pattern for the #java #programming #language.

I find #JPA too broad: most of my apps just need to read. Writing back to the data store happens rarely. When it does, I use #storedProcedures. I don't need a JPA cache: my apps read into local memory objects, execute, and stop.

My solution is #DomainDriven, uses #Builders and #Generators. And in active use in 20 applications.

I need a publisher.

ExploreLive feeds
About