2,333 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
1
vote
4
replies
94
views
Oracle 19c: Best approach to optimize an API that repeatedly joins very large tables for count, pagination, and data retrieval
I'm looking for advice on the overall query design rather than optimization of a single SQL statement.
Environment
Oracle Database 19c
Large OLTP database
API is executed for a single tenant (:...
- reputation score 1
Best practices
0
votes
0
replies
43
views
Racing wheel. Force FeedBack. Simulation of real behavior
I’d like to learn more about this aspect. I recently bought a steering wheel and found that it isn’t supported very well in games (MOZA R3). I’d like to know how different games transmit data for ...
- reputation score 3
Best practices
2
votes
1
replies
93
views
What are the best practices for structuring REST API error responses in Node.js applications?
I’m currently building a REST API using Node.js and Express, and I’m trying to understand the best way to structure error responses for both frontend developers and long-term scalability.
Right now I’...
- reputation score 1
Advice
0
votes
2
replies
105
views
Standardized API design for music streaming service?
I'm writing a music streaming service, and I was wondering if there was an API design that a client or more could interact with.
I want to use an existing desktop and mobile client, and I could make ...
- reputation score 1
Advice
0
votes
2
replies
169
views
Designing a Python API: list of coordinate tuples vs separate parameters?
I created a Python toolkit called `cartons` that wraps RoutingPy and OSRM.
Currently, my API looks like this:
cartons.route(lon1, lat1, lon2, lat2)
For version 1.2.0, I want to support multiple ...
- reputation score 1
Best practices
0
votes
5
replies
110
views
Custom vs standard exceptions in Python library design: when to use which?
Should I use custom exceptions in my library or just standard Python exceptions?
I'm building a Python library for video processing and I'm uncertain about exception handling design. Specifically, I'm ...
- reputation score 47
Tooling
0
votes
0
replies
54
views
How to embed or connect a web application to an existing 3D virtual environment (like Minecraft or similar) via API?
I'm building a React/TypeScript web platform and want to connect it to an existing 3D virtual environment — similar to how Craigslist integrated with Google Maps around 2003 (data from one platform ...
- reputation score 1
Best practices
1
vote
3
replies
106
views
Is Semantic Versioning (SemVer) actually useful for an internal, single-instance backend API?
I am debating whether to adopt SemVer (Major.Minor.Patch) for our internal backend API. While it is the industry standard for libraries and public APIs, I have doubts about its practicality in a ...
- reputation score 1
Best practices
0
votes
0
replies
68
views
Return type of a mutation which streams back data in GraphQL
Intro to the Problem
So imagine you need to have an API which should stream back a video/audio file, what would be the return type? If you have an example written in NodeJS or any other programming ...
- reputation score 850
Best practices
1
vote
2
replies
47
views
Dynamic PATCH route vs. one PATCH route per user profile field
I just want to ask about this design issue I just encountered when I'm coding this edit-profile part for the user. I'm deciding on whether I should or should not individually code the patch routes, ...
Best practices
2
votes
7
replies
154
views
What's the best way to handle a callback (wiith named type) that might be unsafe if misused?
I'm designing an API that provides a type for which the user provides both a value, and a function that's supposed to run on that value – an example of the same design from the (unstable) Rust ...
- reputation score 2771
Score of 0
2 answers
110 views
What are safe patterns for Service A to consume data from Service B without direct DB access? [closed]
I’m looking for practical ways to let Service A get the data it needs from Service B without querying Service B’s database directly. I’m not very experienced with distributed systems yet, so I want to ...
- reputation score 1
Best practices
0
votes
1
replies
38
views
API Design for test-project
rn i'm making a test project in Spring framework for applying for an internship at a company. They requested to implement a simple bankcard managment system that "common" users and admins (...
- reputation score 3
Best practices
0
votes
2
replies
76
views
REST API pagination specification
Is there a specification defining pagination in the REST API (I'm particularly interested in cursor base pagination)?
For example, such a specification exists for GraphQL, but I haven't found one for ...
- reputation score 1798
Best practices
0
votes
2
replies
61
views
Is it normal to send a JSON response with a list of objects where the properties of the objects differ based on their type?
My client has requested that I provide a response from my API that looks like the following:
{
"entity_type": "company",
"registered_date": "2020年01月01日",...
- reputation score 173