This tag is for general database questions; if you question is specific to SQL use that tag instead.
0
votes
0answers
17 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
0answers
49 views
Oracle vs MySQL database, in relation to autonomic computing capabilities?
I am working on a project on a topic called "Autonomic Computing", which is Computer science sub-field with the goal of Self-X capabilities(configuring, healing, optimizing, protecting).
Well, I need ...
-6
votes
2answers
34 views
Best way to save and retrieve many images of a profile
I would like to know what would be the best way to save and retrieve a lot of images related to a single profile. For example, how exactly does instagram retrieve all images related to a certain ...
3
votes
3answers
335 views
Is it better to use a switch statement or database to look through 5,000 to 10,000 instances?
I have some JSON data in this format (5,000 instances for now):
{"id":"123456","icon":"icon.png","caseName":"name of case"}
I am allowing the user to search for the name of the case and then return ...
1
vote
1answer
51 views
Are HSQLDB unit tests an anti pattern?
HSQLDB is great. It (also) has an embedded mode (no dedicated server needed), which allows for quick prototyping of stuff like Proof of Concepts, and it can also be great in production-ready ...
1
vote
1answer
23 views
Socket Connection Data Insert
I have been working through a high-performance application where I have identified a bottleneck. The bottleneck is actually when the application must insert messages from a socket, it will record them ...
-1
votes
0answers
25 views
Resources for learning about ORMs? [closed]
I have been reading many blogs on the topic of ORMs and have consistently been reading that many of the problems from ORM use comes from a misunderstanding of ORMs.
Well, where can I go to learn ...
-1
votes
0answers
20 views
Connecting html pages + Razor to database (Windows 7-64 bit , Microsoft Visual studio 2010) [migrated]
I am doing a learning project in which i wanted to combine Html+Razor and connect it to Database.
Steps I followed.
Created a sample form ( which i intend to use to execute "insert" and "update" ...
-2
votes
1answer
37 views
Scrubbing blog posts for search keywords [closed]
I have a blog with some posts on it.
Unfortunately I still do not produce perfect code and architectures.
When I built all of the site and database stuff I forgot to include Keywords so I could ...
-1
votes
0answers
44 views
Subtracting dates in PHP error? [closed]
I am getting a date from my MySQL database and using strtotime to convert it into UNIX_TIMESTAMP, and comparing it to the current date which I receive from PHP's time(). However, I'm getting really ...
1
vote
1answer
35 views
Transparently adding a database interface layer
I am currently looking for ways to optimize an application that is consuming unacceptable amounts of memory.
The process basically takes input and parses it into a tree. The tree is currently stored ...
1
vote
2answers
26 views
Using Hibernate Criteria framework for complex queries vs. just making views in DB
I like using Hibernate for regular simple CRUD operations.
However, I am trying to understand why anyone would resort to its Criteria framework to assemble complex recordset criteria as opposed to ...
1
vote
2answers
76 views
How to store currency ranges in a Postgres table?
I am using Postgres 9.3.
I have to store range data like <$250K, $250K-$4M, etc which we will display in a dropdown.
now I am making a table for all possible options that can be configured from ...
0
votes
0answers
36 views
Design of a custom query result array with lazy loading
I have a database that generates a query result array, each position of the array being a hash like object.
Since each array item must be mapped into a well defined class, I decided to implement an ...
2
votes
2answers
56 views
single table w/ extra columns vs multiple tables which duplicate schema
I am working on a project where at some point, I needed to make a decision on whether or not, in the database, I should have a single table with multiple columns that not every record uses, or ...
