Questions tagged [database]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
2k views

Client/Server App – Best online data storage/administration/communication library?

I work on some iphone/android apps and the “data stored on a centralized server” pattern seem fairly common. So far, I have done one app like this, doing everything myself at a low level without ...
0
votes
2answers
1k views

How to store personal information properly?

It's not about security or something. There is a table to record user information, like username, password, postcode and so on, one record per person. There is also a table called post to record the ...
0
votes
1answer
67 views

what should i use running cron or getting by query

I have a table which has the amount,entrydate and amtperday field , which is to decrease daily. so what is better running the cron job daily to decrease amount. or or at the time of fetching data ...
0
votes
1answer
40 views

Report based on MongoDB data

My application interacts with an external system. There are multiple request-response interactions for a single business case. This information (request and response messages) is also logged in ...
0
votes
1answer
633 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
413 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
3answers
220 views

What should I be using to store data in a legacy web development project? [closed]

I'm currently working on a project that uses a Webserver running in Windows CE 6.0. Since this server only supports classic ASP (i.e, no PHP, ASP.NET, etc.)/ I plan to use XML as the database. Is ...
-1
votes
3answers
2k views

For what kind of websites is it ok or even better to use SQLite? [closed]

I'm familiar with the process of setting up Postgresql. And I'm also thinking of using SQLite for some of my websites for I don't need that much functionality that Postgresql offers. And I also want ...
-1
votes
2answers
132 views

When should I use a database instead of a list? [duplicate]

New to Python and all things database related. Wondering when I should consider using a database and why? I have what is essentially a list of objects that is around 30000 lines long. I'm developing a ...
-1
votes
2answers
1k views

Loading database in memory vs querying

I am currently developing a continuous backup software. The key feature of the software is instant backup meaning that each time a file is created, modified, renamed or deleted the change is ...
-1
votes
1answer
66 views

Combine Ids to a single field

I would like to ask if there is any powerful method we can use to combine the Id's to a single field for faster search and retrieval. My case is like this, I have a table that stores ID's of ...
-1
votes
2answers
988 views

What would be the best database schema for article(categories, tags) API [closed]

We are planning to create REST API which has main objects as User and Article. Article object has following fields Title - one line Description - it can expand to few paragraphs Image - one or ...
-1
votes
2answers
1k 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
votes
1answer
75 views

How costly is DB data transfer as compared to data storage?

I've seen a number of answers (1, 2, 3) where they state that storage is cheap. So when designing a DB structure, it shouldn't be a main concern, or at least it doesn't rank very high in the list of ...
-1
votes
2answers
196 views

Getting to know my way around a database with hundreds of tables [duplicate]

I'm new to a small company that's pretty much run by one guy. He knows all the ins and outs of the system which is quite large. We have a database with about 300 different tables. I'm struggling to ...
-1
votes
1answer
41 views

How to execute a proper comparative performance testing?

There are two compatible versions of the same Product (e.g. database engine) that I want to compare to each other for the same input scenario (SQL query). The problems that I want to address at first ...
-1
votes
1answer
38 views

TEXT column as key for a table when there are other tables referencing that table?

I have a UNIQUE TEXT column (“name”) in SQLite for one of my tables (let’s call it “table A”) and i’m considering using that column as the key for the table The reason i can see for continue using a ...
-1
votes
2answers
59 views

The challenges of removing/modifying entries from a database located in persistent storage

I'm implementing my own simple database with disk storage, and I'm not sure how to go about modifying and deleting entries. The problem is that as you delete a record from arbitrary position within ...
-1
votes
1answer
73 views

Amazon RDS read replica without support from application [closed]

I'm very new to this,so please correct if I'm wrong. I've understood that with Amazon RDS one can create read replicas and use those for all read-only operations. This helps scaling the application a ...
-1
votes
1answer
56 views

Database multiple database query each time

I'm writing a rest service. For each request I use about 4-8 queries. Should I try to refactor those into a single query?
-1
votes
1answer
1k views

Connect to MS SQL database from client side [closed]

I had a software that was written on VB .Net and used Crystal Report to print out reports. It was a pain to maintain in my case, so I want to move the report to webpage version. I did some ...
-1
votes
1answer
11k views

SQLDatabase: Read a lot of data at once and process in memory or read the data when I need it?

I'm not sure how to approach this problem. I require a big chunk of data records from the SQL server. This chunk is based on variables, so I don't know before what records I need. I need to do a large ...
-1
votes
2answers
102 views

Splitting large table into multiple tables

Let's say I have a astonishingly big table (300 columns) with lot's of records (in the millions). This table is overly complicated to use. I'd like to refactor this table and split it in multiple ...
-1
votes
1answer
42 views

How should I update back-end data (e.g. follows, likes, etc.) which changes at an inconsistent rate?

(This is a conceptual question but as reference, I'm using Android Studio (Java) and Firebase Firestore...) My app currently has a structure where the user can follow authors and favorite their works....
-1
votes
2answers
133 views

Database optimization vs readibility

I'm working on some code that checks for some invariants in the database. For example to check that an element is not repeated the code checks for a database error since the invariant is coded at ...
-1
votes
1answer
162 views

How to handle legacy versions of DAL and Database?

Lets say you have a Database, and a Data Access Layer (DAL) The DAL will be consumed by a various number of products which access the Database. As time goes on, you add new fields and tables to the ...
-1
votes
1answer
1k views

Big amount of text: database vs file

I have a web application with medium-high traffic where users can save designs made by fabricjs, so each saved design is a json with many parameters. So basically two days after launch users have ...
-1
votes
1answer
82 views

Is there a generally accepted definition of “Secondary Index” independent of DB product? [closed]

Is the definition for "Secondary Index" anything more specific than just "Any index that is not the primary index"? EDIT: Here is some research I have done: Search Google. I evaluated the first 20 ...
-1
votes
2answers
60 views

I'm looking for a way to add database update scripts to a “playlist” [closed]

I've got a group of scripts to run and I'd like to batch them all together. Rather than write a .cmd/.bat file to run the lot it feels to me like there ought to be something similar to a playlist (e.g....
-1
votes
1answer
95 views

Database vs. server-sided scripting language [duplicate]

To keep my question short and to the point, consider this: $relation = $mysql->query("SELECT relation($loggeduser, $requesteduser) AS a")->fetch_assoc()['a']; if ($relation != BLOCKED) { ...
-1
votes
1answer
163 views

Elasticsearch and PostgreSQL combination

I have a marketplace application and I stored data in a PostgreSQL. I have performance problem for product search, I know I can improve search performance if I use Elasticsearch instead of PostgreSQL ...
-1
votes
2answers
55 views

Sensitive data and cloud storage

I've been reading about machine learning models deployment and pipelines and so far most of the sources suggest that the data should be ingested from some sort of cloud based storage or source, be it ...
-1
votes
1answer
57 views

What is the best design for this use case regarding bidirectional relationship? [closed]

For this question let's consider a system in which the users can match with each other (let's say for simplicity exactly like the dating apps). User1 matches User2 (and the other way around) only in ...
-1
votes
2answers
189 views

When self-referencing in a table, do you prefer `parent_id = null` or `parent_id = id` for a row referencing to itself?

For the discussion, I will provide my example. But I am interested in the broad guidelines. I save in my postgres DB legislation (law texts) composed of a single header (H), paragraphs (P), sub-...
-1
votes
1answer
112 views

Patterns for loading related objects in memory (without an ORM)

I am using ADO.NET to read a bunch of data from the database into in-memory objects. This is my domain model: // Question.cs public class Question { public int ID { get; set; } public ...
-1
votes
2answers
77 views

Should the TotalGrandPrice be property or Order or Invoice

I'm developing a shop. I'm trying to figure out: where should "total_grand_price" belong to? "total_grand_price" = price of all order items - discount + shipping + taxex +- etc.... Should ...
-1
votes
1answer
27 views

How should the Users table be defined in the database if an app intends allows signup and authentication from multiple platforms?

If an app allows its users to signup using multiple platforms like facebook, google, twitter and also use local signup, How should the users Table be defined in the database? Should all users be ...
-1
votes
2answers
394 views

Database model for inventory per user

We need to design a database model for an (internal) inventory system with the following criteria: Inventory can hold only 1 type (Item) object. There might be more than a million Item per user. ...
-1
votes
1answer
116 views

How to make sure I have the contract proposal approval in my system?

I am building a website and in it I am trying to follow the rbac (role-based access control) model. Now, the thing is that managers need to send their contract proposals to approvers (people who will ...
-1
votes
1answer
115 views

Need help creating a database of map polygons

As a side project with my coworkers -- we are oil and gas geologists -- we have been creating an interactive map-based learning tool for other geologists. We are having trouble building the database, ...
-1
votes
1answer
152 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 ...
-1
votes
1answer
391 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 ...
-1
votes
1answer
203 views

Any Non-Singleton PHP PDO Db Connection Examples? [closed]

Are there any good examples of non-Singleton PHP PDO Dbfactory or connection classes people can point me in the direction, or perhaps even briefly illustrate. I am interested in learning both support ...
-1
votes
1answer
56 views

Defining a DB schema and having existing schema conform to it? [closed]

I see a lot of DB migration tools that have up/down functions that deploy/revert DB schema changes. I have never seen a migration tool where you simply define the schema and it modifies your current ...
-1
votes
2answers
200 views

Anonymize Public Health Records Database

I am working on a project to anonymize PHI in our health records database when databases are copied to our testing environments. Currently, the database is copied and fields in the tables (first name, ...
-1
votes
1answer
211 views

Storing a looong lookup table

Background The product i am working on has a very long lookup-table. the table contains static data and cannot be auto generated. there are about 500 rows and 10 columns. columns have mostly integers ...
-1
votes
1answer
625 views

Intranet application platform decisions wamp vs node [closed]

I have a client/server java application with a firebirdsql backend. This is a pain because I have to install java and the client on every workstation, etc So it is now time to rewrite the application,...
-1
votes
1answer
1k views

keeping connection open all time in sql

I have developed a Windows application in c# in which multiple users can add some numbers and their name and can view the data entered. The problem that I have is that the sever is on my laptop and ...
-1
votes
0answers
15 views

Existing literature or solutions on programmatically crawling database as it relates to a single row?

I am working on a project that will programmatically take a given row in the database, and aggregate all related tables and specific rows that have either a direct or indirect FK relationship back to ...
-1
votes
1answer
30 views

Android Chat Application Architecture with websocket

I'm trying to build chat application in Android (future maybe webapp also) using websockets. The purpose of this project is to familiar with websockets, get know websockets and real time applications. ...