This tag is for general database questions; if you question is specific to SQL use that tag instead.
2
votes
5answers
156 views
What is faster? Using REST API or querying a database directly?
What is faster performance wise? Creating a REST API and having your web app use the REST API to do all interactions with your database OR querying your database directly (i.e. using whatever typical ...
2
votes
3answers
53 views
Find all circles that cover one point
I'm not sure if I've been searching using the wrong keywords, but I've tried so many different ways of wording this and I can't find a relevant answer.
Basically, given a set of circles defined by ...
-1
votes
0answers
13 views
how to access different table for different operator in phpmyadmin [on hold]
I have different menus which actually a table and I have different operators.Admin operator would have access to all table.But what I want is that when I log in with different operator besides admin ...
1
vote
2answers
185 views
NoSQL or MySQL? [closed]
I'm developing an app that requires to save data that is not consistent across all rows. These database entries represent different kind of sport activities. Let's take an example: In football the ...
-1
votes
0answers
22 views
Saving Images - Best Practice Techniques [closed]
What are the best practice techniques to use when it comes to saving images? The system I am developing is an e-commerce website. The directory structure I am proposing to use is as follows:
...
0
votes
0answers
17 views
Application/Database Design: using a table for workflow/content approval logic
Probably a poor choice of title but can't think how else to word it.
I am developing an app for a company using CakePHP (MVC Framework).
I have built a "Status" model which essentially has an an ID ...
0
votes
0answers
15 views
One Enum vs Multiple Enums [duplicate]
I am developing an application where a user submits a mission and other users accept the mission.
Pretty simple.
I want to keep a track of the mission progress status and store it into a database.
...
1
vote
1answer
74 views
Composite Primary Key drawbacks
For website that I maintain (eCommerce) I now need to make a table that seems to require Composite Primary Key of 5 columns.
I never used 5 column as primary key before, only 2 and rarely 3.
I ...
16
votes
5answers
3k views
Why don't Windows/Linux OS use relational Databases (RDBMS)?
Why don't Windows/Linux OS use relational Databases (RDBMS)?
I know they use File Systems to store all data but don't you think it is more efficient to use databases like we use in Web site/web apps?
...
1
vote
1answer
18 views
Should MVVM models contain complex objects
Let us say that I have a Book class, a book can have an object of another class like an Author or other complex objects like a list of Genres. My question is, in an MVVM model should I make the ...
3
votes
1answer
85 views
Business concept design vs logical database design
Good day. I need help for a specific case. A little background: We have an existing app, it is like a PDF viewer, and you can draw freehand, highlight, add highlight with notes, add action items, etc. ...
2
votes
3answers
132 views
How to use one web page to create and edit database entries
My team and I are developing a java web application which allows our admins to create and edit "methods" which can later be viewed by other users.
We are currently discussing the best way to ...
3
votes
4answers
376 views
Application development with fully dynamic controls and processes based on database
All software development projects are moving into separation of design, logic , data in patterns like MVC , MVVM and others.
Strangely i got a very strange requirement for a new software; that is :
...
0
votes
0answers
31 views
Using Google for full text database search
I have a lot of text and I am storing it in Elastic search. Using Lucene, NLP and Wordnet filters the search is good but not as good as Google's because none of these methods use AI for the search so ...
6
votes
3answers
326 views
Do common relational database systems work 'out of the box'? [closed]
I'm quite new to software development and whenever I come across small projects which involve storing (relational) data I always ask myself if something like a micro-blog (or any other project with ...
5
votes
2answers
87 views
How to incorporate a database into a branch-per-issue version control process?
We're hoping to move to a new branch-per-issue process with development. To prepare for this, a lot of research and experimenting has been happening in terms of version control, CI, and process of ...
10
votes
2answers
435 views
Why store flags/enums in a database as strings instead of integers?
I've been browsing SQL dumps of some famous CMSes, including Drupal 7, Wordpress (some quite very old version), and some custom application based on Python.
All of these dumps contained data with ...
1
vote
2answers
314 views
.NET Why should I use DAL over direct database access
Yesterday on one of SO chats I've been told I should never connect to database directly from the application and rather use DAL.
I've been told that:
1. Using something in the middle should improve ...
0
votes
0answers
19 views
web app+databse+object store E2E testing
I wrote a thin layer that allows me to log every interaction between other programs and object store. It has simple logic to accept and serve only unbroken files(if checksums provided by user and ...
0
votes
0answers
18 views
DataStore for Certificates and Keys
I am developing a web application. It is a multitenant(SAAS) application. My application involves getting signed certificates from users. Obviously each certificate would be having a separate CSR and ...
1
vote
1answer
115 views
Java partial enum backed by the database
I have following problem:
need to use enum in my java code, since I'll have to ask in my business logic things like if(someting == enumname.VALUE_ENUM){... but I don't have all the enum types at the ...
0
votes
0answers
29 views
Fast comparison of recursive directory tree against a database?
I'm creating basic media player in the style of foobar2000. I want to load Id3 tags into a database because scanning whole directory tree every time is slow. The problem is, when user changes ...
0
votes
1answer
75 views
How to get real time notifications, when a database change (insert, update, delete) occurs?
I'm creating a dashboard which should monitor a database table. I have only database access (no application layer). The table is rather large (10 million rows), however not changing rapidly (100 ...
1
vote
0answers
71 views
how to import large amounts of data without locking sqlite database
Background Information
I have a web app that provides the user with the usual CRUD functionality for "widgets" let's say.
But I also have give them the option of creating widgets in bulk via ...
2
votes
1answer
60 views
Reuse already fetched data for request
I have action that fetches user model from db to check access.
Then I have method that in some cases requires same model.
function checkAccess(req, res, next) {
var data = ...
9
votes
4answers
819 views
Class Duplication Pattern?
I'm currently working as a solo developer on my current project. I inherited the project from another developer, who has since left the company. It's a model-view-controller style web application in ...
0
votes
1answer
29 views
How can I approach application programming from a database background? [closed]
I have a lot of database experience, but virtually no application programming experience. At work, we have an EDMX? model generated from entities in the database, and we transform T4 templates to ...
3
votes
3answers
124 views
Is it better to make database calls or external API calls first in the context of a single Web request?
Say you have a Web app that uses data from both a database and an external API, and for certain pieces of functionality, you need to call in to both in order to read/write the necessary data.
Is it ...
0
votes
1answer
47 views
Making API calls with celery
I'm designing a system for a client where the requirements are:
they upload a JSON file (one object/line)
make a call to an API with the JSON object as the payload
record the state (success/failure) ...
3
votes
1answer
35 views
Should I omit database and server communication (after initial response)?
I have a project that I'm working on where a user uploads a big file which gets parsed by the backend, and then returns the data back in a friendlier format. Now I'm wondering whether I actually need ...
0
votes
1answer
215 views
Java front-end, PHP/MySQL back end methodology
I have been basically out of the programming world for about 10 years, with only a bit of dabbling here and there with small Java utilities and one large Access database I wrote for someone, and some ...
1
vote
1answer
46 views
filtering data from db
I've taken over a web application that someone else built. It's a pretty simple application that queries ALL records from a db and displays them in a list.
They've also provided a way to 'filter' the ...
2
votes
1answer
85 views
In what case would indexedDB be useful [duplicate]
I have been over-viewing indexedDB recently, and I cannot seem to find a suitable use case that would not be better done using a server side database. Since the little hackathon competition I'm doing ...
39
votes
7answers
4k views
Does using a database server make sense if the application only does things locally?
I've seen some applications that are basically application software that run local to the system (so they don't have communicate much over the network). These applications seem to depend on database ...
-1
votes
1answer
45 views
What tools are there to create/generate a full stack dev project? [closed]
I'm starting to develop a new project and I'm looking for a tool to generate all the needed layers for a full-stack dev project.
I'm looking for a hello world generator that provides all the ...
1
vote
2answers
122 views
Database Design for Inventory
I am starting to design a typical product based MySQL database but I keep running in circles on how to design the tables.
I have many types of products
Jeans
Tshirts
Dresses
Which have many of ...
1
vote
1answer
76 views
How do auto generated stories/news articles work?
So there seems to be a new trend of auto-generated stories, a concept which I am struggling to understand. For instance, this article seems to indicate that sports articles will henceforth be written ...
0
votes
0answers
33 views
Is Event sourcing a good fit for database sync (master-multiple-slaves)?
I'm looking for a good way to maintain in sync local sqlite databases that could be offline to a master one, for a invoice app.
Then I read about EventSourcing and Log structured storage and wonder ...
1
vote
1answer
83 views
is there a cleaner / simpler way to code this? [duplicate]
I have a web app that uses ajax to filter db results.
So if you have a list of 1000 widgets, that have IDs ranging from 1-1000, by typing numbers into the ID field, you can narrow your search.
...
2
votes
4answers
267 views
How to optimize the application with huge number of database requests per minute
I have to provide free demo of some service to end users in my application. Free demo could be of 30 mins, 1 hours, 5 hours etc. (predefined time) for a new user for one time only.
User can also ...
1
vote
1answer
121 views
Am I planning my database/backend correctly?
I'm an iOS developer and to be honest I'm not really looking to become a database expert right at this moment, but I do need to know how to properly plan out what I believe to be a pretty cookie ...
0
votes
1answer
106 views
How to structure programs that interact with databases? [closed]
I've just finished a book on MySQL and I'm in the infantile stages of learning to couple that with Java. I know that the technology I need to learn is called JDBC and that it essentially allows you to ...
0
votes
1answer
107 views
Making a database and related operators using files and JSON in java [closed]
I'm trying to write a program that reads operations from a file. these operators look like below :
CREATE TABLE student(id:integer, gpa:decimal, name:string, family:string,isMale:Boolean)
INSERT ...
0
votes
1answer
160 views
Using XML to store and edit data records in Java
I want to use XML to store data for an assignment .
In this Java assignment I'll get data from the user in form of lines in a file below
INSERT INTO student(id,name,family,isMale) VALUES ...
1
vote
1answer
29 views
Sequencing distributed tasks with a distributed DB
Background
I have two separate processes, WriteIt() and ReadIt(). One creates records, and the other processes the records in a DB cluster.
Once WriteIt() creates a record, it queues a ReadIt() ...
0
votes
0answers
34 views
Is Python Logging in a WSGI application a best practice a production environment?
I am trying to log my webpage access to a database. It is a requirement. It seems to be a difficult thing to do outside of Windows IIS, and I do not wish to use Python with IIS.
My options seem to ...
2
votes
4answers
266 views
why do people do REST API's instead of DBAL's?
At the past two companies I've been at REST API's exist for querying data via a web app. ie. instead of having the web app do SQL directly it calls a REST API and that does the SQL and returns the ...
2
votes
1answer
231 views
Integration testing and database connection string in app.config
I am working on a project where SqlConnection is created via a static method, lets say it's DatabaseAccess.GetSqlConnection(). This method reads the .config file to get the connection string and ...
2
votes
1answer
352 views
How should I handle database failures in a web application? [duplicate]
I'm developing a simple RESTful API using Go's Goji framework (although this question is language-agnostic), in which parameters from the URL are queried against a PostgreSQL database. Here's how it ...
0
votes
0answers
56 views
Abstracting the data in a relational database. [duplicate]
While working with data, which is in a relational database I came up with this issue. At first, I was just writing helper functions to retrieve A SPECIFIC data I needed for the current problem but it ...
