A database is any organized collection of data organized to provide efficient retrieval.

learn more… | top users | synonyms

-1
votes
0answers
15 views

Using linked list to make a simple version of word/sentence predicting software (e.g T-9) [on hold]

Hey Guy/Gals, I want to develop a simple program using linked list/trees for predicting words or sentences WITHOUT using file handling because i haven't been taught file handling yet ...
1
vote
0answers
37 views

My database class extends MySQLi

The following is a small class I extended MySQLi with. I'm going to use this in my upcoming projects, but my main reason to do this class is learning, so I would like to submit this for your review, ...
5
votes
1answer
30 views

Separating Duplicates from Uniques

I have a MySQL table with a very large data. What I need is to find and separate duplicates from the unique rows Let's say this is my table: ...
3
votes
1answer
56 views

Flat-file DB with CRUD

I just finished writing a flat-file DB class for PHP which supports selecting, updating, inserting and deleting. I was wondering if there are any ways to make it faster or if I'm doing anything the ...
2
votes
1answer
41 views

Appropriate way to create object for storing data in a ListView & Profiling

I'm creating a location based reminder application in Android using proximity alerts, geocoder, Google Maps API and their Places API. Currently there is a default ...
2
votes
2answers
77 views

how can I factor out REST-POST activity to a manager?

I have this RestPostActivity: ...
3
votes
1answer
197 views

Simple in-memory database

How can I improve this code (elegance, best practices, etc)? ...
7
votes
1answer
222 views

Using keywords async/await in database queries (Windows Phone 8)

I have a local database in Windows Phone 8 app. The app includes a lot of queries to the database and I don't want bad effect on the responsiveness of UI. For ...
6
votes
3answers
152 views

Repository pattern review, question about when dispose the Context

I have a question about the Repository pattern. This is my repository: ...
4
votes
4answers
84 views

Music list program

I need a little help with improving my first Java program. I have programmed for about a month, so my code is quite messy. The program is a "Musiclist" program, with which you can add songs, edit ...
4
votes
1answer
138 views

In-memory data cache architecture for data transfer

I am writing a cron job to manipulate and transfer remote data. I need to cache data from a table, process it, merge with previous table, iterate the process, and eventually send the result data to ...
1
vote
1answer
94 views

Updating visiting dates of each visitor

I am still a PHP beginner. Please review/improve my PHP code and reveal errors, typos and warnings. ...
1
vote
1answer
61 views

Data table class

so this is my code and I just want to improve it, I'm a beginner so I think there are some better and short ways to do what I did here. Any Ideas? The code: ...
1
vote
1answer
72 views

Login and User Information Requests

I am trying to improvise a piece of code. The best is to get reviews from experts, so here I am. Can you have a look? What do you think of it? Any suggestions? This code basically connects to a ...
5
votes
1answer
187 views

A Simple Cache class

“There are only two hard things in Computer Science: cache invalidation and naming things.” -- Phil Karlton That being said, I created this SimpleCache class which I intend to use to cache ...
1
vote
0answers
81 views

In-memory data cache architecture

I am designing basic in-memory cache storage with thin CRUD (actually CRD) interface. The design is inspired by the Backend solutions such as Parse and StackMob. Main requirements: Cache consists ...
1
vote
2answers
522 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
2answers
204 views

Implementation of OOP for retrieving list of objects from database

If I have a Person class that outlines the properties of a person and one of People that just contains a ...
0
votes
1answer
69 views

API request and database insert

This is a pretty big undertaking for me with my basic skills, and I was kind of flying blind. It's basic in its intent: get a bunch of case info from a helpdesk app and put it into a database. There ...
2
votes
1answer
126 views

Insert or update a user in database

The code uses SQLAlchemy Core. However, what I want to know is if writing code in this pattern is recommendable. ...
3
votes
1answer
840 views

How to use ByteBuffer properly?

I am trying to use ByteBuffer properly with BigEndian byte order format. I have couple of fields which I am trying to put together into a single ByteBuffer before storing it in Cassandra database. ...
2
votes
1answer
521 views

Builder pattern for Codeigniter ActiveRecord queries

I am using Codeigniter and it's ActiveRecord. I had this idea for a base class that provided a generic getter/setter for doing simple queries on a database. I have a lot of database objects that ...
4
votes
2answers
114 views

Optimizing join statement

I have this piece of code: ...
2
votes
1answer
153 views

Building a simple database in Python

I choose to use a dictionary to store the variables for fast GET and SET commands. In my code, I have saved all of the open ...
1
vote
1answer
629 views

PDO class for multiple databases

I have PDO class below: ...
1
vote
0answers
32 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? ...
11
votes
1answer
10k views

Very simple PHP PDO class

There are many PHP PDO classes out there, agreed. However I find they do not allow for flexibility. So I created one that helps reduce development time as little as it may be but it does the job ...
0
votes
1answer
187 views

guide me to make my code perfect

I had made some of pages and they work but I'm not sure if I coded it in best way so I want your suggestions and ideas to make my code better. connection.php ...
1
vote
1answer
106 views

Generic DB Value Getter

I'm trying to see if there is a better way to do this when I just need one column with one row. Do not mind the lack of use of a prepared statement, I will put it in. ...
5
votes
1answer
503 views

MySQL one-to-many relationship - is this the right way?

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 ...
3
votes
2answers
124 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
1answer
67 views

User Data Security Improvements

** Original Question From Stack Overflow ** I'm working on my site, and need help knowing what I need to do to improve the security of my login system. If you feel so inclined, I would love some ...
2
votes
1answer
105 views

Need your opinions on my database normalization attempt [closed]

I'm working on a project with CakePHP where it will allow users to log their drug use. Be it alcohol, caffeine, or whatever else. When people add a log, they select the substance from a drop down, ...
2
votes
3answers
98 views

Improve my SQL select statement

I have three tables for a blog system. The blog ...
5
votes
1answer
522 views

Generic method for database calls

Background Breaking from MVC, I've implemented the following architecture: POST/GET ➤ PHP ➤ Database Calls ➤ XML ➤ XSLT ➤ HTML All database interactions are ...
0
votes
1answer
111 views

Database “design” using Symfony2 and Doctrine2

I'm working on an application, which tracks expenses. I have users. Each user can create his categories for the expenses (like Food, Bills, Transport, Drinks, Clothes) and then create expenses - each ...
3
votes
1answer
2k views

asp.net (vb.net): handling of open database connection and calling shared function from web api

I'm working on an ASP.NET project using VB.NET that uses Dapper and the code as implemented so far runs fine with just me testing. In the example below, Dapper calls a stored proc. But my I am ...
3
votes
2answers
370 views

Android database access

For my simple Android application, I don't want to use an ORM. I'd like to have a db-communcation layer easy to user, to read and efficient. This is my solution: every entity (ex: Person) as an ...
2
votes
1answer
202 views

DAO Layer Code Review

Please review my following code for DAO layer. ...
2
votes
1answer
222 views

Keeping track of people's relationships in MySQL using a people relation table?

I am trying to track relationships among people. I came up with my own solution, but wondering if there might be another way or better way of doing this. To keep it simplified, I'll post just the bare ...
2
votes
1answer
278 views

Testing database table creation with NUnit

I'm new to using NUnit and have written a test to check for the existence of a database table. I have the below code that should check whether a new table named NewTable has been created in the ...
2
votes
1answer
55 views

ORM Entity with many similar relationships

To provide some background context, I'm implementing a web-based solution (Java, Spring, Hibernate) that allows the creation/authoring of task-centric workflow documents. Basically a workflow ...
1
vote
2answers
133 views

Make code looks more cleaner in the run method

I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around ...
3
votes
3answers
89 views

Simplify things in the run method to look cleaner

I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around ...
1
vote
2answers
251 views

PHP Class Inheritance / Object Instantiation / Object / Property Scope w/ Child / Parent Classes & Dependency Container Class

In PHP, I have a parent/child class and am using dependency container to load them. I am trying to use the same database connection on all of them without duplicating the object. CLARIFICATION: MY ...
1
vote
2answers
159 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
2k views

Nhibernate session and transaction implementation

In order to create loose coupling architecture on my web applications, I have created my own implementation for orm, in this case, nhibernate. I want you please to review the code and tell me if you ...
1
vote
1answer
142 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 ...
0
votes
2answers
156 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 ...
1
vote
1answer
125 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 ...