A database is any organized collection of data organized to provide efficient retrieval.
5
votes
1answer
76 views
Truncating long strings when saving inventory items to database
To test incoming data for string values that are too large for the "database" (MS Access), I could do this:
...
3
votes
1answer
1k views
Basic Java database
I just wrote my first Java database program for the purpose of getting feedback on the implementation and coding. It has 1 table and 2 buttons and prompts the user to select a folder, lists the ...
-2
votes
0answers
12 views
How to yearly upgrade students in new grades/classes in school management system [on hold]
I'm sorry if this question is inappropriate. if it doesn't fit here kindly give me specific link where i can get a solution or please answer here!
I've been through many solutions on this site but i'm ...
3
votes
2answers
324 views
Importing MySQL Database to a .txt File
We just finished working on a Database project in Java Netbeans. We added the feature Import which will import the database record of one user to a text file.
...
7
votes
3answers
729 views
Java and MySQL connection classes and method implementations
I got three classes for MySQL Database access/manipulation:
Conector. It has got methods for connecting, disconnecting, querying and updating db.
...
2
votes
1answer
90 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
2answers
36 views
Query using cross join or inner join
Please consider the following three tables that I am playing with in the image below:
I want to come up with a SQL Query which shows first_name, last_name, and the total amount of all orders for ...
-2
votes
0answers
30 views
Table Design For Patterned Data For Variable Bucket Ranges [migrated]
Looking for table design for this scenario to be implemented on SQL Server 2012 instance.
Scenario
There are a total of seven types of reported data, each with variable number buckets of ...
1
vote
1answer
53 views
Performance shifting for SQL Database and Linq memory grouping
I am messing around with shifting between stored procedures and business layer EF getting data rapidly then processing in memory.
This works and on a static data range of 3 months I get execution ...
6
votes
2answers
71 views
Database access concept
I've got a small tomcat web application that's used to receive customer data from an iPad app. After receiving those information they will be saved on a local MySQL database and then sent to an SAP ...
3
votes
1answer
483 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 ...
0
votes
0answers
21 views
CRUD (database layer) for F# with TypeProviders
I am a newbie in F# and I am thinking about use F# in my next project. The project will work the database and I need to store and retrieve instances of objects in the Db.
Could you please check my ...
1
vote
0answers
7 views
1
vote
0answers
45 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:
...
2
votes
2answers
151 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 ...
5
votes
3answers
85 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
51 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 ...
15
votes
1answer
194 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 ...
0
votes
1answer
57 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 ...
2
votes
0answers
70 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 ...
4
votes
1answer
103 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 ...
1
vote
2answers
132 views
Database abstraction class
The class does some database abstraction operations. And while I could have just used an ORM, I prefer to get my hands dirty when learning something new. There are no bugs (not as far as I know ...
-1
votes
1answer
55 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
How do I optimize this MongoDB query
Here is the query in the Rails console:
...
3
votes
2answers
51 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 ...
10
votes
1answer
8k views
Storing a ByteBuffer into a Cassandra database
I have a couple of fields which I am trying to put together into a single ByteBuffer before storing it in a Cassandra database.
That byte array which I will be ...
2
votes
1answer
84 views
Inserting data into column family
I have started working with Cassandra database recently and I was trying to insert some data into one of my column family that I have created. Below is the code by which I am trying to insert into ...
3
votes
0answers
42 views
Rails models for Users, Offers, Comments, Documents, and Reviews
I want to simplify my Rails models, current looks like this:
...
2
votes
1answer
129 views
Neo4J Rest Javascript wrapper
As a toy project, I started evaluating the Neo4J graph database and its Rest interface. I'm trying to write a simple graph visualization in JavaScript. In daily business I'm a Java developer and maybe ...
2
votes
1answer
105 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
0answers
20 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
150 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
42 views
Creating keyword records in a database
This code is part of a data model used to create keyword records in a database.
...
5
votes
1answer
178 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 ...
1
vote
2answers
412 views
Using a dependency container to load a parent/child 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.
I used ...
10
votes
1answer
138 views
Labor percentage and wages from clock in/out and sales records
I'm developing a PHP function for calculating labor percentage (labor cost/sales) accounting for daily and weekly overtime rules, if applicable, based on the payroll period; the wages for each ...
1
vote
3answers
242 views
Realizing a SQL ResultSet into a Map in Scala
I am trying to realize a java.sql.ResultSet into a map, in Scala.
...
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?
...
1
vote
0answers
56 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?
...
3
votes
3answers
100 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:
...
1
vote
0answers
49 views
OOP QueryHandler in PHP
I have a simple database connection class which is using PDO:
...
2
votes
1answer
240 views
Adding new methods to GenericDataAccess
I have this GenericDataAccess class to interact with database from my school. I want to ask for some suggestions and advice in how to to improve it and add new ...
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 ...
2
votes
2answers
149 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 ...
23
votes
1answer
32k 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 ...
2
votes
1answer
71 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 ...
4
votes
1answer
180 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 ...
24
votes
6answers
3k views
Database design for a school system
This system has to manage students, teachers, staff and grading. This is for production and is not a school assignment. As such, please let me know if I can improve on any aspect. :)
My main concern ...
