-
- · software
Yoyo migrate vs Golang migrate
Background Recently I had to integrate a database migration tool into our CI pipeline. At first we picked golang-migrate because it is popular and widely recom...
- · software
Data Security in SQL: Encryption, Roles, and Permissions
Introduction In today's digital age, data security is paramount. SQL databases often store sensitive information, making it crucial to implement robust securit...
- · software
Χαρτογράφηση & Διάγνωση σε SQL Server: Τα 30 Queries που Χρησιμοποιώ Πάντα
!Forem Logohttps://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...
- · software
PostgreSQL Log Viewing
!Forem Logohttps://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...
- · software
PostgreSQL Merge Into
sql UPDATE PSMT_INVOICE_M SET SHIPPING_COUNTRY_ID = SRC.COUNTRY_ID, SHIPPING_CITY_ID = SRC.CITY_ID, SHIPPING_TOWN_ID = SRC.TOWN_ID FROM SELECT PM.INVOICE_M_ID,...
- · software
Oracle Merge Into
!Forem Logohttps://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...
- · software
Learning Slowly, Learning Consistently: My Approach to Coding
Introduction I'm a slow learner. I can't rush through five tutorials a day or build huge projects overnight, and for a long time I thought that meant I wasn't...
- · software
DevPills #6 - SQLC: how to scaffold your database code
!Cover image for DevPills 6 - SQLC: how to scaffold your database codehttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=au...
- · software
PGlite – Embeddable Postgres
Article URL: https://pglite.dev/ Comments URL: https://news.ycombinator.com/item?id=46146133 Points: 80 Comments: 13...
- · software
SQL: Doing GROUP BY in CsvPath
Introduction Let's look at how to create a simple GROUP BY report in the CsvPath Frameworkhttps://www.csvpath.org/'s tabular data validation language. Of all o...
-