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

learn more… | top users | synonyms (1)

2
votes
0answers
44 views

Database Query Optimization

I made a website where is possible to search for the best transportation from a place to another. For instance, i need to go from Berlin to Bremen? the website will search in its internal database for ...
3
votes
0answers
21 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
63 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
37 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
20 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
72 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
35 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
89 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
23 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
66 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
43 views

A simple User class

...
4
votes
1answer
49 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
43 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
57 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
80 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
27 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
48 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
97 views

Django query filter on count in one to many relation

I have the following models: ...
1
vote
2answers
35 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
152 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
85 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
111 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)...
2
votes
0answers
47 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
105 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
82 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 ...
1
vote
1answer
43 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
124 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. ...
6
votes
1answer
73 views

Seeding a database

I'm seeding my database with a relatively complex data model. Constraints: Every meal has exactly one main dish (marked as is_main in intermediate table). Here is ...
6
votes
2answers
194 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 syntax....
6
votes
2answers
651 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
72 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
50 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
39 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
60 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 ...
26
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
79 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
98 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
40 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
104 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
170 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
143 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
45 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
29 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
168 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
113 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
170 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
86 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 ...