This tag is for general database questions; if you question is specific to SQL use that tag instead.
-2
votes
0answers
26 views
An authentication system in vb.net with database like Windows user Login [closed]
I need to design an authentication system in vb.net like the Windows Login and Logout...I would like to use a database.The Structure should be like this:
|--------------------------------|
User Id| ...
-5
votes
2answers
55 views
Where should I keep the central database and which database would be appropriate? [closed]
I am developing a gym software in C# as a window application but need to connect it to a central server so that people can install it on their PC's and connect to the same database. I want to package ...
-1
votes
1answer
35 views
program to format db table information into fixed-width font grid [closed]
Is there any online software that can take sample information in the form of a database table and put it into a visualization in the form of
+----+---------------+
| id | name |
...
2
votes
3answers
77 views
Plugin Architecture: How to Handle Databases and Logging?
I am in the process of designing an architecture for a plugin based application and I have some questions about how to handle database access and logging. The goal of my application is to allow a ...
2
votes
2answers
67 views
Moving from local storage to a remote database: how should I cache the data locally?
I have a .NET (C#) application that I am releasing soon, which also has some support files. Right now I am storing those files as .txt files, and I update them as necessary whenever the application ...
1
vote
1answer
46 views
Testing interaction with large CRM database
In our company we have two large systems, basically they are scoring and CRM. Both have large SQL Server databases running on Windows servers on the intranet. These two databases are managed by other ...
-1
votes
1answer
72 views
Which database choose for my case? [closed]
I'm starting develop a new web application with PHP. This app will store GPS data from vehicles to trace their path. It's a monitoring tool. I'm predicting a large growth of data on it's database.
...
1
vote
0answers
14 views
how to fix this error “Data type mismatch in criteria expression”? in vb 2008 [migrated]
I'm getting this error in VB2k8:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim str As String
str = "UPDATE EmployeeTable set ...
2
votes
1answer
93 views
Domain Driven Design with an EAV database model
How can one apply DDD to a EAV database model?
Consider this EAV database model:
How am I supposed to build a domain model if all my entities and their attributes will be stored in the database?
...
1
vote
1answer
63 views
Database data structures for RESTful api
I am creating a RESTful API. I am struggling to decide on the best way to design my database tables around my resources.
Initially, I though a table per resource would be a good way to go, but I'm ...
1
vote
1answer
116 views
Table scaling with partitions or with separate databases?
Let's say I have a table (let's call it BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb.
These daily INSERTs are ...
0
votes
2answers
85 views
Database for Desktop App Development [closed]
i'm currently working on a desktop application for the windows platform, I want to know the best database to use for the application, one that is compact, such that it can be packaged and ...
1
vote
1answer
19 views
Multiple Display of a Document and persist each viewer change in a single document
i have a scenario where i have to make available a document for viewing and editing to multiple users, the users can edit and view the document at the same time. Now the problem arises here if for ...
4
votes
5answers
410 views
Database connection - should they be passed as parameter?
We have a system whereby the database connection is get once using a common method, and being pass throughout the relevant class to be used. There are doubts that passing the database connection as a ...
5
votes
1answer
116 views
Entity Framework as a type checking/verification system for database code
When I read pro and con lists of using Entity Framework (or any modern ORM really), I'm surprised that the following point doesn't arise (self quote):
Using strongly-typed domain entities allows ...
3
votes
5answers
209 views
Senior team members want to move query-relevant persistent data from DB to cache. Does this make sense?
I am a young engineer recently employed at a small company that sells products to the general public. We use Ruby On Rails and MySQL. Our database has a lot of customer data, but a great deal more of ...
4
votes
1answer
92 views
What is the common approach to component template databases?
My Project:
I have employees who are required to go through a checklist when they encounter a duck, a cat, and a human. In our business, we have a set number of ducks, cats, and humans that come in ...
1
vote
1answer
63 views
Single-Tenant Databases - creating and updating new tenants via PHP
We've built a single-tenant webapp in PHP and as it stands each hosted 'site' has its own database.
However we need to be able to run a script to create their database, assign a mysql user, and ...
14
votes
9answers
983 views
Should I try persistence in flat file before database?
Somebody explained to me that since in agile development, policy and the application logic should be more important than details such as persistence method, persistence decision should be taken at the ...
2
votes
2answers
275 views
Why is NoSQL better for this scenario?
Hypothetical scenario: Let's say we are downloading JSON from Facebook with details of a user's friend's checkins, posts, etc... These come in as one document per friend per activity, so with 8 ...
-1
votes
1answer
97 views
Development paradigm: SQL programming vs using SQL to program [closed]
I would like to know what are the pros and cons to two apparently valid philosophies regarding the programming of an application which makes extensive use of a database.
The first philosophy is to ...
4
votes
2answers
134 views
Do I really want a dynamic Enum, or something else? Better caching? A Struct?
This question is asked on SO and this site often it looks like. "How do I do a dynamic enum?" Answers range from you shouldn't to possible compile time solutions. Now my question is do I want a ...
2
votes
2answers
101 views
Scalability: How does splitting a database table work on different replicated SQL Servers?
I would like to know more about the general concepts behind dividing data of a database into different servers. For example, suppose I have a SQL Server database which has a massive table. Assume one ...
5
votes
1answer
190 views
What is “the right way” to do search on a website?
I'm talking the kind of search that auto-suggests your query as you type, the way Google does, the way Wikipedia does, the way Stack Exchange suggests other questions as you type the title, etc. And ...
4
votes
2answers
301 views
Why shouldn't you use JDBC in Java applets?
I've heard people saying usage of JDBC (Java Database Connectivity) isn't recommended in Java applets. All I they say is: 'because of the security reasons'. What 'security reasons' do they mean? What ...
1
vote
1answer
72 views
Is Neo4j graph database sufficient to itself for all query types?
Neo4j eases relationship traversals => especially useful for a social network for instance.
But are there any scenarios when it's advised to associate an additional relational database (or other ...
1
vote
2answers
114 views
Referential integrity in a database where tuples are not physically deleted
Many modern Relational Database Management Systems automatically support referential integrity, i.e. when you try to delete a tuple which has a reference (in the form of foreign key, for example), the ...
4
votes
2answers
101 views
Establishing an API to provide end-user apps/scripts access to multiple types of databases
Question and Context
I am currently working on a project where the main question is, how do we insert an API between the database and end-users who may develop applications/scripts of their own that ...
7
votes
4answers
237 views
Database History Table / Tracking Table
Currently I want to structure a tracking/history table like this:
PrimaryKey - ID
OtherTableId - fk
fieldName - name of the field its tracking
OldValue
NewValue
UserName
CreateDateTime
So ...
2
votes
2answers
251 views
Data representation with C# and WPF
I'm developing an application handling DB parts. I retrieve the data from the DB with stored procedures and prepared statements. Now I want to display the data in the GUI.
What is the current ...
10
votes
4answers
762 views
Do You Still Need Indexing After Database Normalization
After you have done a good normalization, do you still need to index the table? How is this going to affect the performance? Will it even affect the performance in some way after a good normalization? ...
6
votes
3answers
318 views
Are these SQL concepts for beginners, intermediate, or advanced developers?
I've been learning SQL recently and practicing with MySQL/Postgres and soon Oracle DB. I've also search the web for a 'road map' study of databases but couldn't find one, unfortunately.
I want to ...
3
votes
6answers
239 views
Should a database table(s) structure match its intended data structure(s) in the logic?
This question branches out of this question, What are the differences between algorithms using data structures and algorithms using databases?.
The General Question
Should a database table(s) ...
7
votes
4answers
487 views
What are the differences between algorithms using data structures and algorithms using databases?
The General Question
What are the differences between algorithms using data structures and algorithms using databases?
Some Context
This is a question that has been bugging me for some time, and I ...
2
votes
1answer
38 views
Reporting and handling asynchronous process errors to a client
I have a product with two separate applications. The core of the product lives in the database (oracle) and runs according to a schedule. The other is a client application (currently ASP.NET MVC3) ...
2
votes
1answer
172 views
DB Schema for packaging products / services together under a single pric / Offer
I'm trying to 'conceive' the business logic of this website that have many activities, that the users can build their "combo" and get discounts depending on their choices and how long they are willing ...
1
vote
2answers
200 views
typical way to share database connection for open-source project, without revealing too much
I have an open source project for mydomain.com which requires connections to a database (...as is tradition). What is the standard practice for allowing others to work on the site, without giving them ...
5
votes
3answers
270 views
Unit Testing DatabaseOpenHelper class in Android
I've wrote several unit tests for already existing DatabaseOpenHelper class. I covered creation scenario and migration from old schema to new one. Unfortunately I don't fill that my tests are good. ...
5
votes
1answer
320 views
Is there a database programming language with encapsulation to prevent the injections?
One of things that annoys me about SQL is that it can't think in terms of objects and it's lack of encapsulation makes me constantly have to escape commands to prevent injections.
I want a database ...
8
votes
4answers
308 views
Should database queries be abstracted out of the page itself?
When writing page generation in PHP, I often find myself writing a set of files littered with database queries. For example, I might have a query to fetch some data about a post directly from the ...
0
votes
2answers
209 views
Designing a Web Application with Two Different Backend Databases [closed]
I'm working on a pretty standard LAMP based web application. The server itself has a standard MySQL database and the application is written in PHP. The kicker is, we also use SQL Server databases ...
1
vote
2answers
153 views
How can a single database work for website, mobile apps?
We have developed a job-portal where users can view jobs and and also post jobs. We have used Php and MySQL. We hosted this on web faction. Now we want to develop the mobile app of the job portal for ...
-2
votes
2answers
143 views
Using database Indexes [closed]
This might sound like a naive question but when are database table indexes in mysql required? How do such indexes affect performance and why?
35
votes
11answers
2k views
Is there any reason not to go directly from client-side Javascript to a database? [duplicate]
Possible Duplicate:
Writing Web “server less” applications
So, let's say I'm going to build a Stack Exchange clone and I decide to use something like CouchDB as my backend store. If I use ...
3
votes
3answers
210 views
Architecting persistence (and other internal systems). Interfaces, composition, pure inheritance or centralization?
Suppose that you need to implement persistence, I think that you're generally limited to four options (correct me if I'm wrong, please)
Each persistant class:
Should implement an interface ...
3
votes
3answers
174 views
Should I use a config file or database for storing business rules?
I have recently been reading The Pragmatic Programmer which states that:
Details mess up our pristine code—especially if they change frequently. Every time we have to go in and change the code to ...
3
votes
3answers
138 views
Storing lots of large strings with frequent “appends” and few reads
In my current project, I need to store a very long ASCII string to each instance of a given object. This string will receive an 2 appends per minute and will not be retrieved so frequently.
The ...
4
votes
8answers
274 views
How can I give my client “full access” to their PHP application's MySQL database?
I am building a PHP application for a client and I'm seriously considering WordPress or a simple framework that will allow me to quickly build out features like forums, etc.
However, the client is ...
0
votes
1answer
113 views
Storing revisions of a document
This is a follow up question to my original question. I'm thinking of going with generating diffs and storing those diffs in the database 'History' table.
I'm using diff-match-patch library to ...
2
votes
2answers
439 views
When should we use weak entities when modelling a database?
This is basically a question about what are weak entities? When should we use them? How should they be modeled?
What is the main difference between normal entities and weak entities? Does weak ...
