A database is any organized collection of data organized to provide efficient retrieval.
1
vote
0answers
20 views
Create and access database connection
I'm working on an MVC project and I'm writing the code for get access to the database connection.
I have two files:
The first (PdodbLib.class.php) extends PDO:
...
5
votes
3answers
66 views
SQL database design for ecommerce
I need to create a database which stores details products, Manufactures,Suppliers. So initially I divided Products into categories and subcategories.
These are the tables I created.
...
2
votes
1answer
44 views
Checking for duplicate values in database with Python
I'm working on a Python application where I read and extract data from an HTML file. The data is stored in a list, and the number of items in a list is, on average, 50,000+.
The items from the list ...
0
votes
1answer
51 views
Queue like system to check existence of email
I have a table in my database containing email and email_state amongst other values.
Email is the email of the contact, and ...
-1
votes
1answer
47 views
Reducing database access time and connection count [closed]
I have 2 connections. How can I reduce this to one connection?
...
0
votes
0answers
9 views
4
votes
1answer
92 views
Lazy Load for multiple entities at a time
We have a system with a non standard database solution. All trips to the DB are rather expensive. We cannot use entity framework.
Currently our lazy loading is on an entity by entity basis. So if I ...
15
votes
1answer
185 views
Modeling a Mage character from nWoD, using Django
Goal
Design a representation of a mage character from the World of Darkness RPG, as well their associated spells.
Here is a visual representation of the schema. You can see it more closely ...
3
votes
2answers
31 views
Create SQLite backups
I have this script for creating SQLite backups, and I was wondering whether you'd have any suggestions on how to improve this. I was thinking that maybe it should create the backup ...
3
votes
0answers
38 views
Rails models for Users, Offers, Comments, Documents, and Reviews
I want to simplify my Rails models, current looks like this:
...
2
votes
0answers
18 views
Auto-expire key/value database (with different key types) in Haskell using acid-state
I am making a key-value database using acid-state. It has three similar "pools", one for cookie records, one for email verification of new accounts, and the last for resetting passwords.
There are ...
5
votes
0answers
141 views
Database abstraction layer for PHP web application
I'm working on a PHP based web application.
While building the UserStorage class, (which acts as a storage source for user data, and implements the ...
2
votes
1answer
68 views
Optimizing for data import in Neo4j using py2neo
Here is my code for importing from a .csv to a neo4j graph using py2neo and cypher statements. I've noticed that it slows down significantly the bigger the graph gets. It takes several seconds just to ...
2
votes
1answer
42 views
Creating keyword records in a database
This code is part of a data model used to create keyword records in a database.
...
1
vote
0answers
51 views
How common is the use of closure in Lisp?
I'm writing a little tool for mangling MP3 collections and, as a challenge, I decided to write in in Hy, a dialect of Python that uses Lisp syntax. Like every good developer, I wrote out my list of ...
1
vote
0answers
17 views
Bitcoin, detecting deposits to the node.js server
I'm trying to detect deposits that user will made. I explained it with comment lines in below.
Can you say are there any flaw in it?
...
7
votes
1answer
87 views
Summing the prices from Transaction files
I need to cut down the run time of this query. Currently it's taking 45 minutes. Is there something I can change in the table or the query to allow this to run faster?
...
1
vote
0answers
49 views
2
votes
2answers
121 views
Small PHP DAO app
I'm creating a small app and decided to write my own DAO for learning, etc.
At the moment it's in one big file, which I really don't like. Could you give me some tips on how:
you would separate ...
3
votes
3answers
99 views
Cancelling an order with a side-effect of logging the operation
I have a data access layer method to cancel an order. This operation should have an associated "operation history" entry.
My first (naïve) implementation looks like this:
...
5
votes
1answer
62 views
TrackDAO: what can be improved?
In this specific situation there is a table with trackdata and a form to add rows. For the sake of clarity I won't include the view-related code here. The added rows are added to a LinkedList when ...
1
vote
0answers
67 views
Django Model field naming convention for lookup tables
I'm currently in the process of refactoring a Django app to use Django REST Framework. Within the existing code there are 15 models for lookup tables. The structure of each model is as follows (using ...
0
votes
2answers
71 views
1
vote
2answers
45 views
Looking up the name and event for a ticket
This code is from my Kohana project. How can I make it more beautiful? Should I use try-catch instead? How could I avoid writing exit() twice?
...
4
votes
1answer
129 views
Dapper helper service
I've written a very light wrapper around Dapper to help with unit testing and streamlining the Dapper commands I need.
Execute() is a method created to remove the ...
0
votes
2answers
394 views
Connecting to a MySQL database with C#
Can anyone help me with checking this code? It is for connecting to a database. The method getFromDatabase is to take values from the database and put it to a ...
2
votes
1answer
110 views
PDO PHP DB Class
I've been building a PDO PHP DB class and I just wonder if someone could give me some feedback (regarding security, how the code is written and how I can optimize it).
This class is not finished ...
2
votes
2answers
131 views
Database assignment with MySQL and Swing
I have completed this assignment from Stanford CS108 on MySQL and Swing (it's part B). It would be wonderful if someone could point out my weak spots in the code and overall design.
I have uploaded ...
0
votes
1answer
91 views
Data Access Layer and Business Objects
This is my first cut at separating the data access layer out of my very old spaghetti codebase.
I have tried to keep this as simple as possible, it is for a small project, so I am not really ...
1
vote
2answers
241 views
School Library Management System
I require feedback on the plethora of bad practices that are definitely existing in the following code:
...
5
votes
3answers
122 views
0
votes
1answer
35 views
1
vote
0answers
22 views
Structuring my MongoDB application documents
I'm just starting out on an application and I've heard some good things about MongoDB so I thought I'd give it a crack in this new project to see how well it works.
Please bear in mind that prior to ...
1
vote
0answers
173 views
Real-time bitcoin data feed and storage using websocket framework
I'm trying to create data feed script for real time bitcoin data for OkCoin exchange using their websocket API (documentation) and a database manager for storing. There are two channels i am ...
5
votes
2answers
47 views
Out of one Oracle into another
A project that I have been working on required data to be transferred from an Oracle database into MySQL. The process I devised for that transfer involved a query (included below) on the Oracle ...
10
votes
3answers
341 views
Trading Card Game database schema for statistics
This database schema will be used in conjunction with various systems as related to an online Trading Card Game, mostly for permanent storage and statistics. Some example cases would include:
JDBC ...
4
votes
1answer
99 views
PHP MySQL Database class
This is a PHP database class. Yes, I know it's using the MySQL functions, which are deprecated, but I shall be updating it to MySQLi soon. Can you please review this code and give any comment on any ...
2
votes
0answers
62 views
Structure of database model for a Flask project
I'm working on a project with Flask and I'm trying to follow Miguel Grinberg's Flask tutorial as closely as possible while creating what I need for my own project.
Overall, how does it look? Miguel's ...
-2
votes
1answer
114 views
SQL table: store “status” as integer vs as string [closed]
I've been around a bunch of projects where statuses are stored in the db as a integer, then mapped in the model back to a human readable string:
...
3
votes
2answers
168 views
Using Custom Attributes to Populate Members from IDataReader
Just learned how to use custom attributes in C# and the first useful thing I did with it was to make a class object representing a database table. The constructor can accept an ...
2
votes
2answers
179 views
Simple Database Abstraction Layer
I'm learning PHP and currently object-oriented programming. I would like to get a feedback; how I'm doing so far. If I have bad coding that should be fixed immediately etc. I'd call this code an ...
2
votes
1answer
84 views
Observable storage - revised
Previous question:
JavascriptObservable Storage
The idea is to have some storage interface that exists of different buckets - known as Eagles:
...
2
votes
1answer
61 views
Sharing a database connection with multiple modules
I am building what essentially could be viewed as a glorified database wrapper as a Python package, where I'm having several classes and functions spread out into different modules. My current problem ...
1
vote
3answers
198 views
Realizing a SQL ResultSet into a Map in Scala
I am trying to realize a java.sql.ResultSet into a map, in Scala.
...
10
votes
5answers
2k views
Singleton Database class
Currently my team is building an application involving a database. We have to write a lot of data (approx 2,000,000 records) to the database and therefore we decided to open a connection once and ...
5
votes
1answer
162 views
Core Data model for test-taking iOS app
I'm building an iOS app for test-taking and I want to be sure of my model before proceeding.
I found this post very helpful and tried to implement a simplified version for Core Data.
Here are some ...
6
votes
1answer
115 views
Deleting a user from a database
I was hoping if anyone could tell me if I'm doing this correctly, I know there are other questions like this but everyone codes different and I just feel that I'm not doing this right. I'm trying to ...
4
votes
1answer
134 views
High school social network query for friends in common
This is sourced from the Stanford Coursera self study DB class SQL quizzes:
Students at your hometown high school have decided to organize their
social network using databases. So far, they have ...
2
votes
2answers
313 views
Having a class return a single database instance or list of all database instances
I'd like the following to happen:
...
3
votes
1answer
106 views
Managing “Jobs” data in a Database
I've been working in a small page with some easy CRUD.
The data I get from the database is getting shown on the page.
But the way how i show the data feels a bit off. I guess it can be done in a much ...
