A database is any organized collection of data organized to provide efficient retrieval.
2
votes
0answers
45 views
Updating a table when a process ends
I have the following piece of code. I would like to be able to combine my first big block if statement inside my while loop and clean up my usage of variables since I'm doing a lot of setting.
I've ...
-4
votes
0answers
12 views
Error on query of sql server [closed]
Hello I have an error on this query with sql server, how can I sum the Quantita of items with the same Codart:
...
3
votes
2answers
191 views
Simple class to access MySQL database
I have written this simple DBHelper class to access a MySQL database. I am rethrowing a more generic exception so that the client side can take some action like ...
2
votes
1answer
31 views
-1
votes
0answers
45 views
SQL generates a dynamic table as an input for a Kendo UI table
I'm just registered to codereview.stackexchange. Please provide some feedback on this code.
I have a backend (ASP + SQL) and frontend Kendo UI. This SQL provides data to WebMethod.
Decided to ...
3
votes
0answers
40 views
Firebase many to many relationship structure
I'm trying to create a logical and scalable many to many relationship data structure in Firebase. A user can authenticate with Facebook/Google, upload 3 photos, and a video. Users can also "star" ...
4
votes
3answers
86 views
1
vote
0answers
19 views
Inserting large datasets into SQLite db becomes very slow over time
I'm using the program below to insert values from very large .csv files (~2.5 million lines) into an SQLite DB. It starts very fast, but begins to slow over time, before eventually hanging ...
4
votes
2answers
64 views
PDO Insert Method
I'm currently creating a class that will have a bunch of my most common database functions. This is the first method I've made, I would appreciate any feedback, thanks!
...
7
votes
1answer
76 views
Reduce amount of calls to database for authentication
I'm currently having a bit of code, which I just know can be improved a lot. I am just blind to it. All of my code looks quite neat to me, except these parts... The login + authentication process is ...
4
votes
2answers
112 views
Keeping bank account records using a struct
Can you just shoot me some ideas on how to better structure the program and also if you notice any big no-nos at first glance? This is certainly not production code, it is my first attempt at a data ...
3
votes
1answer
39 views
Inventory of objects with item types and quantities
I am thinking about how an inventory could be designed. The requirements for this inventory will be the following:
There will be predefined item types in the inventory.
The user can define new item ...
3
votes
2answers
87 views
Build a pizza and choose your toppings
I've created a scenario below, in which a user can build a pizza and choose their toppings, then order their pizza:
...
2
votes
1answer
104 views
List<List<string>> vs DataTable
I have an application which uses SQLite. In that database I have several tables that I need to be able to read and update in my application. Often I need to 'cross-reference' these tables to get the ...
1
vote
0answers
88 views
Email thousands of customers from a PHP form using a MySQLi query on a MySQL database
How can a large internet service provider email certain customers to warn them about an impending service interruption? I'm providing what I think is a reasonable solution, but I have not tested it. ...
4
votes
0answers
76 views
C++11 Command Line Address Book
A friend is doing a CS course that has a command line address book as
a term assignment. Although I am a programmer in industry, I don't do
a lot of C++, so I ended up doing this as a learning ...
3
votes
2answers
68 views
Loading items from XML document
I'm making a game in Unity and I need to have a inventory/item system, I decided to store my items in simple XML document which I later read from. I'm planning to have different varieties of items and ...
5
votes
1answer
73 views
Civil status database with Django
I'm beginning with Django and I have a Civil Status project.
I created my first models.py in order to get a Form, but I had some advices in order to normalize my database.
I made this process and I ...
3
votes
2answers
49 views
Read in file, and then compute class mean, median, max, min, class averages & update file
The application is designed to read in class results of individual students from a single text file, and then manipulate the data to give information such as class mean, median, max, min, individual ...
6
votes
1answer
119 views
Car leasing system - add lease to database
I just came back to programming and decided to create a car leasing system (GitHub page here.) to teach myself about databases, gui programming and web development. And I would like some input on what ...
1
vote
1answer
42 views
Database Dynamic Table Creation
The code below is meant to build an array with certain properties neccesairy to create column for a table in a database.
Would there be any more effcient way of doing this?
...
2
votes
1answer
36 views
Classical model for database connection provider
Let's forget about Spring Singleton Beans and about other frameworks in Java. We have one or more simple HttpServlets. And we should make database connection. (doesn't matter what is it, hibernate ...
2
votes
2answers
94 views
Repository searching code duplication
A followup question to this: IQueryable Extensions working on expression for collection property
I am working on a project for a family member which involves the use of a database and a repository, ...
3
votes
1answer
95 views
Text-based menu to manipulate a database text file
I am making a program that lets a user manipulate a database (a text file).
In the code I am posting, I show only 2 of the menu choices, namely "createdb" and "deletedb", and a few functions I made ...
5
votes
1answer
21 views
Interpreting database values as times and integers
I am working through Chapter 10 of Haskell Programming from First Principles.
I've gotten the code to work, but I am uneasy about the fact that a few of my functions - namely, ...
2
votes
0answers
21 views
Google App Engine - Blog Post & User Profile Handler
I am currently developing a web app that lets users submit posts and replies, and they can have their own profile which lists all the submitted posts and replies. I am also using X-AppEngine to fetch ...
0
votes
0answers
32 views
Generating Django fixtures from .csv
I've written this script to create a Django .json fixture starting from a .csv.
The .csv must have 'model' and 'pk' fields. What do you think?
...
-1
votes
2answers
40 views
Wrapper Connection PDO PHP [closed]
This is my wrapper, how can i improve this? (With a Singleton too)
...
3
votes
1answer
209 views
Storing database references to files/media
This is an extension of this question due to it not covering an important role of my setup that I think needs more attention.
The files are stored on a different server for separation and convenience....
5
votes
2answers
50 views
A telephone book command line program in ANSI C - follow-up 2
(See the previous iteration.)
What does this program do?
This program gives you a command line interface for managing your personal telephone book. The program supports three actions:
Adding a ...
1
vote
1answer
48 views
Java HikariCP classes
I'm currently making a server in Java, as database stuff I'm using HikariCP (because AFAIK, it's the best library). I try to do it as good as possible so I hope some of you can review my classes.
...
3
votes
2answers
120 views
Fetching records, optionally including deleted records
I have an original method that almost does what I want (a method I did not create), but now I need to find records that were deleted so I added another method ...
7
votes
4answers
821 views
Inserting a DBNull value into a database
I have code which works pretty well. I just need some of your opinions on how to write it better with fewer line of code. I want to use a ternary operator but I couldn't make it work so I did an ...
0
votes
1answer
113 views
JDBC helper model
I needed to create a basic JDBC helper class for our JDBC connection and wanted to know if my design is appropriate or needs cleans up?
Just a basic JDBC utility class which helps reduce the ...
1
vote
1answer
48 views
A telephone book command line program in ANSI C - follow-up
(See the next iteration.)
This question is a slight improvement over A telephone book command line program in ANSI C
I have incorporated almost all points stated by Toby Speight.
Now I have this:
...
4
votes
1answer
69 views
A telephone book command line program in ANSI C
(See the next iteration.)
Introduction
I was in the mood for some C code and wrote this program for handling a personal telephone record book. One of the goals is strict portability; the code ...
6
votes
0answers
92 views
Harry Potter's Family Tree Database
As an assignment for a class, I have made a small Harry Potter family tree in Prolog. It compiles into a self-contained executable that can be run straight from the command line on Linux machines. ...
10
votes
1answer
201 views
Room Booking System
I wrote a simple room booking system to get to know more about C++ and OOP. It simply stores rooms/labs/lecture halls with name, position, doors and possibly more details and can be booked/unbooked. ...
2
votes
2answers
373 views
Simple PDO database class in PHP
I'm writing a simple database class so I could use it in my future projects. It is based on some Codeigniter database methods, but my implementation, so if you could review this, that would be cool. ...
0
votes
0answers
39 views
Lazily load permissions from database in multithreading environment
I would like to get the feedback about this code:
...
1
vote
1answer
111 views
Finding mongodb records in batches using mongoid
I want to get records in batches. But mongoid doc says to avoid using skip due as it can be expensive. I wrote this method to iterate through a large number records efficiently.
...
4
votes
0answers
62 views
Script to make file hashes and track changes
I'm fairly new to python and decided to build something useful (I believe). So I made this script to track changes in user's files with DB with ability to "Accept changes", so end-user might track ...
1
vote
1answer
25 views
Attendance tracker design MySQL [closed]
The task is to create a website which allows the admin to create classes, students and teachers. He/She should be able to assign students to classes and one teacher. The admin should also be able to ...
0
votes
1answer
42 views
Admin and Client “is a” user
First of all, I'd want to represent, in my application, two different users (admin and client) which can access to two different classes, through two different graphic interfaces...
My idea is to ...
7
votes
1answer
126 views
Database abstraction layer for multiple providers
There's been a lot of questions lately about database provider and repository design especially without entity framework or alike.
I thought I try myself to create a reusable framework for this kind ...
3
votes
2answers
298 views
Model design for Online Food order app
I have been trying to develop online food order application. I have taken the concept of zomato.com where a user or say owner registers his/her restaurant. After adding the restaurant, an executive ...
2
votes
1answer
65 views
SQLite database for a micro/tumble blog application
I'm creating a personal website where, among other things, there is a blog, or a "microblog" (I'm still not sure how to define the two), where I will be writing articles and having users, who will ...
1
vote
1answer
73 views
Obtain values from SQL
I have a simple app which is checking occurrences of values. If there is already occurrences which I am looking for, it display that. If not, it adds.
...
1
vote
0answers
31 views
Cameleonica: key value store
This code is part of project Cameleonica. It is a key value store, a simple nosql file based database. This code requires an atomic ordered filesystem which means ...
0
votes
2answers
55 views
