• Skip to main navigation
  • Skip to main content
  • Skip to footer
  • Portfolio
    • Java
    • DevOps
    • Data mining
  • Online games
  • Posts
    • Author: QubeDron
    • Author: SnailDog
  • Experiments
  • Contacts
  • Skip to menu toggle button

ScAlAn

Scientific Algorithms and Analytics

Category: Database

Docker MySQL Stress test

Task: Create environment to run series of read/write queries to real MySQL server. Before make real experiments I tried to…
Continue reading “Docker MySQL Stress test”…
Posted on: February 28, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

Fix import huge database into Docker MySQL container

When I tried to import dump file using mysql command I saw ‘lost connection’ or ‘server has gone away’ error……
Continue reading “Fix import huge database into Docker MySQL container”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 1 Written by: Alex

WP fix run site locally

WordPress has option(s) with site URL. To change them to new one use next SQLs: UPDATE `wp_options` SET `option_value` =…
Continue reading “WP fix run site locally”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

WP set category to post within SQL

I have a stored procedure and want put posts in the MySQL event to some category (such Archive). wp_term_relationships (object_id,…
Continue reading “WP set category to post within SQL”…
Posted on: January 24, 2020 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

Mongo DB: Sharding scripts

Configuration of few mongoDB servers to work as one:
Continue reading “Mongo DB: Sharding scripts”…
Posted on: September 7, 2016 Last updated on: December 23, 2020 Comments: 0 Written by: Alex

Bank bills database application

PP: Application for preparing bank bills
Continue reading “Bank bills database application”…
Posted on: September 16, 2015 Last updated on: April 6, 2023 Comments: 0 Written by: Alex

Bank bills database (Pro) application

PP (Pro): Application for preparing bank bills with addition functions
Continue reading “Bank bills database (Pro) application”…
Posted on: April 13, 2015 Last updated on: April 6, 2023 Comments: 0 Written by: Alex

Subway union database application

PP: Application for Subway Union
Continue reading “Subway union database application”…
Posted on: May 29, 2014 Last updated on: April 6, 2023 Comments: 0 Written by: Alex

Railway Union database application

PP: Application for Railway Union
Continue reading “Railway Union database application”…
Posted on: August 12, 2008 Last updated on: April 6, 2023 Comments: 0 Written by: Alex

RCKTO database application

PP: Application for Railway Center
Continue reading “RCKTO database application”…
Posted on: July 6, 2008 Last updated on: April 6, 2023 Comments: 0 Written by: Alex

Recent Posts

  • Alternative js log from devices without access to console
  • Configure .htaccess file for React app located in the subdirectory
  • Write jUnit test to check service with json files
  • Setup FTP server on Paspberry PI
  • Add autoformat java sources into your maven project
  • Add autoformat java sources into your gradle project
  • Create Accordion on html and js
  • Adding and removing users version 2.0
  • Adding and removing user
  • Java Script summer
  • Java Script summer weekend day № 1: Finding the largest word
  • Freecad: fasteners for curtains in the bathroom
  • Java Script Array modification and output

What’s ScAlAn?

Main activity of our co-working team is service to develop and support IT solutions.

Can we help?

We can offer professional development and support for your business.

You have an idea?
You want to make some improvement?
You want to implement?

Contacts

Email: info@scalan.com
Phone: +38 (067) 573-24-19
© 2025 ScAlAn | Using Modern WordPress theme. | Back to top ↑