Slightly different database question today:
I am interested in online, remote database for my Android Apps
Is there anywhere (cheap/free) that I can use, or do I have to set up my own (I have a domain/website)
I know about Firebase, but that is NoSQL/document-database.
Un site vous permettant de trouver dans quelle bibliothèque près (ou loin) de chez vous se trouve ce bouquin rarissime que vous aimeriez bien consulter pour votre recherche de niche.
She’s being asked to take on new responsibilities at her job and wants to be properly compensated. They’re asking her to do Microsoft Access work. Her role isn’t technical and has nothing to do with it. (She’s also a Black woman who doesn’t want to get walked over because of it.)
Does anyone have any advice or info about what compensation looks like for that kind of work? Thanks in advance!
I've got a PHP website with a PostreSQL backend. It's entirely read-only in production, and its largest table has about 10,000 rows. Postgres, PHP, and a Caddy proxy all run in separate Docker containers.
Is it crazy to think that a simple system like this would run just fine with SQLite instead? In the longer term I’d like to move the whole thing to running with the Django Rest Framework and rework the front-end bit entirely.
I have a silly question for you, Fedi. I have a 1:N relationship between artists and countries table. I know countries may change, but let's assume that it's a fixed list for now. What would you do to retrieve the countries data to use in a form to create a new artist: query the DB, or just declare a constant array in the form view, and why? Thank you in advance. :) #Programming#Database
Kitten¹ now keeps two JSDB² databases per project: an internal one ('kitten._db) that holds data Kitten manages (sessions, uploads, etc.) and the default one (kitten.db`) that holds your own tables.
You’ll mostly only care about the latter.
I also took the opportunity to create a Database App Module example and document it in the readme:
I'm sort of afraid to ask but amidst all the ai blog spam I can't find good information. what's da deal with yno the different #database lib? I understand the difference between dbs with fundamentally different architectures like mongodb and couchdb, but like what's the deal with postgres vs MySQL vs mariadb and whatnot, and how come ppl seem to love to hate postgres?
does anyone out there know of an in-process vector DB that runs in the same process as the application? like SQLite but for vector stores? #LLM#LLMs#AI#vector#database
This is the most comprehensive history of Ashton-Tate dBASE I've seen, an amazing story of technical achievements and facepalming mismanagement. I didn't know the product is still around and available for sale.
...and I've run into the same problem I hit before...
I have 3 Entities (Scoundrels, Crews, Contacts)
I have "Scoundrel with Crew" working (Each scoundrel is in exactly 1 Crew. A Crew can have 0+ Scoundrels)
I need to add Contacts. Each Contact can be known to many Scoundrels, and Many Crews.
Each Contact also has a Rating ("Friend", "Neutral" or "Hostile") with each relationship.
I'd like to start by building adding Scoundrels/Contacts relationships
which tool are people using nowadays for #database#migrations? Are you using a library in your application programming language or an external tool? What are the current best practices?
Cantus: A Database for Latin Ecclesiastical Chant - Inventories of Chant Sources | Cantus Manuscript Database https://cantus.uwaterloo.ca/
"Cantus is a database of the Latin chants found in manuscripts and early printed books, primarily from medieval Europe. This searchable digital archive holds inventories of antiphoners and breviaries -- the main sources for the music sung in the Latin liturgical Office -- as well as graduals and other sources for music of the Mass."
Question for the #MySQL / #MariaDB buffs, I have three tables defined thus:
CREATE TABLE IF NOT EXISTS `user` (
`uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`uid`)
);
CREATE TABLE IF NOT EXISTS `gserver` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`id`)
);
CREATE TABLE IF NOT EXISTS `user-gserver` (
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`gsid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gserver id',
...
PRIMARY KEY(`uid`,`gsid`),
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
);
Running the last query triggers the error Foreign key constraint is incorrectly formed. Is there no way to reference multiple tables in foreign keys out of a compound primary key?#SQL#Database#DBA
I want to use #surrealdb, but I am unsure if it is safe enough to use in a hobby project. I know many people have already started using it, and I doubt anything I make will get heavy usage... but it’s such a powerful, different type of #database I really want to try leveraging it.