Questions tagged [mysql]
MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.
1,091 questions
4
votes
2
answers
108
views
Polymorphic data models that save data to MySQL and restore data from MySQL
This is a follow up question to Inserting and retrieving data MySql Database access in C++ using Boost::ASIO and Boost::MySQL. I have reduced the amount of code to be reviewed by presenting only one ...
- 26.1k
2
votes
1
answer
72
views
My first attempt to insert and retrieve data from a MySQL database using the boost::mysql library
About the Project
This was a go/no go prototype for a project that would store the data a combined personal planner software with project planning software in a relational database. It was also a ...
- 26.1k
1
vote
0
answers
59
views
Inserting and retrieving data MySql Database access in C++ using Boost::ASIO and Boost::MySQL
About the Project
This is a unit test and a prototype for the database portion of a project that would store the data a combined personal planner software with project planning software in a ...
- 26.1k
2
votes
1
answer
59
views
Cmake build system for prototype planner software using boost and other previously written code
I'm prototyping/debugging some C++ code that I may turn into a longtime project. The build system is ready for review, the prototype is not.
The GitHub repository for the code listed below.
Like all ...
- 26.1k
6
votes
2
answers
722
views
Weather Observation Station 8 query
Here's my (correct) solution to a HackerRank question:
Weather Observation Station 8
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last ...
- 277
3
votes
1
answer
88
views
A function that returns correct number of inserted, updated and skipped rows for INSERT or UPDATE query
When MySQL executes a Data Modification Query, it provides some additional info on the outcome, which is usually displayed in the console. This info is also being exposed through MySQL C API and this ...
- 9,123
5
votes
3
answers
1k
views
Slow SQL query with nested subquery
I have written the below query in order to identify how many events (occur over a week) in each hour.
...
- 413
4
votes
2
answers
488
views
Improving upon the Security of my Export Remote Database to Local PHP API
I am working on an in-house application, and I am working on how our application communicates with our remote server.
I have a PHP script that acts as an API to call to our MySQL DB and dump its ...
- 43
7
votes
4
answers
2k
views
Program for an employee database using python
In this program I'm defining functions to perform different tasks on a data record book for employees.
Here is a summary of the code:
Intro() to make the presentation of the home page.
create_record()...
1
vote
0
answers
75
views
Connection pool design for Boost MySQL
I had to design a connection pool that handles Boost MySQL connection to use the asynchronous functions.
Here is the code:
...
- 41
3
votes
1
answer
147
views
Faster Query to Track State changes in a Large Table
I have a table that tracks state changes of an entity with timestamps. The schema of the table is as follows:
entityid
userid
originalvalue
newvalue
changetime
255
101
Draft
Submitted
2023-11-28 12:10:...
- 53
4
votes
1
answer
141
views
Evaluating Extended Operating Hours Past Midnight Across Timezones in PHP
I am working on a project that involves tracking the operating hours of businesses across different timezones. Some of these businesses operate past midnight, and to accommodate this, operating hours ...
- 403
2
votes
1
answer
266
views
8
votes
3
answers
1k
views
A simple PHP login form with PDO
I wrote a simple PHP login form for a website. It has an initialization script, as well as a form to allow a user to login, plus a link to log the user out after logging in.
...
- 591
3
votes
1
answer
132
views
Consuming sharded database using node.js
I think the only big improvement that can be made is to check which shard to query based on the userIds of the followed users. One easy way is to check the last ...
user225166