The further you dig, the farther the #history goes, so we settled on starting in 1906, then the 90's, then #Slackware. This is the history of #Xz that culminated into a " #hack " that would have rocked the world if not for one intrepid #SQL#developer.
DNFB for medicine is discharged not final billed and is used a lot at hospitals as it represents the AR not yet billable. It is important to keep this to a minimum of days for efficiency and ability to get paid. It affects cashflow, so the lower the better. I wrote a quick diddy that sifted 147mllion rows in 2 seconds to give me my average dnfb by AR snapshot month
I wonder if anyone has ever written an embedded #RDBMS in which there is no run-time #SQL interpreter, and all SQL queries are translated into machine code at compile time.
Kinda like #Rust sqlx, except queries are fully compiled at compile time, not just checked for correct syntax and types.
I'm guessing this would be extremely specific to one #programming language, and outright impossible in most programming languages.
Another db question! I'm using migration files whenever I make a change to the db. When I'm doing dev, whats a good source of truth for the current structure of the tables (column names, types and so on)? I could app switch to my db admin app but I'd prefer a quick way to reference inside VS Code #sql
I have a database question - say you have an items table and a messages table, and messages can refer to items. If someone needs to delete an item, you can't because of the foreign reference in messages.
I know you could 'soft delete' - set a status column to deleted, but what if you really need to delete, for example because the content is illegal or the user has a legal right to delete it?
Django peeps. I want to link my languages table (English, French, Chinese, etc) to the word classes (Nouns, Verbs, Adjectives, etc) table. It would be a many-to-many relationship, but I'm not sure whether to use a join table or the many-to-many model. What's the most Django way?
An instance of a popular CMS is used for a website. While analyzing I'm coming across a a table in it's MySQL database where a column called "deleted" is defined as such:
deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted‘
🤦♂️
There should be a license allowing allowed to write software used by someone else. Like with drivers licenses it needs a points system for violations and license revocation. #WebDevelopment#PHP#MYSQL#SQL
Yesterday I read the recently published JSONPath RFC (RFC9535) and listening to an interview with one of the creators of SQL https://www.datacamp.com/podcast/50-years-of-sql-with-don-chamberlin and worst of all i poked around in sqlite code to figure out how the scheme table works...guess I just have to accept that I'm a query language nerd.
I was working on a problem today where I needed to pick out a department and a sub issue that were attached to each other as a single code in a comment.
I first went to use the traditional SUSTRING(comment_string, 1, 5) IN (my list of codes) but it was slow.
So off to work, I learned something new via #stackoverflow and learned to make a sarge-able LIKE with what ever I want in the narrower results.
I've started documenting various issues\problems that I face in my #sysadmin role when working in #Azure.
My first technical post is all about the challenges faced when securing #Microsoft#SQL in a multi-tenancy environment. I will write more as and when I come across other interesting issues!
This weekend, I hacked together a markdown documentation generator for Postgres in Go. It should be extensible to other databases, as well as including other properties from database.
We’re most pleased to announce the release of dbplyr 2.5.0!
dbplyr is a database backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces succinct new syntax for literal table identifiers.