657,057 questions
Score of 0
0 answers
11 views
How can an open-source database maintainer ask for technical feedback without turning Stack Overflow into promotion? [migrated]
I maintain a GPLv3 open-source SQL database project. I started it because some customer workloads have become difficult to serve with conventional MySQL/PostgreSQL deployments. The affected workloads ...
- reputation score 1
Score of -5
2 answers
256 views
Can I perform a (LEFT) JOIN with a potentially not-existing table?
I need to join a table, that might not exist. Is it possible to specify a condition in the query, so that the join is only performed if the table actually exists? My idea would be that the ...
- reputation score 532
Score of -5
1 answer
136 views
Is it possible to store the definition of a table in a database?
I can of course create a table with SQL. But is it possible to only define the structure (including specified types, primary keys and constraints), so that later only the table name needs to be ...
- reputation score 532
Score of 0
2 answers
201 views
Operation not permitted on mysqli_connect()
I have the following code and it was perfectly at least for a year. Two months ago the query inside the main query after 19th row main row crash with the following message:
Fatal error: Uncaught ...
- reputation score 19
Score of -2
2 answers
118 views
How to use images when it comes to SQL databases? [duplicate]
I´m developing a database using MySQL for a food delivery website, and I want it to have pre inserted items and also the option to insert new products. How do I store the images? I read that you can ...
- reputation score 7
Score of -6
1 answer
161 views
Laravel Eloquent whereHas() query is slow with large datasets [closed]
I’m working on a Laravel application using MySQL where I need to filter products based on related records. The query works correctly but becomes slow when the database contains a large number of ...
- reputation score 1
Score of -2
1 answer
125 views
Running MySQL get results and exit [closed]
I want to run MySQL to test the connection from my C++ code so if I get a connection the process should just exit.
Is there an option to do that? Or it will detect it automatically?
I'll be running it ...
- reputation score 6512
Score of 1
2 answers
161 views
Selecting non blank data in aggregation query
I have a table with some order data in it: A simplified summary is like this:
OrderNum
Revenue
Payment
RecordType
OrderData
1
30
0
Order
Shirt-Size:Large
1
0
30
Payment
2
20
0
OrderAmended
T-Shirt:...
- reputation score 95
Score of 2
1 answer
452 views
Chance of conflicts using stateful classes
TL;DR: is it a bad practice to use a stateful JS class?
I am building a website using Node.js and Express, using MySQL as my DB.
To use the DB I have made a simple CRUD MySQL ORM to retrieve and save ...
- reputation score 92
Score of -1
1 answer
169 views
Insert record with foreign key if primary key is missing or not?
I have two tables with a primary-foreign key relationship.
A value in the foreign key table must be present in the primary key table.
What is a stored procedure to insert a record into the foreign key ...
- reputation score 73
Score of -2
1 answer
254 views
Is replaying a transactional outbox in auto-increment ID order will maintain the order of events?
I'm implementing a transactional outbox pattern and trying to replay events in order.
After outbox events are published, they are stored in an inbox table on the destination. A separate process ...
- reputation score 2475
Score of 2
1 answer
144 views
LOAD XML SET field name with minus
Taking the example:
<?xml version="1.0"?>
<employee person_id="1" f-name="Kapek"></employee>
<employee person_id="2" f-name="Sajon&...
- reputation score 43
Score of 0
1 answer
257 views
Error Code 1054 unknown column in 'field list' error without Group Concat Actor [closed]
I am playing around with the Sakila database. There is a view in this database named film list.
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sakila`.`film_list` AS
...
- reputation score 9
Score of 3
1 answer
212 views
Find identical aggregated combinations from pivot table in SQL
Background
I’m updating a very old website which has a tagging feature for objects. The tags are divided into nine separate semantic categories and can be related to objects via a pivot table. There ...
- reputation score 972
Score of 1
1 answer
214 views
How to design a zero-downtime schema migration strategy for a high-traffic Laravel/MySQL application with hundred of millions rows?
I am designing a Laravel application that handles millions of daily requests with a MySQL database containing tables with hundreds of millions of rows.
A common requirement is adding or modifying ...
- reputation score 21
