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.
75 questions
1 vote
3 answers
285 views
How to pass arguments of a complex search in RESTful API request params
I’m building an app that lets users manage data across multiple tables. I also expose an API so they can fetch their data and process it in external services. I’d like to enhance the API to support ...
0 votes
1 answer
537 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
2 answers
235 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
0 votes
1 answer
251 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
2 votes
0 answers
183 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
2 votes
0 answers
402 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 ...
0 votes
0 answers
39 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 ...
1 vote
1 answer
306 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