A database is any organized collection of data organized to provide efficient retrieval.
-4
votes
0answers
12 views
Cannot generate right url link asp.net [on hold]
i´m trying to make download button( or somethink like that) and download attachment which path its saved in database. But there´s problem, i have finished saving, but i cannot still download that file....
0
votes
1answer
53 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
32 views
A telephone book command line program in ANSI C - follow-up
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:
telephone_book.h
...
4
votes
1answer
54 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
57 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
85 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
1answer
56 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
36 views
Lazily load permissions from database in multithreading environment
I would like to get the feedback about this code:
...
0
votes
1answer
37 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
50 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
23 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
41 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
82 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
122 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
48 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
62 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
21 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
53 views
3
votes
1answer
49 views
Rails UserHelper method
I need help cleaning up this monstrosity. Basically this is a user helper method that generates an array of cumulative user sign ups per week (start of week == Wednesday) starting 2016-06-15.
So ...
1
vote
2answers
140 views
CRUD code for a finance WebForm
I have a finance web-application in ASP.NET WebForms using Telerik RAD controls. Two event handlers wound up being very similar in implementation.
What steps could I take to improve the organization ...
2
votes
0answers
61 views
REST web service to interface with a customer database
In what ways could I improve this? Does it look good? Any security concerns? I am using Jersey, Jackson and JPA. What about the architecture? I basically have ...
1
vote
3answers
64 views
Three PHP database queries to manage accounts
I have a database connection PHP file which has a lot of queries to the database. Here are 3 of the functions that I am using:
...
2
votes
0answers
71 views
Query for searching for the best transportation
I made a website where is possible to search for the best transportation from a place to another. For instance, if I need to go from Berlin to Bremen, the website will search in its internal database ...
3
votes
1answer
33 views
Split cells vertically on comma MS Access 2010 VBA Module
This takes a field delimited by commas, and splits on the comma. The newly divided information is put in another field (created at the start of the program) called ...
8
votes
1answer
67 views
Extract data from a DBMS, create a CSV dump and transfer it to an FTP server
First of all, my code does work as expected at least to some extent. The intention of the program is to extract data from a DBMS in order to create a CSV dump and transfer it to an FTP server.
My two ...
3
votes
1answer
49 views
Database design for users' postcards
I would like to a review of my database design.
There are 3 tables + ASP.NET Identity tables.
The Users could have many postcards.
Here's my tables without Identity.
I attached also my scripts ...
1
vote
0answers
22 views
Database schema for factory application
I am creating an application to manage the assembly of shoes through a web application.
Could you tell me that you think that is more or you would be missing to be as solid and complete as possible, ...
2
votes
2answers
96 views
Setting up a database class
I am wondering the best way to setup a database class, to remove repeat code by using OOP. This way if I changed how I connect to the database (switch from PDO to sqlsrv driver) I can just change it ...
4
votes
2answers
67 views
Invoicing Program Python
This is my invoicing program I made for myself to keep track of purchases people made from me. (Yes I know eBay does this for me but I wanted to see what I could make.) Basically it can search the ...
4
votes
2answers
92 views
DB-to-Java value mapper
In my company, I've inherited some Java library that I'm now writing tests to, refactoring and fixing Sonar issues.
One particular point that Sonar is complaining about is a big chaining of ...
0
votes
0answers
32 views
Retrieve YouTube user's subscriptions and store them in database
I've written this small algorithm and I'm not really proud of it.
...
4
votes
1answer
70 views
Two Python classes to update an RRD database
The first Python class below is used in one of my current projects and is a totally different approach to how I normally would take things. Before I refactored the class I was not declaring instance-...
0
votes
0answers
51 views
4
votes
1answer
50 views
Two variants of a picture database initialization routine
I wonder which of the two snippets is better? In the second one, I extracted two short subroutines.
On the one hand, extraction clearly separate the two tasks
On the other hand, it induces 6 more ...
1
vote
2answers
45 views
Two variants of a db_create_ressources(…) function
After reading noobs, I'm interested in possible way to improve readability of the following short snippet.
a struct pictdb_file is a small file system containing ...
6
votes
2answers
86 views
Database design for a transportation company
I am designing a database and I am just wondering if I am doing it correctly. I have tables for things like State with all the states in them and then I reference the ID in other tables. But should I ...
3
votes
2answers
87 views
Unit test for a method that adds tweets to a database
I have a class which inserts a list of tweets to a database table and also inserts the tweet's key with the associated filter's key to a many-to-many table. I am testing the sole public method of this ...
0
votes
0answers
41 views
Performance of PDO-Query Class
to reduce repeating multi-liners I've written a class for my PDO-Querys.
But as I used this in my project (a Webcrawler), I sometimes get the ...
2
votes
1answer
82 views
Update and sum query C# Access DB
I have a simple query using query builder of VS2012 C# which updates the database in my winforms application. The database has 216 entries so far and it's taking a lifetime to update the database. How ...
-1
votes
1answer
205 views
1
vote
2answers
39 views
Rails create create default database records
In my application I have an accounts model:
class Account < ActiveRecord::Base
belongs_to :user
has_many :invoices
end
The ...
2
votes
2answers
637 views
Simple singleton database connection pool
I'm studying design patterns, and to demonstrate a singleton, I've implemented a primitive database connection pool.
ConnectionPool.java
...
3
votes
0answers
52 views
Fantasy league tracker for Game of Thrones
So I've just started learning about MySQL and PHP to create a fantasy league tracker for Game of Thrones for my office. I got it to technically work fine, but I think it's way clunkier than it has to ...
0
votes
1answer
104 views
Web API with IoC and database integration tests [closed]
I've made integration tests for a major part of my application. I test my dependency injection is set up correctly, creating controllers with it's dependencies going all the way to the database (using ...
2
votes
1answer
119 views
Loading data from a text file into the database as fast as possible
I'm building a Django (1.8.12) application that parses a .bc3 file (Standard Interchange Format for Databases of Construction and Real State) and loads all the data into the database (PostgreSQL 9.3.9)...
4
votes
1answer
76 views
First time using entity framework with simple repository
I'm working on updating a GitHub project that I use at work, but I think the person abandoned the project as there is a pull request for it since 2014. At work we use a Repository pattern with ...
4
votes
2answers
118 views
Check existence of a row then update a column
not too experienced with SQL, wondering if I can make this better... I am trying to check if a row exists and then add one to the frequency column if it does, if it does not exist it should return ...
1
vote
0answers
32 views
Calculate normal forms in a database
Here I calculate normal forms. To begin, I check if there something on the right side of my dependencies; if so, I save it. Then I create a powerset of all possible keys and delete those which do no ...
0
votes
1answer
91 views
Query Builder for Mysql Extension
source : https://github.com/Zakisu/QB_Mysql/blob/master/mysql/Mysql.php
please review mycode
read the docs about the usage
...
29
votes
5answers
3k views
Event scheduler in C
One of my university assignments asked us to create a program using struct in order to create a simple event scheduler. This program is for a single day only, not ...
