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.
"The Querynomicon" has had some updates: content split into multiple pages, start of a section on PostgreSQL's roles and permissions thanks to Konstantinos Kitsios, and general tidying up https://gvwilson.github.io/sql-tutorial/ Still lots to do; contributions gratefully accepted. #sql
DuckDB released a new R package - duckplyr, which enables running dplyr functions using the DuckDB engine on the backend ❤️. The package, on the backend, translates and maps the dplyr code into DuckDB. This will enable dplyr users to work with large datasets with higher performance.
This is the first release that has native asyncio support for PostgreSQL and MySQL without indirecting it through Twisted's threadpool, which opens up its usability into a lot more contexts. Give it a shot and let me know what you think.
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.