A database is any organized collection of data organized to provide efficient retrieval.
0
votes
1answer
34 views
Extracting Multiple Associative arrays in PHP
public static function find_user_tracks($id)
{
global $mySQL;
$sql = "SELECT * FROM `tracks` WHERE account_id = {$id}";
$result_set = $mySQL->query($sql);
$ret = array();
...
0
votes
1answer
62 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 ...
0
votes
0answers
31 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 ...
1
vote
0answers
103 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 ...
1
vote
3answers
101 views
Program that runs correctly on GDB but not from Terminal [closed]
UPDATE
This post has been closed because my program actually had an error even though it worked in GDB so technically it wasn't meant for reviewing. However, after the help of some of friends here, I ...
1
vote
1answer
64 views
how to properly use database connections in PHP classes
I need some advice\suggestions on how to create\handle database connections for a project I'm working on. I'm creating a simple work order system for my company using PHP 5.4.3, right now there isn't ...
0
votes
1answer
30 views
Structuring data in an Android application [closed]
I originally posted this question on StackOverflow but was told to move it here.
I have an application that I have been developing for the last two years, and over the course of time it has become ...
1
vote
2answers
142 views
How to Improve This Program, Add Comments, etc.?
Do you have any suggestions to improve or extend this script? Any ideas for removing or adding comments/docstrings?
import dbm
import subprocess
import time
subprocess.call("clear")
try:
# Tries ...
1
vote
0answers
207 views
Database Handler - Dynamically create “mdf file” and tables from classes (NEED HELP/SUGGESTIONS) [closed]
I'm trying to create a handler that first of all creates a "mdf" file, which I later connect to. Then I can add tables from a type, that gets all its properties and values. So a class with 2 ...
0
votes
1answer
60 views
displaying data from from many-to-many table
ok, I'm new with MySQL, and this is a simple exercise for practice, so please bare with me.
My goal is to display all posts with their categories underneath them. The code below accomplishes this, ...
1
vote
2answers
170 views
How can make this MySQL SELECT query faster?
I have the following query which works as it should, but I'd like to know how I can make it run faster.
For info, tables cl, jo and mi all have column ref as the auto_inc primary key and ID as the ...
0
votes
2answers
46 views
Plan for dealing with eventual query consistency
I'm using App Engine's HRD datastore which only has eventual consistency. This means that if my client saves an update to an entity, I receive a guarantee that the entity will eventually be updated, ...
0
votes
2answers
144 views
Critique my Database design/help me simplify my C# code please
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
1answer
120 views
Database Code Review
public void AddClient(Client obj){
try{
using(System.Data.SQLite.SQLiteConnection conn = stock.db.SqlLiteConnection.getSQLLiteConnection()){
System.Data.SQLite.SQLiteCommand cmd = ...
0
votes
0answers
159 views
PHP MySQL insert and update [closed]
I am a little lost being new to databases. I am trying to create a page/form that, from a link only the admin can see, pulls in that $id's information from the database, displays it so that each field ...
