<1/4>

“No Bugs” Bunny

unnamed.png

“No Bugs” Bunny
Sarcastic Architect

Hobbies: Thinking Aloud, Arguing with Managers, Annoying HRs, Calling a Spade a Spade, Keeping Tongue in Cheek

BB_userpic_0012.png

Once upon a time, in a rabbit outsourcing warren of Bunnylore, there was a young software developer bunny. And as a developer, she has had one very unusual treat: she was obsessed with eliminating all the bugs she can get his forelegs on. So, it is not surprising that her friends called her a “No Bugs” Bunny (or simply “NoBugs”).

Later on, she grew up, so she decided that “Bunny” in her name has became inappropriate (not to mention potential arguments with Warner Brothers), so she has asked all her friends to call her “No Bugs” Bunny. She has made a career as a team lead and software architect, and they lived happily ever after.

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

Historical Data in Databases. Audit Tables. Event Sourcing

November 21, 2016 by “No Bugs” Bunny

Herodotus writes history... in binary and to Database

Quote:

99% of reporting requests and 99.9% of analytics is purely historical

Another Quote:

Information within the audit table should be sufficient to validate/justify current state

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

Read more

Choosing RDMBS for OLTP DB

November 14, 2016 by “No Bugs” Bunny

Multiple Connections vs Single Connection

Quote:

As the RDBMS keeps modifying its tables – the tables gradually degrade

Another Quote:

As we can see from the table above – choosing your RDBMS it is not as easy as it might seem.

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

Read more

Ultimate DB Heresy: Single Writing DB Connection. Part II. Gradual Scalability. All the way from no-scale to perfect-scale.

November 7, 2016 by “No Bugs” Bunny

Multiple Connections vs Single Connection

Quote:

And after this split of USERS table, the system has achieved perfectly linear scalability.

Another Quote:

Start with a simple single-write-connection DB, with reporting running off the same DB

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

Read more