This tag is for general database questions; if you question is specific to SQL use that tag instead.

learn more… | top users | synonyms (1)

0
votes
0answers
27 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 ...
-2
votes
1answer
77 views

Backend choice for an AngularJS app [on hold]

I'm developing an AngularJS app, and the frontend part is nearly finished. The next step would be the creation of a backend solution to create and manage users. The user has to be able to add/delete ...
-1
votes
0answers
46 views

Backend development [on hold]

Being new to the programming world I've been learning for about a year now. Having a sometimes fragmented knowledge about programming and concepts I would like your guidance in this. I want to create ...
-2
votes
0answers
29 views

Has development of Titan Graph stopped? [on hold]

I has tried some graph databases and I liked the Titan very much. However I have not seen new versions a long time ago. Is it has a real future?
0
votes
0answers
47 views

Storing all tiles on a map [on hold]

A brief overview of how my game will work: I'm making a game that will be using Node. The game will be made of tiles. Say the map has a total of 250,000 tiles. Each tile requires information to be ...
-2
votes
0answers
38 views

Mongo DB schema creation

I am creating a chat app. What I will have is A set of users who will chat with customerCare. A company holding different departments. A department holding different agents. Agents from various ...
-4
votes
0answers
70 views

python create sqlite db bad formed [on hold]

Ok, i found this code that reads a encrypted file and generates a sqlite file, but when i try to read the generated db with sqlite browser or sqlite manager (a firefox plug in) i'm not able to view ...
-1
votes
0answers
15 views

XML and MS Access Database [on hold]

I am using this to load some data I want and then print them on a report. <RecordSource>SELECT firstname, lastname, Address1, Address2, SUM(quantity * ...
0
votes
1answer
60 views

Dropping database in Grails is too easy. How to prevent accidental drops?

I just dropped production database. It happened because I used dbCreate = "create" instead of "update" in DataSource.groovy. I was changing some domain models and wanted to update the database. ...
-1
votes
0answers
56 views

Which are the pro and cons of MongoDB? [closed]

I've been reading the following article. It lacks of sources and English is not my native language. Can you help me to deepen with some considerations on the pro and cons of this database? ...
1
vote
1answer
90 views

Organising data access for dependency injection

In our company we have a relatively long history of database backed applications, but have only just begun experimenting with dependency injection. I am looking for advice about how to convert our ...
0
votes
1answer
86 views

Is a Document NoSQL database appropriate for backing an email system? [closed]

Let's say I'm building a webmail application that fetches all the emails of the users to store them in a database. For example, if users have approximately 100M of emails, for 10,000 users it will be ...
1
vote
1answer
149 views

Why are JOINS deprecated for a in-memory database?

Correct me if I'm misunderstanding. Refer to the following sentence: Stack Overflow copied a key part of the Wikipedia database design. This turned out to be a mistake which will need massive ...
0
votes
3answers
73 views

How should the database schema be migrated?

I am using a bunch of freelance programmers to develop a web application. We are in the early stages of development, meaning that we are making many changes to our database schema. We have one test ...
-1
votes
1answer
36 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 ...
1
vote
1answer
58 views

Lazy Loading, DAL and BLL abstraction

I'm asking myself a question to code the right way on a new fresh project. I have a designed database and I mapped tables to equivalent POCO classes using Entity Framework 6 Code First. Then, I ...
76
votes
10answers
10k views

Why is “Select * from table” considered bad practice

Yesterday I was discussing with a "hobby" programmer (I myself am a professional programmer). We came across some of his work, and he said he always queries all columns in his database (even on/in ...
0
votes
0answers
31 views

Best approach for a server configuration data collection and reporting solution from a legacy script?

I have a project which involves collecting config data from windows servers in our (very large) server estate. My manager wants me to collect over 150 data items across all configuration areas ...
0
votes
1answer
83 views

Why doesn't MySQL have an explicit “No Limit” option for queries?

I use SQLyog Community edition and like many other SQL applications out there it puts a 1000 result limit on queries that do not have a limit provided. I am wondering why MySQL doesn't have an ...
7
votes
1answer
345 views

When allowing a user to change passwords, should I generate a new salt?

In my database, I have a column for the hashed password and the salt. My application allows users to change their password. Should I use the same salt for the password, or should I generate a new ...
0
votes
1answer
57 views

DB Design: How to link a single column to a collection of entities

I have a db design question that I am sure has been quite extensively covered but I cannot find a good answer already. The problem is how to efficiently link a single school course to a collection ...
0
votes
2answers
64 views

Trying to “combine” similar objects without doing a bazillion comparisons

In this database I have "accesses" - each access can have any number (usually less than 4, sometimes as many as 15) attributes. I also have "tickets" where N users are requesting M accesses, so I've ...
0
votes
1answer
55 views

Dividing database between MySQL and NoSQL

Mine is a typical website developed with LAMP stack. Due to scalability issues we are planning to incorporate NoSQL for the application. For the implementation, we are planning to implement hybrid ...
-1
votes
1answer
93 views

Should We Use Surrogate Primary Keys for Every Table? [duplicate]

We are developing a data model for a marketing database that will import transaction, customer, inventory, etc. files and the directive is ONE process that works for every client. We have been told ...
0
votes
0answers
28 views

How to upload huge data into SimpleDB quickly? [migrated]

I have a 2GB text file. I want to upload this into Amazon SimpleDB. I am using SDBExplorer to bulk upload the data. However the upload process is taking a lot of time. You can only upload around 25 ...
1
vote
1answer
78 views

How to compare and relate together the concept of DBMS to the concept of Cloud Storage system? [closed]

I am a student of Computer Science and I am writing my disseration on a Cloud Storage application developed in the company for wich I work. My problem is the following one: my supervisor (the teacher ...
1
vote
4answers
214 views

How do you call one program from another?

What I'm wondering is how running programs communicate with each other, and if someone could post some sample code for how to do this, so I can try it out myself, just for educational purposes. For ...
0
votes
1answer
71 views

Examples of designing a database that handles point tracking?

I'm attempting to expand my knowledge of how database designs and concepts work. I'm working on a hobby web/mobile app for practice that will challenge me. However, I am running into an issue. What ...
0
votes
1answer
58 views

Does a data-driven application need a database?

This may be a terribly stupid question, but I can't find anything even related on Google (maybe I am not searching properly). I've been a developer for around a year now. I do desktop and web apps ...
1
vote
3answers
63 views

What are the use cases for these relationship types?

Use Case What are the use cases for creating a one-to-one relationship where the parent points to the child compared to a child pointing to the parent? If there is no difference, is one preferred ...
-1
votes
1answer
48 views

How to maintain trade off between number of columns in table vs join operations? [closed]

I have learnt that if there are more columns in table, then get those results using join query. How to decide the max number of columns in table? How feasible is "Join Operation" if too many table ...
4
votes
0answers
46 views

Continous Deployment and database format changes [duplicate]

My current automated workflow looks like this: I commit changes I push changes Build (actually just a lot of tests using mock database) is triggered If all tests pass, the new code is deployed to ...
1
vote
1answer
111 views

Processing csv files (alternative to business logic in DB)

We are working on a fulfillment system for an online book store. Everyday we receive tens of CSV files (about 90 files) with data about purchased orders. Example: OrderId | BookTitle | ...
0
votes
2answers
113 views

Moving data between databases with XML

I just read this quote online: XML is a very useful technology for moving data between different databases or between databases and other programs. However, it is not itself a database. Which is ...
0
votes
1answer
187 views

Beginning Data Mining

For simplicity, my database has entities and transactions. Each transaction has a DateCreated and a foreign key to the entity. I'd like to have the ability to find entities that have had a recurring ...
4
votes
2answers
320 views

How deeply programmer should know about internals of database engine? [closed]

I am learning SQL Server 2012 along with C#. In the past, I took database class in college, and have good grasp on SQL language and can write queries. However, looking at SQL Server documentation (or ...
3
votes
2answers
164 views

What is a scalable and practical way to search existence of a group of strings in a huge file

Context: I built an app which generates around 1000 domain names based on user input. I need to check if they are available or not by matching against a huge zone file of parsed domain names which is ...
0
votes
1answer
87 views

How to manage multiple database credentials across multiple projects

We have 10 separate projects that all access the same database. Initially, all 10 projects had database credentials hardcoded into them. I decided to move the credentials into a utility method and ...
0
votes
1answer
68 views

Database design grouping many tables with their common fields [closed]

Is this a valid DB design? A user can create an organization, link as many offices to it, have an inventories that host items linked to organization or office, have clients for his business etc. | ...
1
vote
1answer
52 views

Good strategy to implement a listener processing tasks provided by the database

Let's assume this conceptual scenario: The database is constantly populated with "a ton" of tasks named PleaseSendAnEmail. A scheduler/listener in background is aimed to handle those tasks. Of ...
1
vote
0answers
73 views

Should I really need to implement event sourcing is this case?

An example of use case when event sourcing is applicable here whose excerpt is: Say, something went wrong in your app and as a result, a user gets blocked for abuse but that user claims to not ...
1
vote
1answer
145 views

What happens if computer crashes after giving commit command

If we are updating a field in SQL and ALTER the row also. After giving the COMMIT command, the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table ...
-4
votes
1answer
71 views

How do desktop applications talk to remote database server? [closed]

I have often seen desktop applications in stores and banks. How do these desktop applications talk to a remote database central server? There will be a desktop application which is installed on ...
2
votes
3answers
57 views

Select custom output formats from database with SQL

I am planning to make a simple rest service application, and I am currently deciding the architecture. I have decided that I want to write the middle layer in multiple languages, so that it is easy to ...
3
votes
1answer
122 views

implementing dynamic query handler on historical data

EDIT : Refined question to focus on the core issue Context: I have historical data about property (house) sales collected from various sources in a centralized/cloud data source (assume info ...
1
vote
1answer
83 views

Keeping database connection

Say you are developing a desktop application that extensively uses a database, should you have one handle for the database that the entire app references? Or should you open a connection when you need ...
0
votes
0answers
24 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 ...
1
vote
3answers
202 views

Why is my page load time so closely correlated with number of database queries?

Whenever I'm doing web development, and a page takes longer than half a second to be generated, I know that somewhere my code is hitting the DB too many times. The normal way to fix this situation is ...
1
vote
0answers
72 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
1answer
89 views

Is it substandard if I have multiple tables in my database yet there's no relationship at all? [closed]

I have multiple tables in my database. Some tables have relationship to others and some don't have. My friend told me that it is not advisable to have a table that is not related to others. Is it ...