Tagged Questions
1
vote
3answers
39 views
Transaction handling for multiple SQL statements
In this code I update two tables called Payment and SalaryTrans. First I insert records (Salary payments) to ...
5
votes
1answer
66 views
Selecting template from database using organization ids
This is my first SQL post over here, and in fact, I have more or less the experience of a regular SQL programmer, except that the task at hand this time was way harder than normal.
I am expecting, ...
12
votes
3answers
175 views
Database schema for holding game save files
I have a database schema for a game to hold save files where some tables have a one-to-one relationship to classes. I was wondering if I should split up some tables.
Example: ...
5
votes
3answers
68 views
Relational schema and query for multiplayer tabletop game
As an exercise, I was asked to design a database schema (for MS SQL Server) for a tabletop game. The requirements were simple: players compete in matches and there are specific match types (e.g. 1v1 ...
4
votes
3answers
146 views
Did you like my product?
I have the following MySQL query which selects product details and whether the viewing user likes them. I feel like it could be more efficient and that there is a more practical approach than using a ...
7
votes
5answers
2k views
7
votes
2answers
40 views
Revision 2 - Step 1: PsychoProductions management tool project
I have been told by DBA.SE people that this was off-topic for DBA.SE and should be on CR.SE instead. So... here I submit this database schema design for my trusted fellow CRitters to review!
This is ...
1
vote
2answers
563 views
Flexible and modular CMS with user management in CakePHP
Please review my database design:
I think it is quite self-explanatory, but to be absolutely clear:
My goal is to make an application which has a super flexible user management (which is why the ...
6
votes
1answer
96 views
Music categorization database
Recently I've tried to teach myself basic things about MySQL databases, however I received some help on Stack Overflow with creating a good database structure trying to avoid redundancy as much as ...
3
votes
1answer
182 views
Backup a database over an SQL connection
Developing some industrial WinForms application for some industrial setting, I wanted to provide users of our software with a convenient way to back up the database the software uses (to send it to ...
3
votes
3answers
74 views
Schema for allowing adding tags to entities in unrelated tables
I'm implementing a "tags" features to an already working solution.
Final users need to be able to add tags to three separate sections of the solution:
Posts
...
4
votes
1answer
657 views
Schema for Google Docs-like sharing
I want to allow users to share documents (and other stuff) in a database-driven application.
I have designed the following schema to allow for this (PostgreSQL). Some of the tables like ...
5
votes
1answer
1k views
Database Class Creator
Overview
I've written a class that will create C# code. The output is a single .cs file for each table in the default database (the database is defined inside a web.config file). I'm looking for a ...
4
votes
2answers
4k views
Database Access class
I'm looking for any comments or feedback on my database access class. Security and speed are two things I'm most concerned about.
One thing to note is this class has to work in a C# .NET 2 ...
3
votes
1answer
150 views
Is this an efficient way of accessing the database?
I followed this tutorial to create an SQL "factory".
The link shows how to make a class who's methods will output SQL statements based on the arguments you pass to it, and I've expanded on it with ...
11
votes
2answers
78 views
Revision 1 - Step 1: PsychoProductions management tool project
I started a project to build my own invoicing and management system to take the place of prohibitively expensive QuickBooks software. This will be broken down in 5 steps, with the current step in bold ...
3
votes
2answers
527 views
Protecting a database from bad data
I'm just getting into SQL injection and data sanitization and seeking some advice on my script to get started. I have made this simple program which allows the user to enter their name into a form and ...
1
vote
1answer
43 views
First Schema for Location and Countries
This is my first MYSQL schema for caching location data (co-ordinates to place names) and referencing it with a country.
I was wondering what everyones feedback was on it, did I do a good job?
...
2
votes
1answer
55 views
Delivery geolocations query
I have the below MySQL query that does exactly what I need. But I am sure there are better queries that do the same thing.
If you see something very ugly or bad and have any suggestions, I will be ...
5
votes
4answers
434 views
Database schema for Service Order Management project
I'm a student and I've created this MySQL database schema for my Service Order Management academic project. I want to know if I need to improve it and, if so, how I could do that.
...
5
votes
1answer
568 views
Logfile parser for Team Fortress Classic video game
I'm currently working on a logfile parser for a pretty old videogame called Team Fortress Classic, which can be compared to Counter-Strike 1.6 and is available on Valve's Steam platform.
I started ...
1
vote
2answers
240 views
Critique my database design and help me simplify my code
I wish to create a database for a webpage where users are able to add their own events to a timetable. Users will be able to decide if the events should be recurring (weekly) or not. Users should be ...
2
votes
2answers
958 views
Relationship design for auto parts store database
I'm creating a design database for an autoparts store (this is a project school). For the moment, I'm not sure if the relationship model especially in MODEL, MAKE, BRAND is correct (I really have no ...
1
vote
2answers
844 views
SQL database design e-commerce
I am new to database design but am fairly familiar with SQL and its syntax. I want to create a database for an E-commerce website that will sell a single product type such as a shirt. They could be ...
4
votes
1answer
2k views
designing a multi restaurant schema [closed]
I'm trying to design a multi-restaurant menu review system in php/mysql. while designing, I came up with a schema for the system.
but first, here are the rules:
there are multiple restaurants
each ...
2
votes
1answer
195 views
Review my database structure and tell me your suggestions on it
I would like your thoughts on my database structure. I am kind of a rookie but I am trying. All of your suggestions, alternatives, ideas, additions are welcome. Thank you.
...
3
votes
1answer
193 views
Monthly rollover system
I have learned a little python for a few projects at work. This is my first "finished" application and I was hoping someone would take a look at it. I would love some tips on the noob mistakes I am ...
2
votes
1answer
143 views
Building database from file C# Mysql
well as the question reads I am building a database with 3 tables. Now these tables are going to be used to store names in.
Table 1 will store First Names
Table 2 will store Last Names
Table 3 ...
1
vote
1answer
120 views
Database schema suggestions for a Minecraft logging plugin
This is my attempt at creating a database schema for a Minecraft logging plugin. I'm by no means a SQL expert, so suggestions would be greatly appreciated.
...
2
votes
1answer
86 views
Sanity check on grouping query
I have a table containing URLs as they should appear in English and equivalent translations of them into other languages. Originally, I was told that there would always be an English translation, so ...
3
votes
2answers
129 views
Querying a database with PHP
I'm new to PHP programming. I would love some feedback on this simple code I wrote which queries a database based on some arguments supplied by a user and returns an HTML table displaying the data.
...
1
vote
2answers
176 views
First Database Schema - How did I do?
I would really like some advice from any DB gurus who have a few minutes free. After doing some reading and playing with sqlfiddle over the weekend I have constructed this postgresql schema and it is ...
1
vote
1answer
165 views
How to write a stable WCF service
I'm writing a WCF service for validating password and getting company ID for the clients that requests the services. The service runs on a server locally as a windows service, which sends queries to ...
-1
votes
1answer
238 views
Connects to database but cannot get table [closed]
I use this php code to connect to my databse and retrieve the table food. I am able to connect to the database but no retrieve the table. I get this as a result: ...
2
votes
3answers
134 views
Referential MySql Design
How does this look? It has been over a year since my database concepts class and I have never worked with MySql. I have chosen InnoDB as my engine because of foreign key support using UTF-8 based on ...
5
votes
1answer
784 views
PHP Login Authentication with BCrypt
So I have a php authentication script and everything works fine. But I'm very unsure about the way I programmed it (i hardcoded some stuff) and I was hoping stack could look through this and point out ...
4
votes
1answer
262 views
Please review my PDO Database wrapper
The subject is this small project - PHP/MySQL Database wrapper
The three main goals of this projects are:
Easy way to map database columns to object properties
Simple solution to insert or update ...
6
votes
1answer
378 views
Android database interaction logic
I have a database-intensive app. Almost every activity requires access to the database, both reading and writing. I had a lot of problems with separate threads and activities on the stack closing ...
0
votes
1answer
2k views
Data Structure for Categories and SubCategories
I have this relationship:
Many Objects to One Category
One Category to Many SubCategories
I am looking for the best way to store this in my Relational Database? Here were some of the ways I was ...
1
vote
1answer
189 views
2
votes
1answer
120 views
Refactor my simple SQL Statement
I have the following SQL statement that I think could be improved in areas (I believe there may be a way to use where over having, but I'm not sure how and I'm sure there's a way to reference the last ...
2
votes
1answer
267 views
Newsletter SQL query optimization
I want to build a small newsletter like tool which sends mails in pre-defined timespans. First after registration, second 14 days later, third 7 days later etc.
I came across for two database designs ...
3
votes
1answer
378 views
