RevolveR CMS v.1.3.8 update

I was done testing new caches released in DBX engine and fix some bugs in RevolveR CMS.

For now MySQL queries cache by default segmented into parts via chunks to improve performance and memory usage.

Added new jump to top animated button into core template, fixed AMP links issue and added some security additions in .htaccess.

RevolveR CMS
RevolveR CMS

RevolveR CMS v.1.3.8 update availible on GitHub.

How to make simple scroll top jumper via RevolveR

So. This is a small tutorial how to create simple animated scroll to top button via RevolveR frontend library. Example you can see on this site when you scroll window. When scroll position takes 40% of Y axis the jumper are shown with animation.

Code below creates this scroll to top JavaScript animated button:

// charging weapons with namespace
const revolver = new Revolver('$');

$.dom('.jumper', 'del');

// jumper
$.dom('div',"new|after|body", {
	html: '<i  style="display: block;position: relative;top: 20px;color: #fff; font-size: 25px; text-shadow: -1px -1px 2px #000">^</i>', 
	attr: { 
		style: "width:60px; height:60px; text-align:center; display:block; position: fixed;bottom: 30px;right: 30px;background: rgba(0,0,0,.5);",
	class: "jumper"

	$.event('.jumper', 'click', function(e) {




	window.addEventListener('scroll', function(e) {

		if( $.curOffset[1] <= $.sizes[1] * 0.4 ) {

			$.dom('.jumper', 'animate', ['opacity:0:500'], function(e) {
				$.dom('.jumper i', 'animate', ['top:-50px:300:pulse'], function(e) {
					$.dom(".jumper", "style", ['display:none']);

		else {

			$.dom(".jumper", "style", ['display:block']);
			$.dom('.jumper', 'animate', ['opacity:.9:500'], function(e) {
				$.dom('.jumper i', 'animate', ['top:20px:300:pulse'], function(e) {});


RevolveR DBX v1.1.2:: implement cache partitions

Yo. Today I release new version of RevolveR DBX engine thats supports for now cache segments based on static partitions in JSON format. You can configure how many chunks will be used to split static caches. If rows count are around 0-2000 per table you can adjust $sql_cache_segments value to zero. Also you can configure cache segments for 5 to default for many rows count.


Cache partitions updates automatically after every database change such as delete, insert, update, inject queries.

Now RevolveR DBX under testing and I need some time to update RevolveR CMS code.

Acer Nitro 5 AN515-42 BIOS v.1.1.2 update

Today I was check for updates windows 10 and find new firmware update from Insyde Corporation for my Acer Nitro 5. Perhaps windows now updates BIOS automatically without any third party software.

UEFI BIOS firmware device in Windows 10
UEFI BIOS firmware device in Windows 10

For installing the software need reboot and pluged in power adapter. In devices section after update we can see new device named firmware.

SQL select all distinct notes

From start of coding RevolveR CMS I have two small questions: how much memory use PHP and MySQL when we use SELECT * condition and how long it executes.

For experiment I use SELECT * MySQL query condition in geting RevolveR statistics engine. For now collected around 66611 rows in one table with browsers data thats outputs in interface by select all and plain cycle filtered statistics only for daily usage. It tooks only 1.2Mb memory and execution time is around 0.6 seconds.

Hosting parameters is unknown because I use dedicated hosting plan for 5$ per month. By hosting plan avalible only 128Mb memory for PHP accelerator and I can calculate how many monthes I can use SELECT all instruction to show SEO statistics. It's only around 10 years with attendance of 100 unicum visitors per day.

Perhaps PHP core algorithm have no bad optimization engine and I have to code collecting statistics in dedicated tables for every month or week. It's a perfect guarantee of memory overload protection.

So. In next updates will be released more flexible collecting of statistics and flush interface for cleaning stats.

Next additions I have to release is a JOIN and UNION SQL query combining algorythm for DBX engine with partitions based file cache in JSON statics. It's extends framework(yes, RevolveR CMS goes to be a framework) scalability and usability of array based querys language.

New Windows 10 light theme

Yesterday I was join into Windows Insider builds testing programm and get new Windows 10 installation 1903 thats present new light theme for Windows 10 interface.

Windows 10 desktop with Light theme
Windows 10 desktop with Light theme

It's beautifull and very elegance for me and I happy with only replacing start button menu with Classic Shell addon thats back classic Windows 7 start menu because I don't like live squares and alphabetic sorting.

To get new Windows 10 builds with light white interface theme and test new Windows 10 feutures you only need to join with you Microsoft ID into desktop, enable developer mode from updates settings and request to join in Insider testing programm. After reboot check updates for new releases and start download fresh Windows 10 build.

My new Acer Nitro 5 with APU AMD Ryzen 5

For some reasons I cant continue work under Revolver CMS and other solutions in normal mode because I have not any performance and equipted hardware for it but now I buy new notebook for gaming and development.

Acer Nitro 5 AN515-42
Acer Nitro 5 AN515-42

Ok. Now I have new Acer Nitro 5 AN515-42 with APU AMD Ryzen 5 2500U, discrete graphics Radeon RX 560X and big wish to install Mac OS again.

Fortunately most hardware are compatible to Mac OS natively instead of AMD CPU Ryzen, AMD AHCI controller and WIFI card. Radeon RX 560X is under native compability to Mac OS Mojave and High Sierra.

Yesterday I was download patched for AMD systems Mac OS High Sierra installer and boot it sucessfull on Acer Nitro 5. Fortunately all hardware instead of AHCI controller and WIFI card are detected successful. We have big problem with HDDSSD detection because we have only one way to use incompatible drive controllers - it's very old AHCI Port Injector kext that supports only Intel controllers. My system have AMD AHCI controller thats not even have a special kexts and it only remains to hope that in the future somebody will write this driver.

Now I think I have to buy USB 3.1 Type-C external SSD and install system here. It variant is faster for 100 Mbit per second for read and write than traditional HDD and maybe I get stable Mac OS working from external drive.

What about Acer Nitro 5 under Windows 10? It most be more speedy because AMD APU have no issues with spectre and meltdown but it's not true. Windows 10 is slow and ugly instead. I play DeusEx Mankind Devided on Radeon RX 560X and it have small freazes, Mafia 3 gameplay is perfect thats talks about Acer Nitro 5 is not bad choice. So, I'm pleased with the price 753,37$ and bundle of APU Ryzen 5, graphics Radeon RX560X, 8Gb memory DDR4 and 1Tb HDD with one free slot for M.2 SATA SSD.

Before I install Mac OS to external USB 3.1 Type-C Generation 1 SSD I have to write about system stability and speed of work. Works under RevolveR CMS and RevolveR frontend will continue after some time(I can't work under this fucking Windows 10 because this is peace of shit!).