A database is any organized collection of data organized to provide efficient retrieval.
-2
votes
0answers
8 views
Saving a list of ids in database sql [on hold]
I am working on an App where client can shortlist a person.I am using flask framework with sqlalchemy.I have add a column where shortlisted person names are appended to the columns.
Here's the code ...
4
votes
2answers
24 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 ...
0
votes
0answers
17 views
Database to calculate Date/Time [on hold]
I'm trying to make a calculator to calculate the estimated delivery time for products from its producers, and since every producer has his own time cycles, I have to make a kind of database about them ...
-2
votes
0answers
26 views
Can I please get some feedback on my coding technique for object oriented php? [closed]
I'm looking at getting a job as a php developer. I have submitted tests, but not heard back from them. Can I please get some feedback on my coding technique for object oriented php?
Here is a test I ...
4
votes
2answers
82 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
20 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
62 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
41 views
3
votes
1answer
44 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
42 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
51 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
77 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
23 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
43 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
71 views
1
vote
2answers
34 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
103 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
51 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
77 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
110 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
46 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
103 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
80 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
118 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
72 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
179 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
650 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
60 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
49 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
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
75 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
85 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
100 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
162 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
137 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
44 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
147 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
111 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
157 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
85 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
47 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
91 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 ...
