A database is any organized collection of data organized to provide efficient retrieval.
0
votes
0answers
9 views
Maintain database sequence after drag and drop
Background
A User Interface provides people with the ability to rearrange rows of an HTML <table> element using jQuery's sortable API. I have exposed a stored procedure to facilitate updating ...
7
votes
0answers
23 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 example I have a table of users and ...
6
votes
3answers
72 views
Repository pattern review, question about when dispose the Context
I have a question about the Repository pattern. This is my repository:
public abstract class RepositoryBase<T> : IDisposable, IRepository<T> where T : class, IEntity
{
/// ...
2
votes
2answers
55 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 ...
0
votes
1answer
82 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
93 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.
<?php
date_default_timezone_set('UTC');
$connection = mysqli_connect("localhost", "root", ...
1
vote
1answer
55 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:
class Table:
def ...
1
vote
1answer
64 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
80 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
66 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
177 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
151 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 List<Person> like so:
public class Person
{
public Person(){}
public int ...
0
votes
1answer
54 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 ...
0
votes
0answers
104 views
Is this code Pythonic?
The code uses SQLAlchemy Core. However, what I want to know is if writing code in this pattern is recommendable.
def saveUser(self, user):
"""
Inserts or updates a user in database.
The ...
2
votes
1answer
309 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
104 views
Optimizing join statement
I have this piece of code:
List<myItem> items = (from x in db.myItems
join y in db.tblParents on x.item_parent equals y.id
where !y.hidden
...
2
votes
1answer
116 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 transactional blocks in memory. I can't see any way around this since it ...
1
vote
1answer
409 views
PDO class for multiple databases
I have PDO class below:
class DB {
private $dbh;
private $stmt;
static $db_type;
static $connections;
public function __construct($db, $id="") {
...
1
vote
0answers
29 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?
...
6
votes
1answer
5k 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
170 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
<?php
$mysql_host = ...
1
vote
1answer
82 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.
public <T> T ...
5
votes
1answer
235 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
111 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
64 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
100 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
96 views
Improve my SQL select statement
I have three tables for a blog system.
The blog
CREATE TABLE IF NOT EXISTS lm_blog(
blog_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(80) NOT NULL UNIQUE,
action ...
5
votes
1answer
430 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 relegated to the call method in the ...
0
votes
1answer
95 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
1k 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 ...
1
vote
0answers
283 views
Android database access
For my simple Android application I don't want to use an ORM, anyway 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
180 views
DAO Layer Code Review
Please review my following code for DAO layer.
public List<Channel> getListOfChannels() throws DataAccessException {
// will have the channel in form of List
// to hold the ...
2
votes
1answer
165 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
232 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
53 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
124 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 30-35 columns. I wrote a Stored procedure that will UPSERT into those ...
3
votes
3answers
76 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 30-35 columns. I wrote a Stored procedure that will UPSERT into those ...
1
vote
2answers
206 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
145 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
1k 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
114 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
150 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
103 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 ...
2
votes
1answer
1k views
Rails 3: How can I improve this ActiveRecord count
Here I retrieve a collection of causes from the database. Along with the information from each cause, I want to send the number of users in each cause. This way works, but if experience has told me ...
-1
votes
1answer
135 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: Host information: site.ipagemysql.com ...
1
vote
1answer
140 views
Improve and adding new method to GenericDataAccess?
I have this GenericDataAccess class to interact with database from my school just I want to ask for some suggestions and advice in how to to improve it and add new methods to for future use & ...
3
votes
2answers
126 views
Javascript Coding Wager
I have two scripts written by my co-workers for auto-filling a form with information from the facebook graph-api. I am trying to figure out which has been coded in a more efficient style?
This is the ...
0
votes
3answers
63 views
What is the best way to save this? (saving the data generated by an application) [closed]
I have this code, and i want to save the generated data, but i don't know how, A database? a file? do i need to chance everyting in the code and start over again?
I'm from brazil, so the variables ...
2
votes
1answer
1k views
reusable data access class in C#
Below is my attempt at the beginnings of a reusable ado.net data access class. Please let me know of any improvements that I could make.
Thanks!
public class DataAccess : IDisposable
{
...
5
votes
1answer
596 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 ...
