CyberX

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) {

		e.preventDefault();

		$.scroll();

	});

	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.

DBX ABQ JSON Cache
DBX ABQ JSON Cache

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.