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.
Have any of you Rust developers ever used Skytable and been satisfied so far? Is it also 100% open source or do I have to pay attention to something like SurrealDB and can GraphQL or something similar also be used on it?
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.
Explore essential NoSQL interview questions to understand how NoSQL revolutionizes data management, enabling seamless handling of structured and unstructured data in real-time.
We’re thrilled to announce dplyr powered by DuckDB: duckplyr 🎉
A collaboration between the dplyr project team at Posit, cynkra, and DuckDB, duckplyr is a powerful new option that marries the user-friendly dplyr syntax with the execution capabilities of DuckDB.
I'm looking to start a #business designing and installing #database s for very small businesses. Not full #sql servers, but something like MS Access (local files). Unfortunately, there are no good #foss alternatives for it. #LibreBase leaves a lot to be desired, and #Kexi hasn't updated for some time now. That leaves the online #NocoDB as the best option, but I rather not deal with online stuff because internet is not reliable in my area. Plus that tends to fall into #enshittification over time.
NoSQL Interview Questions and Answers in 2024 (www.onlineinterviewquestions.com)
Explore essential NoSQL interview questions to understand how NoSQL revolutionizes data management, enabling seamless handling of structured and unstructured data in real-time.