This tag is for general database questions; if you question is specific to SQL use that tag instead.
2
votes
1answer
81 views
Integration testing and database connection string in app.config
I am working on a project where SqlConnection is created via a static method, lets say it's DatabaseAccess.GetSqlConnection(). This method reads the .config file to get the connection string and ...
1
vote
1answer
56 views
How to minimize database deadlocks in a load balanced web application?
I'm working on a web application hosted on multiple load-balanced web front ends (WFEs). This application has an API method that performs a database query and returns the results. This query only ...
1
vote
1answer
219 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 ...
1
vote
1answer
53 views
Proper tree NoSQL structure with focus on full-text searching
I developing an app with tree(folder-file) structure, on which I should perform full-text searches with MongoDB. I did a research on the best tree structure practices and found this great article, but ...
1
vote
1answer
140 views
Automatic denormalization for a NoSQL database application
We have a use case where we store table-like data, but we know about the schema of the data only at runtime. In our application, a power user defines a schema and normal user can create records and ...
0
votes
1answer
67 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 ...
0
votes
1answer
156 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.
...
0
votes
1answer
93 views
How to implement a Daily Recap email of Database records modified the previous day sent to Subscribed Users like Basecamp does?
I am building a Project Management module for SugarCRM. It consists of a "Project" which has information on the project like Name, description, start and completion dates,
creator name, status ...
0
votes
1answer
201 views
Spring JDBC Template without DAO?
I am rather new to writing applications that interact with databases, and I'm curious about a project I'm working on. I have to write a very simple web app which is going to be displaying metric data ...
0
votes
1answer
171 views
Geographically Distributed (Data & App) Architecture
Is there any design patterns (or best practices) for implementing a geographically distributed system (mostly a database)?
Description: There is a network of warehouses and a central office. Now I ...
-1
votes
1answer
105 views
Appending local MySQL data to same MySQL data in web server
my IT boss wanted this scenario to be undertaken: First, we develop an Alumni program using PHP and deploy this in the web server which can be accessed by that school alumni in the web to update their ...
-2
votes
1answer
2k views
Connecting a native iOS app to backend and database
I have a good amount of experience working with objective-C and making iOS apps that work locally and with BaaS providers (Parse.com). However, I'd like to take my mobile development to the next level ...
3
votes
0answers
56 views
When connecting to a server using the DRDA protocol, is it true that the first Client-To-Server command MUST be EXCSAT chained with ACCSEC?
When connecting to a server using the DRDA protocol, is it true that the first Client-To-Server command MUST be EXCSAT chained with ACCSEC?
I found 2 different answers when I googled it.
If you look ...
2
votes
0answers
143 views
Entity Framework Lookup Tables
I am coming from working with ADO.net DataSets and feel fairly comfortable with how they work. Mainly, I usually have a DATA table with a large number of REF tables for lookups.
In DataSets it was ...
2
votes
0answers
76 views
Three phase commit protocol
I'm trying to understand the three phase commit protocol by reading the wiki page (http://en.wikipedia.org/wiki/Three-phase_commit_protocol#Motivation). In the description for the diagram I posted ...
2
votes
0answers
116 views
Database version management on mobile apps
I am about to start building a mobile (iOS/Android) app that uses a local database (probably sqlite). Since this is my first "real" mobile app, I am wondering what the standard approaches are to ...
2
votes
0answers
99 views
What are some important considerations when developing a DBaaS (DataBase as a Service)
I'm interested in creating a Database as a Service.
I want users of the service to be able to do a few seemingly not very simple things.
Sign up and be given access to a JSON datastore that they can ...
2
votes
0answers
106 views
Would a model like this translate well to a document or graph database?
I'm trying to understand what types of models that I have traditionally persisted relationally would translate well to some kind of NoSQL database. Suppose I have a model with the following ...
2
votes
0answers
61 views
What are the benefits of having a remote database for your command line utility
I'm current working on a command line app that will grab resources online for you when you're setting up a new project locally. Right now all the urls for the resources I need are hardcoded into the ...
1
vote
0answers
12 views
How to use an Address Gazatteer in an application that contains addresses
Say I had access to the post office address file (http://en.wikipedia.org/wiki/Postcode_Address_File) and wanted to cleanse about one million addresses. I am trying to think of an "algorithm" to do ...
1
vote
0answers
23 views
Database data Bucketing Report Design
Here's the scenario:
I have item x (item_id, customer_number, cost) which can be submitted to another system multiple times over months which may or may not reject item x before finally accepting it ...
1
vote
0answers
14 views
how to store program actively processing info for remote monitoring? Database?
So I have a program that processes a bunch of files.
File in, start processing, file finished, next file.
The question is, now I want to be able to monitor how that program is getting on, how?
...
1
vote
0answers
29 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 ...
1
vote
0answers
121 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
vote
0answers
42 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
0answers
104 views
Syncing structured data and files in Android App with an ORM?
I am developing an Android App which I have developed for iOS before.
The app requires that structured data and files are synced across android devices.
In iOS, I was using Core Data and synced to ...
1
vote
0answers
13 views
compare different approachs for saving related records whose values may change
On a web application for accounting services, I have the good old Invoice. To keep this example as simple as possible, each Invoice has many rows, and each row has its item with its price.
At the ...
1
vote
0answers
62 views
Automatically verifying INSERTs when building a PHP(5.3.3) application
I am building a form in PHP. I would like to automatically verify that INSERT queries are successful, and populate data correctly, as opposed to running queries in Workbench or MySQL with every code ...
1
vote
0answers
41 views
How can I aggregate data from separated databases in more efficient way?
Firstm I'm using PostgreSQL 9.3.
I'm solving the problem which is to retrieve a data from a separated databases and to render it into a web page. The web project is on the Java (JSF 1.2). Presently ...
1
vote
0answers
158 views
Properly design program database to reflect organization structure
I'm having trouble setting up my program's database the 'right' way. I was hoping you guys could give me suggestions on doing it properly. I am creating a database+client for a non-profit organization ...
1
vote
0answers
40 views
Storing last polled database timestamp unix
I have a Unix script which is called by a scheduler (CTRL M) every 3 seconds. The script queries an external database(not belonging to my application and therefore I can only query it) to check for ...
1
vote
0answers
92 views
data stored in dbase (application result dd.mm.yyyy)
I have a .dbf file (dbase) with data of type "date" to read directly via php.
I have the application result (format: dd.mm.yyyy) and the stored hex code. I can't interpret the hex data to get the same ...
1
vote
0answers
116 views
Unit Tests for Database Abstraction Layer
I previously asked this question about creating an algorithm for joining records from multiple databases, and since then, I have built a rudimentary version of it (which doesn't allow for inter ...
1
vote
0answers
132 views
Designing a loosely coupled app -> stored proc interface for PostgreSQL. A couple of questions
I am in the middle of designing a next generation database access class for one of the programs I am building. We use PostgreSQL exclusively.
Our current approach is procedural (largely inspired ...
0
votes
0answers
15 views
Is Python Logging in a WSGI application a best practice a production environment?
I am trying to log my webpage access to a database. It is a requirement. It seems to be a difficult thing to do outside of Windows IIS, and I do not wish to use Python with IIS.
My options seem to ...
0
votes
0answers
28 views
Hybrid Apps and Storage - how does it work with Native apps and which to use?
I'm using Ionic at the moment. I believe, like many others, that hybrid apps will become more more common/important than they are now simply because the frameworks are getting better and better.
...
0
votes
0answers
31 views
How can I model this scenario in a graph database?
I'm developing an application where users can tag resources and it's also important to know who tagged the resource with a specific tag.
A graph database seems like a good fit for this and the rest ...
0
votes
0answers
51 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 ...
0
votes
0answers
92 views
When to use a message queue as a web service database?
Does it make sense to implement a message queue system such as RabbitMQ or Kafka for the purpose of storing data in a queue? For example, this could be done in order to handle things such as ...
0
votes
0answers
21 views
searching for a user's friends
I have a rails that uses sunspot/solr for searching a number of models in our app.
We are now adding a feature for searching for a user's friends. So if I look for "joe" all of my friends named ...
0
votes
0answers
288 views
Evaluating local storage for data persistence for small, stand-alone applications
TL;DR -
I have a standalone application that will remain relatively small. I'm trying to evaluate between using XML files or a lightweight database for local storage of data that needs to be ...
0
votes
0answers
430 views
Best practice: Secure Android app online authentication
Currently, I develop an Android App needing online authentication for login (and registration).
The main focus is on security. I’m amaing for:
keeping the users’ passwords safe and
preventing MITM ...
0
votes
0answers
56 views
Connection Pooling
As an example, I am using PostgreSQL with an application-layer connection pool, such a a JDBC connection pool. The specific JDBC connection pool is not important. My question is more about the actual ...
0
votes
0answers
32 views
How to test for performance or locking issues of sharing a database with another app
I have a typical Spring/Hibernate Tomcat webapp that has a user_info table. I’m trying to create another webapp that will do CRUD actions on the user_info table. I'm considering sharing the same ...
0
votes
0answers
168 views
Save database changes in service layer or controller mvc .net
I have recently been using a service layer to abstract away alot of the business logic of my application. However I've come into an issue where I'm not sure what is best practice on doing the actual ...
0
votes
0answers
84 views
Appropriate design / technologies to handle dynamic string formatting?
recently I was tasked with implementing a way of adding support for versioning of hardware packet specifications to one of our libraries. First a bit of information about the project.
We have a ...
0
votes
0answers
69 views
Converting large files in python
I have a few files that are ~64GB in size that I think I would like to convert to hdf5 format. I was wondering what the best approach for doing so would be? Reading line-by-line seems to take more ...
0
votes
0answers
41 views
Sproc chaining verse discrete calls from OO code
I'm currently working on a change at work to generalize a function that was sloppily coded up to work for a particular use case. The function calls a particular sproc that checks if an entity exists ...
0
votes
0answers
48 views
Using a single table for identity and metadata
I'm in the early design phase of a project to provide an e-commerce platform that will require several entities to be modelled, products, customers, orders, CMS pages, etc. They will all have a few ...
0
votes
0answers
87 views
Fixing data duplication in two similar tables in different databases
I'm currently doing maintenance on an old order system that has grown into the poster child for bad coding practice. One of the tings I'm dealing with is a lot of data duplication, which I want to ...
