Maximum table size for a MySQL database

I once worked with a very large (Terabyte+) MySQL database. The largest table we had was literally over a billion rows. It worked. MySQL processed the data correctly most of the time. It was extremely unwieldy though. Just backing up and storing the data was a challenge. It would take days to restore the table … Read more

if(false) vs. while(false): unreachable code vs. dead code

The JLS section on unreachable code explains the rationale. Essentially, Java normally shouldn’t use conditional compilation like C routinely does with #ifdef, but there are some situations (such as debugging, and in particular backward binary compatibility) where allowing the compiler to entirely strip out code is needed, and so the specific construct if(false) is permitted … Read more

How can I implement my own code outline layout in vscode?

Okay, my request is now solved. The CodeMap extension, is basically the extension I’m looking for. I followed their guide on https://github.com/oleg-shilo/codemap.vscode/wiki/Adding-custom-mappers I created a custom dedicated mapper “mapper_X.js” saved it to an arbitrary location, and in my vscode user-settings I pasted “codemap.X”: “mylocation\\mapper_X.js”, (as described in the github guide). I then opened up a … Read more

Angular 6 add items into Observable

If this.contacts is an Observable of list of objects (contacts: Observable<Items[]>) and you want to make some changes to that list, you can simply use tap: import { tap } from ‘rxjs/operators’; this.contacts.pipe(tap(usersList => { usersList.push(newItem); })); But if you want to make another request to the server and merge these lists, you can use … Read more

Why clang-tidy suggests to add [[nodiscard]] everywhere?

This option is apparently “modernize-use-nodiscard”, so you can deactivate that if you prefer. It should be noted that the rules this option outlines are not the rules the C++ standard committee themselves use for when to apply [[nodiscard]]. Those rules being: It should be added where: For existing API’s not using the return value always … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)