Questions tagged [query]
Database and dataset queries, using existing query features with well identified criteria. If the criteria to find the data are unclear, the [search] tag is preferred.
74 questions
2
votes
3
answers
770
views
Dynamically transform EAV data into standard SQL table
I use MariaDB to store data using EAV model. I need EAV, because each attribute of each entity can have its own validity (validFrom, validTo).
For example, I have entity person and I track changes ...
- 277
0
votes
1
answer
413
views
How can I trace back the original table of a column?
New to a software engeneer job and I am kinda blocked on the way to go with my new project
To explain this in a scheme.
I have a source of data in a custom app that is for most part of the time the ...
- 111
1
vote
1
answer
137
views
What's the difference between MongoDB Query API and MondoDB Query Language?
So I've been trying to understand the difference between MongoDB's Query API and its Query Language but I haven't been able to find a definitive answer.
I've been reading the MongoDB Docs and it is ...
- 121
1
vote
2
answers
219
views
Minimizing queries on a database
I am working with a large dataset (~5GB) stored in a Google BigQuery database. My goal is to create a web app which works a little bit like an Excel spreadsheet where users start off by seeing the ...
- 19
2
votes
3
answers
4k
views
Where should "query" business logic be placed in Domain-driven design?
System description
This is a simple eCommerce application containing a Products inventory managed by an Admin. The Products in inventory/repository will show in the User App. Admin has the ability to ...
- 129
0
votes
1
answer
230
views
Why is there just one HAVING in SQL?
In SQL there is WHERE and HAVING: ... WHERE ... GROUP BY ... HAVING ....
Why isn't there multiple GROUP BY and multiple HAVINGs per SELECT statement like: ... WHERE ... GROUP BY ... HAVING ... GROUP ...
- 791
-4
votes
1
answer
256
views
Is it better (from a maintenance perspective) to dynamically construct complex SQL queries using Jinja or String concatenation? [closed]
Two possibilities. Which is better, with respect to readability, maintenance and clean code:
SQL injection can be disregarded.
Constructing complex parameterized sql queries using python string ...
- 5
2
votes
0
answers
174
views
Data Types Based Database
I was wandering if there exists some kind of database that organises data based on some declared type rather than tables or collections.
I'll try to explain better with an example.
Let's say I have ...
- 161
0
votes
2
answers
245
views
Is all permutations of a string a good way to index full text search?
I am writing an application to be used as a local disc documents store similar functionality to Firebase or MongoDB. The gist of how it works is a column hash table.
For example:
Say I have a user ...
- 133
2
votes
0
answers
381
views
Use model instance to access model's manager 'objects'
In the Django documentation it's mentioned that Django managers are accessible only via model classes rather than model instances to enforce table and record level operations. What are table and ...
1
vote
8
answers
943
views
Is there a way to prevent developers leaking data while they are developing?
I am working with a startup company for a while now. They have been affected by some reckless developers in the past. One area they want a real and immediate improvement is when they assign a task to ...
- 127
0
votes
0
answers
28
views
Efficiently querying for a set of objects for price comparison
I am designing a system where a user can input a budget and a query returns to them sets of objects that they can afford from different vendors. The system has 100s of different combination types (i.e ...
0
votes
1
answer
67
views
Horizontally Scalable Streaming of SQL Query Results
I have a service that runs queries on a database and gets (potentially) large number of rows. I also have services that can export a given set of rows to csv, xlsx or pdf etc. I have separate export ...
- 189
1
vote
1
answer
290
views
Private class in ORM Repository?
Is this a code smell?
I have a repository which connects to a SQL server. This repository uses Dapper to map the results to an object.
I have a method in this repository that checks a result, then ...
- 349
-1
votes
2
answers
335
views
How do job queues return results to UI?
I am working on an app that will run queries and return results to UI. However, these queries can take a long time to finish so I should not wait for the result. As far as I know, people use task ...
- 189