Background Over the past weekend I encountered a weird bug while refactoring code for my personal website. I am a casual runner and I have a page with all my r...

1. The Nightmare: The Full Table Scan Imagine walking into a library with 100,000 books and looking for a specific title. If the books are just piled in the mi...

sql WITH VersionsToAscii AS SELECT t.INTERNIDENTITY, t.INTERNINSTID, t.INTERNVERSION, t.INTERNTIMESTAMP, t.IOIID, RTRIM XMLAGG XMLELEMENTE, c.chunk_content ORDE...

Article URL: https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing Comments URL: https://news.ycombinator.com/item?id=46243904 Points: 8 Comments: 1...

!Cover image for Why I Built Yet Another SQL Client And Made It Open Sourcehttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,form...

Working With Upcoming Wednesday Logic Today’s challenge was a fun mix of logic and SQL date functions. Create a table with names and appointment dates, then wr...

Article URL: https://github.com/stoolap/stoolap Comments URL: https://news.ycombinator.com/item?id=46239372 Points: 7 Comments: 0...

Setup sql SET VERIFY OFF FEEDBACK OFF HEADING OFF ECHO ON SET SERVEROUTPUT ON -- Capture argument or default to empty string no prompt COLUMN p_flag_col NEW_VA...

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...

Introduction In today's digital age, data security is paramount. SQL databases often store sensitive information, making it crucial to implement robust securit...

!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%...

!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%...