Disclosure: On this site you won’t find specific advice on “how to call function xyz()”. Interpreting C++ ARM and #pragma dwim is also out of scope.

We’re treating our readers as intelligent beings who can use Google and/or StackOverflow, where all such specific questions were answered more than once.

What you will find is opinions, more opinions, and even more opinions on all the aspects of software development - and with a large chunk of them based on real-world experience too.

Your mileage may vary. Batteries not included.

Gradual OLTP DB Development - from Zero to 10 Billion Transactions per Year and Beyond

December 13, 2016 by “No Bugs” Bunny

10 transactions per second to 10K transactions per second

Quote:

to make an efficient representation usable for OLAP – we need to modify our data on its way to OLAP replicas

Another Quote:

Each of the DB Server Apps is a replica master, but all replica targets are within the same Replica DB

Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisionsDistributed systems(Re)Actors

Read more

Facelift for ‘No Bugs’ – Take 2

December 7, 2016 by “No Bugs” Bunny

BB_userpic_0013b.png

Some time earlier, we have conducted a poll to see which of “No Bug” faces our visitors like better. Unfortunately, results were inconclusive – so, we decided to run the poll again (and promised to do it on Kickstarter too), adding the third face to the mix. Here it goes – your vote for a […]

Filed under: OtherAnnouncements

Read more

Representing The Same Data Structure in SQL and NoSQL (from Classical Codd-style SQL to Key-Value NoSQL with SQL-with-XML and Structured NoSQL in between)

December 5, 2016 by “No Bugs” Bunny

SQL Bindings Compiler

Quote:

while duplication MAY indeed improve performance – undue duplication also MAY hit performance pretty badly

Another Quote:

NoSQL will usually call for another denormalisation on top of what we’ve described above for SQL-with-XML.

Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions

Read more

OLTP. Compiling SQL Bindings.

November 28, 2016 by “No Bugs” Bunny

SQL Bindings Compiler

Quote:

If we’re speaking about millions transactions per day over just a few hundred of different SQL statements – compiling those statements a million times (instead of a few hundred times) will be a dramatic waste of resources.

Another Quote:

Once upon a time, I observed the largest C++ file in my career – it was a 30’000-line file(!) consisting merely of ODBC bindings (and that was just for 300 or so SQL statements)

Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions

Read more