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
1answer
31 views

Read/Write third party SQL Server database

One of my customers has a licensed software for business management and uses a SQL Server as database server (The database is open and I can run queries). They have a need that the current software ...
-1
votes
0answers
24 views

difference between clustered and non clustered indexes

How is clustered index diffrent than non-clustered index. I understand that clustered index will store data in the sorted order of indexed column in secondary memory. Please see below table that ...
-2
votes
0answers
25 views

Need suggestion for decision table/filtering implementation [on hold]

Need SQL suggestion for data filtering. Column count can grow. Decision table A | B | ... | Value ============================= x y ... 1 empty y ... 2 x ...
0
votes
0answers
25 views

Database Considerations (Loop vs comparison)

I am working on a project where I am provided a CSV file with around 60k records containing printer usage. The CSV file itself has no primary identifier per row (it's an export from another system). ...
3
votes
1answer
68 views

What is the proper way of editing/updating many-to-many items in DB?

I have film's storage (3 tables in database): films{id:int, film:string} genres{id:int, genre:string}, films_genres{film_id:int, genre_id:int, probability:int(%)} (film_id, genre_id) is UNIQUE KEY(...
-3
votes
1answer
36 views

SQL- get start and end date With a specific event [on hold]

I have a database with with event dates and events. I need the start date and end date for a specific event. I am able to do this while specifying the event in a where statement, but I need the ...
-1
votes
4answers
122 views

When should we use MongoDB?

MongoDB is a NoSQL database which I've found quite easy to use. Recently I had to develop a simple application which needed to collect some data using HTTP requests and store some results after ...
1
vote
2answers
64 views

How should I setup a database for school management?

I'm struggling to set up a database to use in my School Academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest ...
0
votes
1answer
23 views

How Do DB Version Control Systems Lack in Script Semantics When Modeled on Souce/Target Difference Comparisons

There are several database version control solutions out there to assist with controlling not only the versioning of a database, but also deploying and synchronizing databases. These systems are ...
0
votes
0answers
12 views

How do I implement Socket.io Leaderboard using AWS Dynamo DB cost-effectively?

Every time a user submits a score, Socket.IO causes all the users get their leaderboard updated. This causes every single user connected through Socket.IO to read from the Dynamo DB database (every ...
0
votes
2answers
163 views

How should I architect my back end based on these needs?

I haven't started building my back end yet but I need to now. My needs are the following: Database needs to be holding millions of game information (just info that can be stored in a typical db ...
0
votes
0answers
64 views

Generating reports from large datasets

I'm working on an CRM type application(.NET, SQL Server) that needs to generate reports from large datasets, millions of database rows in a dozen different tables with a lot of aggregation and logic. ...
3
votes
2answers
103 views

Building an abstraction database

The Scenario I have a Classic ASP project with a SQL Server backend that I need to port to ASP.NET MVC. The legacy site makes liberal use of schema definition analysis in the application itself. ...
1
vote
2answers
32 views

Using table record id as an image name

I have a table where each record has a corresponding image (say the table is users and the image is the profile image. I am saving the images in the file system. I am thinking of using the table ...
1
vote
1answer
44 views

How to synchronize data between two web services

I'm currently working on a project consisting of two different web applications. One of the applications is a PHP web server with a website front-end and a MySQL database. It consists of Laravel ...
4
votes
2answers
182 views

Is it okay to use a non-ID column for foreign key reference?

I have my tables as below Role(Role ID, Name, Other_Columns) Command(Command ID, Name, Other_Columns) I have association table RoleCommand. Is it okay to have RoleCommand(RoleName, CommandName) ...
-3
votes
0answers
54 views

Status update according to time set in database

I am new to php and phpmyadmin, I am currently working on a project to build a website for employees to update their in/out status. I have created webpages for admin to add users and let users to ...
4
votes
2answers
104 views

Is my database supposed to contain the links to the files, or would it contain the files themselves?

I'm trying to better understand how to use a database in a personal website. I have a set of lists, like my shopping list, to-do list etc. Currently, they are all stored in text files with hard-...
-1
votes
0answers
48 views

C# WPF Application with Entity Framework : How to manage multiple connections

An other developer and me have a C# WPF application which use the Entity Framework for handle the database. The main goal of the application is to manage differents reports that can be created, ...
0
votes
0answers
19 views

QSqlDatabase member inside QRunnable - yes or no

I am working on Async multithreaded Tcp Server in Qt and I am wondering, which approach is beeter: To encapsulate QSqlDatabase as member inside QRunnable To create local QSqlDatabase variable inside ...
1
vote
0answers
71 views

high-dimensional index structures

I'm looking for information on searching (filtering) high-dimensional data. I'm not interested in nearest-neighbour search or clustering, but rather filtering/sorting by subset of dimensions - like in ...
2
votes
2answers
77 views

How to create an efficient implementation of a dictionary of synonyms?

How do I create a dictionary of synonyms that is efficient in terms of retrieving synonyms of a word? Basically, I want to use some sorts of data storage to store groups of words, and enable an end-...
-1
votes
1answer
71 views

Sql vs nosql important data [closed]

In one of youtubes videos about scalling web sites I found the statement that, however, in term of scallability, noSql is easier and more flexible, though it is better to use SQL for data important ...
5
votes
4answers
384 views

Is it good practice to use a single database connection?

The PHP codebase I'm working on has an utility class that returns a database connection. The implementation looks like this: class Database { private static $conn; private static $init = false; ...
3
votes
3answers
52 views

Shared development and CI database

I'm just about to set up CI for my web application. I'm using Bitbucket and Pipeline beta as a CI. The web application is strongly coupled to the database, nothing can be tested without data in it. ...
-1
votes
2answers
202 views

Why use using-statements when you want to reopen connections? [closed]

In a Winforms project I've been working on recently, I've been dutifully using using-statements for objects that implement IDisposable. I want to reopen a database connection, however because the ...
1
vote
0answers
42 views

How to deal with weekly schema updates on database production server? (ASPNet MVC and Entity Framework)

I'm working with scrum methodology. thus weekly schema updates are performed to the final product. However our customer is already populating the database. How can I update the database without ...
0
votes
5answers
145 views

Best approach to write on a database with two webservers

I have an architecture/performance problem. The problem: One voting based application with: 1 loadbalancer, 2 webservers and a database 10 candidates and 200k voting users. There may be more than ...
8
votes
9answers
326 views

Is it unnecessary to learn the kind of data structures and objects inside sql only because we are using another language to access db indirectly?

Suppose we are using java or python to access the database. Then is it considered a wastage of time and unnecessary to learn the kind of data structures and objects being used inside sql? Please ...
0
votes
1answer
31 views

Design question to best option for storing data in file or DB

I am working on a feature where I need to store some data and I am not sure what should be my best option to store this data. I am sending data to some third party and want to show some part of that ...
6
votes
4answers
242 views

Is it too verbose to always have 'modified' time stamps on all entities within a database?

The question can be summarized as: In a database (regardless of type), would it be considered a good practice to always include updated, created (and possibly deleted) properties, for all entities,...
1
vote
0answers
44 views

how to store state, cities and countries in Neo4j

I'm a building a registration form for my website and need to populate the country, state and city field. All these fields are inter-linked i.e depending on country, state field will be set and ...
0
votes
0answers
18 views

managing database update effectively

I developed a small app using sqlite starting from version 1. From time to time, new features are added to the app which requires database modification in the dev machine. On the client side however, ...
1
vote
1answer
40 views

ERD for a Lab Database

Question: In a database for a clinical reference lab a specimen, when taken, triggers a test order (for testing obviously) creation.If that test order produces a failure, the specimen is given a new ...
-1
votes
1answer
172 views

What's the best way to populate a new row in a database?

Is it possible to add a new row to a database using DataSet? When I created a new DataSet and dragged the table from the database I could see that in the DataSet methods there was one called insert ...
0
votes
1answer
100 views

js spa rest backend business logic vs presention logic

I am very confused about what should a SPA's REST backend do and expose. In most blog posts and books I read they depict the backend pretty much like a direct access to the DB, practically CRUD ...
0
votes
1answer
23 views

Terminology for partial offline database synchronization

I am looking for solutions for a field where I think I don't know the adequate terminology. The problem is that I have a central SQL database in the cloud. Then I have child databases only containing ...
19
votes
6answers
3k views

Advantages and disadvantages of using bit masks in database

Not so long ago I talked to my colleague and he was definitely against using bit masks because it is hard to understand all the values that are stored in the database. In my opinion it is not always a ...
0
votes
4answers
49 views

Including record data in the ID number

I'm working on a project that requires assigning ID numbers to records about people in a database. Each person may have many records associated with their ID number. There was a discussion about ...
1
vote
2answers
45 views

Multiple local Oracle XE instances

We need separate local databases per developer and per release/subproject on the same remote machine, as we are utilizing it for all the development activities. How is it possible to make it with ...
3
votes
2answers
95 views

How should I refer to data bound columns?

I work often with data-bound applications with WinForms; records are pulled from a database and updated in a client application that I write. Stored procedures are used for all database transactions ...
2
votes
0answers
83 views

Are there downsides to writing PDO/mysqli statements into my code directly vs using my own redirect wrapper methods?

TL;DR: To access DB functionality in my codebase I currently use a custom layer throughout the code. The layer needs an upgrade in order to begin accepting prepared statements, which it currently ...
1
vote
3answers
93 views

Storing Business Logic in Tables rather than Stored Procedure or Application

The requirement is that once the product has been delivered, user can update the logic as he wants. An example of logic I have is follows- An institute teaches English has following requirements - ...
1
vote
1answer
35 views

How to implement searchable persistent queues?

We will implement a system , which will receive quite a lot of requests through web service interface. We will have to queue the requests and process them asynchronously. Consequently we will have to ...
6
votes
2answers
110 views

Seeking benefits of both SQL and binary files in a data storage scheme

I'm looking for some input on how to keep certain benefits of both a binary file and a SQL database in an interesting data storage problem. I have a legacy custom binary file format that is ...
0
votes
0answers
36 views

Design a System to save a data that will be missed from another system

I'm building a middleware system where I'm saving the data from VERY slow API, The system behind this API works like this It produce a data blocks, lets denote a datablock by A. While A is used by ...
0
votes
2answers
168 views

Should I use a plain text database, or SQLite? [closed]

I'm creating a point of sale system for a small shop. I am particularly interested in finding patters from all items purchased, which I will log in their entirety. I'm thinking of even making queries ...
1
vote
3answers
75 views

Updating all records in MySQL table while still available to the user

I have this 'table A'. It contains two columns; email and email_alias. A sample is below: ===================================== = email | email_alias = ========================...
0
votes
1answer
97 views

What are the consequences of eliminating the ORM/ODM in a NoSQL based system?

In Martin Fowler's article OrmHate, he states the following: If you have an application problem that maps well to a NoSQL data model - such as aggregates or graphs - then you can avoid the ...
2
votes
1answer
125 views

What functionality to expose in a database abstraction layer?

I'm trying to design a simple way of abstracting away data persistence behind an interface, but I'm having a hard time figuring out how much fine grained control should be exposed to higher layers. ...