Most active questions

Filter by
Sorted by
Tagged with
2 votes
2 answers
256 views

Why do database protocols use fixed endianness instead of native server endianness?

Most database wire protocols mandate a specific byte order for multi-byte integers: PostgreSQL: big-endian (network byte order) MySQL: little-endian MongoDB: little-endian (BSON format) OracleDB: ...
4 votes
2 answers
362 views

Backup for an Android offline password manager

I am building an Android password management app, where passwords are locally kept for security reasons. The network endpoints are only for creating an account, email verifications etc. I want to ...
1 vote
1 answer
189 views

How to manage connection strings for CI/CD and local debugging that works for .NET Framework web apps and desktop apps?

We want CI/CD to inject the production connection string into a .NET Framework app.config during deployment. In source control, we only want test/staging DB connection strings. Developers should ...
4 votes
3 answers
157 views

Does (possibly) failable destructor require to change invariant violation error handling?

First, I'd like to highlight my personal premise on error handling approaches in C++ (as it might be the source of confusion in the first place). C++ Standards, 2004 (Sutter, Aleksandrescu), item 68 ...
1 vote
3 answers
223 views

How can I introduce migration scripts to a team that has stopped using them?

In my working experience, I am into a situation in which the team has stopped using migration scripts for setting up the db. The team is fast paced focusing on business upon a 1-year old startup. ...
1 vote
2 answers
83 views

API design: handling multiple user account types

I’m designing a REST API where a single person can hold multiple account types. For example, one person might have both a CareProvider and a CareSeeker account. Each account type can have its own ...
-1 votes
0 answers
24 views

Why do we still create rest APIs? [closed]

I just started learning about the specification, but I still have some doubts about why GraphQL simply hasn't replaced REST since it was created. REST APIs are very inflexible and straightforward. ...
-1 votes
0 answers
39 views

Best architecture for looping audio playback on the web [closed]

Best architecture for looping audio playback on the web I'm building a simple web-based audio streaming system that continuously plays a long audio file (several hours in duration) in an infinite loop—...
0 votes
0 answers
24 views

Measurement of performance of Lisp code [migrated]

I'm trying to discern how much performance gains I would achieve by converting Lisp (SBCL) code to assembly language. The time function on SBCL keeps giving counterintuitive results even for trivial ...