Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Posts tagged database

3 child tags

For questions about databases in general. A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, stored procedures and other objects. Avoid using this as it is too generic and replace it with the actual used database instead whenever possible.

This tag doesn't have a detailed wiki yet.

50%
+2 −2
Q&A What is the default port number of MariaDB?

What is the default port number of MariaDB database server? (Remembering defaults is surprisingly hard since usually you don't need to specify them..)

1 answer  ·  posted 3mo ago by Iizuki‭  ·  last activity 3mo ago by manassehkatz‭

Question database port mariadb
66%
+4 −1
Q&A How to implement a relationship between 2 tables where the type of participation is mandatory and RESTRICT rule for both?

Found the example below in a book teaching logical database design, but I'm stuck on how one would implement this in PostreSQL: The diagram reflects the following business rule: An instructor...

1 answer  ·  posted 5mo ago by toraritte‭  ·  last activity 5mo ago by Derek Elkins‭

85%
+10 −0
Q&A Alternatives to `EXPLAIN ANALYZE` for queries that won't complete

I have a large and complex PostgreSQL SELECT query that I would like to make faster. EXPLAIN suggests it should run quickly, with the worst parts being scans of a few thousand rows. When run, it do...

2 answers  ·  posted 6mo ago by Emily‭  ·  last activity 5mo ago by matthewsnyder‭

66%
+2 −0
Q&A Can I package a database other than SQLite with a Flutter app?

Flutter supports packaging a SQLite instance with a Flutter app using the Sqflite plugin. I do not like the speed of SQLite or the fact that it does not enforce column datatypes and want to use som...

0 answers  ·  posted 8mo ago by tarhalda‭  ·  edited 8mo ago by tarhalda‭

Question flutter database
57%
+2 −1
Q&A Can pandas be used as a database backend for persistent storage?

Question What is the current state of the art database app? How does it compare to SQL? Can pandas be used in place of either? If not, is there something that bridges the gap between SQL and pand...

2 answers  ·  posted 8mo ago by mcp‭  ·  last activity 8mo ago by matthewsnyder‭

72%
+6 −1
Q&A Best practices in setting up a development & production environments

I am developing a web app that is tied to a database. My codebase is stored on a private GitLab instance. I would like to set up a workflow that would look something like this: I have a developm...

1 answer  ·  posted 2y ago by Mu3‭  ·  last activity 11mo ago by Mithical‭

Question database devops
33%
+0 −2
Q&A How to distinguish between single and multiple file media?

In a media manager I have database tables for files, media and collections. When a user is browsing a collection I want there to be links to see the metadata for single file media like books, movi...

2 answers  ·  posted 1y ago by filosoful‭  ·  last activity 1y ago by r~~‭

Question database
40%
+2 −4
Q&A unable to create databases in Ruby

I had installed Ruby. rvm install 2.6.6 I had Ruby which version was 3.0.0. I had removed it. Then, installed 2.6.6. When I try bundle install I got no error. When I tried following command...

0 answers  ·  posted 2y ago by deleted user  ·  edited 2y ago by Alexei‭

66%
+2 −0
Q&A How to write database friendly code when using an ORM?

There are a lot of articles and presentations that show little love for ORMs. This is mainly because some queries are so complex and heavy on the database that they lead to significant issues in p...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by Alexei‭

75%
+4 −0
Q&A In the current development context (2020+), is there any reason to use database triggers?

I have not used a database trigger in years in the projects of the teams I have worked in, but I have seen them being used by other teams. Back in 2009, it seemed like a heated debate, but I am wo...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by Derek Elkins‭

50%
+1 −1
Q&A How to grant privileges to a user on a database specifically (i.e. not globally) in PHPMyAdmin?

In PHPMyAdmin 5.1.1 I have created a user account and a database with the same name and granted all privileges to the user on that database. I have exported the database to a backup file, deleted ...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by deleted user

Question database
75%
+4 −0
Q&A What are the disadvantages of using SQL Server Replication - Transactional Replication type?

The context A reports related process is directly reading the production operational database once about two hours. This involves reading all the data from some 70 tables which takes a couple minu...

0 answers  ·  posted 2y ago by Alexei‭

71%
+3 −0
Q&A How to copy a PostgreSQL database to another machine.

I have to debug an error which seems to only happen with some set of data present in our PostgreSQL database. I'd like to copy said database to my local machine so I can perform tests without affe...

1 answer  ·  posted 2y ago by Estela‭  ·  edited 2y ago by Alexei‭

50%
+0 −0
Q&A When is information schema not needed and when is it indeed when migrating from one website hosting provider to another?

In some situations, could it be problematic to migrate a website's database (MySQL) from one website hosting provider to another without the information schema or with the information schema? In m...

0 answers  ·  posted 3y ago by deleted user  ·  edited 3y ago by deleted user

Question mysql database
75%
+4 −0
Q&A Is migrating emails from one hosting provider to another a trouble?

I rent a shared-hosting environment with CentOS-Bash, Apache, PHP, MySQL and a web-based IMAP email client (Roundcube) and some more tools, on which I host my personal website; I don't have Cpanel...

1 answer  ·  posted 3y ago by deleted user  ·  last activity 3y ago by manassehkatz‭

75%
+4 −0
Q&A How to reason about transaction isolation during development

Consider the following code: public class OnlineShoppingService { @Transactional public void cancelOrder(String id) { if (shipmentRepository.findShipmentForOrder(id) != null) { ...

1 answer  ·  posted 3y ago by meriton‭  ·  last activity 3y ago by Alexei‭

70%
+5 −1
Q&A How to separate DB query logic from the application other than implementing a repository on top of an ORM?

I've been doing a lot of reading on implementing the repository pattern in C# projects and found controversy, or shall I say some strong criticism, made by seemingly very smart people with previous...

1 answer  ·  posted 3y ago by Marc.2377‭  ·  last activity 3y ago by Alexei‭