Question : I’m working on an application which would mimic the Twitter Lists functionality in which someone can follow someone […]
Tag: application-design
Database structure for users, events and event lists
Question : I am creating a web service for managing events. The service will have users, who are listed in […]
How to UPDATE data without locking every record the search encounters?
Question : We have the following database specifications: version: 10.1.47-MariaDB-0ubuntu0.18.04.1 innodb_version: 5.6.49-89.0 tx_isolation: READ-COMMITTED innodb_strict_mode: ON sql_mode: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION autocommit: ON […]
Trigger calls and application code
Question : When a trigger is set on a table does the application code wait for the original statement and […]
Entity-relationship diagrams and application program functionalities
Question : It seems that the core functionalities of an application program I’m working on are nothing but associative entities. […]
Inserting data into multiple tables
Question : For my system, students are required to create a user account by completing a registration form (personal, contact […]
Are individual queries faster than joins?
Question : Conceptual question: Are individual queries faster than joins, or: Should I try to squeeze every info I want […]
Help With MySQL Computed Columns/Auto Updating Field Based On Average
Question : I am currently building a social network type application on-top of MySQL and have run into a problem […]
When should I reference the User record or User Profile record
Question : I know it is a common paradigm to separate tables when building a User profile. For example, having […]
How to use a foreign key?
Question : I’m creating the following table: CREATE TABLE fund_identifier ( id BIGSERIAL PRIMARY KEY NOT NULL, identifier TEXT NOT […]