A database is any organized collection of data organized to provide efficient retrieval.

learn more… | top users | synonyms (1)

3
votes
1answer
42 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 ...
0
votes
2answers
39 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
42 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
74 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
17 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 ...
1
vote
1answer
31 views

Reducing the time of 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
50 views

Django query filter on count in one to many relation

I have the following models: ...
0
votes
1answer
30 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
73 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
47 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
69 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
106 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 ...
2
votes
0answers
44 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
102 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
31 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
79 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 ...
27
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 ...
1
vote
1answer
41 views

Fetch data from multiple tables

I have three primary tables: Customer Product Order Relations: Many to many between product and order. ...
3
votes
1answer
103 views

Returning an IEnumerable using Linq-to-SQL which is then bound to a GridView

This function works, but it's really really slow and the generated SQL is gargantuan and horrible to look at. It's also very expensive to run when it shouldn't be. ...
4
votes
0answers
51 views

Seeding a database

I'm seeding my database with really complex code as I think. It works but is not good. Constrains: Every meal has exactly ONE main dish (marked as is_main in ...
6
votes
2answers
172 views

Saving and Loading data with SQLite

I'm in the process of learning SQLite in C# and I've come up with some generic methods for finding and updating data. I would appreciate any pointers with the design of my methods and/or my SQL ...
6
votes
2answers
642 views

Simple customer program in C (using binary files)

I have just finished a simple C program which is basicaly composed of 3 functions: accadd(void){} which adds some customer details to a binary file ...
3
votes
1answer
42 views

Database trigger to monitor insert/update events and update another table

I am working on a MSSQL Database (for a program called Sage 200). There are many tables in the database, however, I want to be notified of changes (new record inserted or existing record updated) via ...
4
votes
1answer
43 views

PDO connector class

I have created a DB connector class with PDO. Do I need to add, delete or edit anything in this code? ...
1
vote
0answers
38 views

Locate enteries to the nearest date selected

This code loops through a given range of dates and for every 5 minute iteration pulls up the last known records of the users in the database relative to that timestamp. I'm trying to find a way to ...
3
votes
1answer
59 views

Updates list in haskell to remove duplication

The task in question allows a user to re-rate a film such that only the latest rating from the user should remain in the database. Initially I solved this problem in a very basic manor? This was my ...
25
votes
5answers
3k views

Performance of a Foreach inside a Foreach iterating through a million records

I have two DataTables: dt: is populated from a CSV file with over 1.7 million rows dataStructure.Tables["AccountData"]: is ...
3
votes
3answers
67 views

Perl DBI insert of hash

How can this method that inserts a hashref into a database table be improved? It assumes that the columns of the database table are named identically to the fields in the hashref. The return value ...
3
votes
1answer
65 views

Simple Notification class that models database

I'm updating a website I made awhile ago from a functional design to an OOP design. There are still a lot of functions below this class that I haven't implemented yet but I'm getting to it (such as ...
0
votes
2answers
39 views

Database Connection and Query methods

I have my class DBFuntcions containing this 2 methods: The method for the connection to the database: ...
1
vote
2answers
94 views

Entity framework - code first data access

I'm looking for your opinions about ways to improve the access to data in my application. I develop web applications, using Entity Framework 6 code first, and Autofac for dependency injection. Before ...
1
vote
3answers
154 views

Make C# Unity Script database methods more re-usable and concise

I have a C# file, that makes some modifications on screen (changes the text on the user interface) but I have some doubts: How I can re-use the below methods to be more concise and reusable? How I ...
4
votes
3answers
130 views

Write data from database to a CSV file

I have a database containing a high amount of data. I want my app to filter and select only some of it, and save it into a CSV file or JSON. For the moment I have this method which takes the data ...
2
votes
1answer
40 views

MySQL Database Design for Easy Item Relationships and Meta Storage

I'm playing around with database designs to use for a new system. This system at its core revolves around various types of items (users, accounts, images), their meta (names, titles, file sizes), and ...
1
vote
1answer
27 views

Database schema for a products and bugs aggregator

As an exercise in learning, I'm creating a bugs/issues tracking and "aggregator" web application. A simple app consisting of products, issues, reviews and links related to it. The links will be urls ...
3
votes
1answer
124 views

C# class that handle MySQL db connection

I've built a class that handles all my connections to a MySql database. These are the function I use to create the connection(not really sure about the two dispose functions) : ...
4
votes
3answers
109 views

Amanda's Relationship Tips app, with scroll performance issues

I am having some major issues with scrolling in my active app "Amanda's Relationship Tips" Under the User Advice tab: I'm using the Parse Database as a backend to pull user data. This lag is ...
2
votes
1answer
135 views

PHP/MySQL - OOP database class

I use this database class in a CMS, just a project to learn OOP. Would like to have some review on how to improve it, what should I change, add, remove? ...
1
vote
1answer
80 views

Restricting types not related through inheritance without using instanceOf by creating own class hierarchy

Restricting types not related through inheritance without using instanceOf by creating own class hierarchy. It needs to interact with a key value data store, will ...
1
vote
0answers
29 views

Calculation of duration between two timestamps in different rows

In my sample data table below, all datatypes are varchar(255). ...
1
vote
1answer
46 views

Aggregating search results from multiple databases, in smaller work units

I have a large function that performs a search over a data set given a set of parameters. This function goes through multiple databases which all hold data that would comprise one final entry from the ...
1
vote
1answer
89 views

Many CRUD operations for a list of technicians' shifts

The following code snippet is causing me a performance problem in my application. The first 5 db queries are not high time consuming, the real problem lays on the foreach loop. I considered to use ...
4
votes
1answer
59 views

Database Session Class

I have made the decision to move the storing of session data from the filesystem to the database. Our application is growing at pace and we are having issues with the load balancer breaking the ...
7
votes
3answers
174 views

Swing UI for database-to-Excel tool

I'm just wondering what is the cleanest way you can write your GUI/Swing code? Right below is the code I have for my main frame. Could you guys let me know if it looks clean/understandable, and if ...
3
votes
0answers
45 views

Implementing a long-running entity lock

Requirement I have an entity named ImportData which can be processed once in order to extract data from a file fed to the application. I need to make sure that, ...
9
votes
1answer
92 views

Go database helper code

Today I've implemented a database helper in Go. I'm new in Go world so I just wanted someone with more experience to take a look and tell me what is good and especially, what is bad (and why, if ...
11
votes
1answer
52 views

Mysql homeowner database

I'm working on a project right now. I don't have much experience in MySQL, or database design, so I was hoping someone could review what I have now. This database must be able to track multiple home ...
2
votes
0answers
26 views

Minimizing database overhead by storing additional information to the users authentication-object (Spring Security)

I am using Spring Security in order to check if a logged in user is authenticated. However, after authentication, as some actual requests come in, I would like to minimize the number of database calls ...
3
votes
2answers
62 views

“Time till” program

I have created a program which works out days, hours, minutes, seconds and milliseconds until a date which the user inputs. Is it possible to shorten/make the output a little clearer? ...
8
votes
2answers
95 views

Code First approach, feeding the table

I have a database (PostgreSQL) from which I want to migrate some data to a MS SQL Server database. I decided to use a code first approach. The question is related to the proper way of feeding my new ...