This tag is for general database questions; if you question is specific to SQL use that tag instead.
-2
votes
1answer
26 views
Multiple sql db logins [on hold]
How can I alter code from this website :
http://www.wikihow.com/Create-a-Secure-Login-Script-in-PHP-and-MySQL
To allow a user to access multiple databases simultaneously?
Right now I have it ...
-1
votes
0answers
41 views
Store documents in the database !? why or why not? [on hold]
Just ad an argument with my DB administrator about storing documents in the database vs in folders.
Why should we store document in the database !?
When should we do it !?
thanks
0
votes
1answer
42 views
Design caching system
I am thinking about making my own caching system, mainly for C#, but this is more a design question, so the language doesn't really matter.
Let me start at the beginning, I have a basic web api, ...
2
votes
1answer
35 views
Multitenancy and nested set trees
The application I work on utilizes nested sets1 to represent tree structures within our database.
We need to expand a particular area of access control to support multiple clients who should not be ...
-2
votes
0answers
27 views
How to perform Edit and delete operation on Webgrid without using EF and javascript? [on hold]
The question is explained in details here i want to perform edit and delete operation on webgrid without using Entity framework or javascript in mvc4 i am using LinqtoSql, i want to do it as we use ...
0
votes
0answers
15 views
Any way to use VoltDB in rails app?
I've been curiously looking at VoltDB and one year ago I have even seen a gem that was providing Ruby connection to VoltDB. I have checked today again and it seems gone.
I'm planning to go through ...
-1
votes
3answers
113 views
How can I set up a MySQL database in the cloud? [on hold]
I've been coding for 6 months and I'm about to get my first website on air. I already know how to connect to my MySQL database on my localhost, but how can I do that in the cloud?
Do I have to create ...
-2
votes
0answers
41 views
what is a good Software architecture and design for a mobile agriculture application for 2G phones [on hold]
This is my first time here. I currently doing a project which is a mobile application that runs on 2G phones for smallholder farmers in africa which is meant to provide market information services, ...
0
votes
1answer
32 views
Like structure table with Laravel and showing the most popular content at top
I am using Laravel to creating a website, my users can post questions and other users can write their comments under the post, each comment have Up vote and Down vote, and users can voting for ...
-2
votes
0answers
23 views
Beginning Creation of Mobile Workorder App [closed]
I have the idea to build a mobile workorder app, that will basically allow selection from a customer list, be able to add items(and associate them with that customer), and automatically create a form ...
3
votes
2answers
63 views
Should log/data files be stored in the database? [duplicate]
I'm working on a project where we produce lots of data in the form of simple .txt files. These usually contain a set of columns that will later be loaded in to Matlab to be analysed. I've implemented ...
0
votes
2answers
58 views
Web API alternatives to save a file to server's file system
We have a SQL Server 2012 Enterprise edition and an ASP.NET Web API 2.2 web service. The web API is the public interface for the database.
We need to end a production order doing:
Changing a value ...
1
vote
3answers
139 views
Is self referencing tables a good idea for geographical data?
I am creating a design for different Geographical types where each type is just a little "place holder" in over all heirarchy.
One example is
Zip code Belongs to Territory Belongs to District
...
3
votes
2answers
96 views
Best practice for uploading large file, previewing, and editing before saving to database?
I am allowing users to upload a relatively large .csv file (about 1MB) - it will contain thousands of records that each represent one of my business objects. I want the users to upload the file and ...
0
votes
0answers
16 views
Database integration of Rails and Laravel apps
I have some very small apps on a VPS running ruby on rails and a co-worker also have some of his own apps running on laravel at another VPS.
So far we dont needed to share any data among the apps, but ...
48
votes
6answers
5k views
Should Latin-1 be used over UTF-8 when it comes to database configuration?
We are using MySQL at the company I work for, and we build both client-facing and internal applications using Ruby on Rails.
When I started working here, I ran into a problem what I had never ...
0
votes
0answers
99 views
Is this a good implementation of the builder pattern?
I'm trying to design an SQL builder in PHP. I'm trying to make it so that the system could work with different database systems (e.g. Oracle, MySQL, MSSQL). Here's what I've got so far.
First, I have ...
-1
votes
0answers
21 views
Best way to get data from database inside Thread Class in Spring [migrated]
Currently i am troubling that how to get data from database inside my thread class.
I can't make bean of my thread class because new instance is created of thread on every request.
MyThread.class
...
1
vote
1answer
50 views
Trying to Move Logic to DB - Reservation System
So I'm planning a basic resource reservation system. Basically I'm going to have a room (resource) that has X number of open spots per 30 minute increment. When someone reserves a resource I would ...
11
votes
3answers
599 views
Should I keep email addresses as plaintext in database?
It's clear to everyone (I hope) that storing passwords without at least salting/hashing them is a terrible idea.
What about emails? Let's say you keep the subscription email address, if you encrypt ...
2
votes
1answer
84 views
How to design database tables for a Factory class?
How can I design database table structure for a class that varies in its core parameters, when it is created by a factory method?
I have a Factory like this:
class ProductFactory
{
public ...
0
votes
0answers
34 views
What could possibly be a Mysql database structure for an web app say like Flurry?
Simply say, I'm working on a web App say like Flurry (http://www.flurry.com/), that would communicate with a Smartphone App trough API.
Right now I'm designing the database structure, and I guess ...
2
votes
3answers
91 views
Is it an abuse of SOA to use it as a database abstraction layer?
I have a question whether it is a good or bad practice to use an SOA layer for the application servers to talk to the database. A web application server can obviously directly connect to a database, ...
2
votes
1answer
86 views
What should be the structure of a person to person store database?
I am going to create a person to person store with Laravel, a website where its users can share and sell their product or their mobile, TV, Computer, Shoes, Shirts, Books, Cars, Bags, Animal, etc.
I ...
-1
votes
0answers
29 views
How BeanPropertyRowMapper works internally in spring?
I know that BeanPropertyRowmapper use setter method when I fire select query but is it uses getter method too or not ?
I don't want to make my custom row mapper or hibernate or JPA.
I have face below ...
1
vote
3answers
126 views
How to choose DB and/or DBMS for own application? [closed]
I'm creating application in C++ and found out that storing information in XML file was very prodigally. Despite the possibility to read it without any specific application, random access via DOM or ...
0
votes
1answer
30 views
Large volume report operations, how best to replicate transactional data
We are overhauling a legacy accounting app that has some large reports. One concern that has been raised is due to the transactional nature of the data, if we start a long running report how do we ...
0
votes
1answer
51 views
Closed source proprietary web application with an AGPL source code in iframe or sub-domain [closed]
In a closed source proprietary web application, if I use an AGPL product in a sub-domain or in an iframe do I have to open-source my project?
If answer is no, is it possible that both applications ...
3
votes
2answers
165 views
Meaning of an “instance of a database”
From http://en.wikipedia.org/wiki/Extension_(semantics)#Computer_science
In computer science, some database textbooks use the term 'intension' to refer to the schema of a database, and 'extension' ...
0
votes
0answers
38 views
Minimizing database requests for moves of a chess game?
I'm writing a webapp for chess which, for a given move and a database of games, shows all the moves that follow from that move. Pretty much what this website has already done: ...
1
vote
1answer
37 views
RavenDb - Get data through a REST Web API
I would like to build a RESTful API where I need to get data from a RavenHQ-cloud-database. First of all, is this possible?
The idea is to have multiple applications (xamarin-app, mvc-app, etc.) and ...
0
votes
2answers
115 views
Saving to file before storing into a database in a REST service
A mobile back-end I am building should receive a larger amount of data (some sensor recordings) from an Android phone. The phone does not have much use of it so it was most efficient to store the data ...
3
votes
2answers
187 views
S3 image urls in database
I have an application where users will be able to upload multiple images for one Product (via something like Ryan Bates nested fields, so you'd click "Add Image", and a file upload would appear on the ...
1
vote
2answers
93 views
Users in SQL databases
I took up programming a couple of months ago (alongside my day job) and am struggling with a couple of basic concepts. Currently, I'm trying to learn how to build a database based PHP login/logout for ...
7
votes
2answers
184 views
How to efficiently store big time series data?
I need to store and to be able to query some very large amounts time series data.
Properties of the data are as follows:
number of series : around 12.000 (twelve thousand)
number of data points, ...
1
vote
4answers
120 views
Database design for objects with multiple states
Context
I'm designing a database which, simplified, should be able to handle users sending job requests to each other, and after that a job can be started, finished, and reviewed. The design should ...
4
votes
2answers
85 views
best way to attach database structure for an open source project
I have a small project which I want to publish on github. The problem is that my project contains a database. I don't know what is the best way to attach the database structure.
I may get the create ...
0
votes
1answer
39 views
Quickly write log entries from http requests in a MySQL database with high performance
When a dataset is saved in the software I use, a http request is triggered (fire-and-forget).
Information like the timestamp, the user and the changes made are listed in the GET parameters.
Now I ...
1
vote
1answer
149 views
Is this database design good? What JPA Entities should I create for this design?
I am trying my hands on JPA. For this I am thinking of using the example of a student admission process as shown in the diagram below.
Is this design good ?
Any suggestions for improvement are ...
0
votes
1answer
64 views
Database vs. server-sided scripting language [duplicate]
To keep my question short and to the point, consider this:
$relation = $mysql->query("SELECT relation($loggeduser, $requesteduser) AS a")->fetch_assoc()['a'];
if ($relation != BLOCKED)
{
...
1
vote
1answer
103 views
A very simple database system with JSON
If we need to store some data in a database, but without the need of advanced SQL features, can we use this scheme (written here in Javascript / node.js) :
// the DB will be in RAM !
var myDb = {};
...
1
vote
2answers
78 views
Retry method for generating unique code
In an app, a user can initiate the generation a six-digit alphanumeric code (actually done via Web API). The code needs to be checked against a remote database to ensure it is unique. Other than for ...
6
votes
1answer
219 views
Log to file or to database table?
I'm developing a web application which uses MS SQL for various data: including users, user accounts, user licenses, license prices, invoices.
I need to log users' real-time usage of the system, and ...
7
votes
3answers
196 views
How to model and store an entity which has “one or more” values
I'll use C# to design the model to be persisted
Let's suppose I have the following entity:
public class Episode {
public int Id { get; set; }
public string Title { get; set; }
public ...
1
vote
1answer
75 views
More than 20 Records Inserted in a Span of 1 Sec
Well, this is not specific to any programming languages. I came across this situation in Android, iOS, PHP and .NET.
The problem is many times I come across a situation while building IoT apps, where ...
0
votes
1answer
122 views
Dealing with several custom getters
I have a data structure with data units containing different types of data. I've wrapped the data in "Field" objects so that each field is able to independently parse user input in a desired way.
...
2
votes
1answer
155 views
Matching algorithms in context of data quality problems
I work for an organization that has lots of databases containing person information. The data quality is poor. One case was a surname I found like this (this is the worst-case scenario):
Mark ...
2
votes
3answers
133 views
Best approach for storing huge data
I'll be handling 300,000+ users. Each user (after logging in) will be able to create lets say "folders", in each folder, users will create "name=value,name2=value2,name3=value3" entry pairs. Each name ...
0
votes
1answer
173 views
Designing a scalable schema for college database [closed]
I am trying to build back end for college ERP system. The system will be based on LAMP.
These is the scenario:
Colleges have 5 branches
There are 4-6 classes in each branch.
There are 80 students ...
0
votes
1answer
29 views
online database with partial access for clients
I'm trying to come up with an online database that my clients would have partial access to. This is for an artwork storage company. We have about 40 clients and would like each to have access to their ...
