Arcler – IT consulting, Software Development, Training and Business Services

Arcler can help you or your business

1 Sell online

2 Train personnel

3 Have Apps

For details, you can visit our services page, or contact us directly.

Making open-source work for you

By putting about a dozen of enterprise-class web applications ranging from accounting, CRM and HRM to DMS, BPM and project management, at your disposal, with on-premise or cloud hosting.

» Find out more...



What makes a website great?

Responsive web design example

A website is a visual communication of what you are, what you do and what you are offering, whether you are an organization advertising your business activity, products and services, or just an individual showcasing your digital work, interests or opinions on a particular subject.

Great web sites are the ones that deliver the best possible user experience so that as many visitors as possible feel like your website was built just for them, because they will also have found what they’ve been looking for. Furthermore, potential customers are leads generated by a great web site, as they would be the ones who know and remember about your business and your process after visiting your web site.

Determining the 3 elements of a great web site that has a strong purpose

If people were interviewed immediately after visiting your web site, what are the answers you would like to hear to these three questions?

  1. What will they say that they learned?
  2. What will they say was their dominant impression about your web site?
  3. And what will they do after visiting your web site?

These questions point to the three elements of a strong purpose of a great web site.

Arcler is an enthusiast of the latest trends in web design and technologies. Toward this end, we summarize the depending factors of a successful web site in five basic principles.

Sakila web - Editing film record (screenshot) from sakila database

In this article, we will show you how to rapidly create and develop a database-driven AJAX-based enterprise-class web application featuring the key Java EE 7 (Java Enterprise Edition) reference implementations like JSF 2.2 (Java Server Faces) coupled with PrimeFaces 5.0 UI component framework for JSF, JPA 2.1 (Java Persistence API), and EJB 3 (Enterprise Java Beans) making use of JTA (Java Transaction API). This will be a fully functional three-tier web application fully compliant with the MVC (model-view-controller) paradigm. For the model layer MySQL server will be used as the database server.

For this tutorial, you need JDK 1.7 or later (JDK 1.8 is recommended), a MySQL Server (we used version 5.6), an EJB-savvy Java Application server (for this tutorial we used Glassfish 4.1.2 bundled with the installation of NetBeans 8.2 IDE).

First and foremost, make sure that Java Development Kit 7.0 or later as well as MySQL 5.6 or later is installed on your computer or development environment, go to https://netbeans.org/downloads and get a NetBeans package (8.2 or later) containing at least the Java EE modules.

Overview of the application we will build: Sakila Web

Introduction to the Sakila Database

Sakila is a fictitious movie database similar to – what I call – a minimalist version of IMDB, and it features imaginary films, actors, film-actor relationships, so on and so forth. Sakila database for MySQL was initially developed by Mike Hillyer, a former member of the MySQL AB documentation team, and is intended to offer a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. Sakila sample database also serves to highlight key features of MySQL such as views, stored Procedures, and triggers.

You can download the SQL dump of the Sakila database here, in zip format.

Setting up the Sakila Database

You can refer to the documentation here in MySQL documentation archives to install the database on your dev machine. If you want to get this done fast, you could do this in Navicat which you can download for Mac, Windows (32-bit | 64-bit) or Linux (32-bit | 64-bit) directly from here.

Developing the Java Web Project

Defining Project Settings

Launch NetBeans, and then after it is completely loaded, from the File menu select New Project…

Screenshot of Netbeans - File > New Project...

Click to enlarge the screenshot of NetBeans > File > New Project

A wizard-like dialog box will appear, where you need to specify what kind of project you want to create. From Categories, select Java Web, then under the Projects, click Web Application, and then click Next. (more…)

Ambulance @ Parsons Green Incident Sept 2017

London was shaken this morning with the breaking news of an incident taking place near Parsons Green, an explosion in one of the tube train carriages on the District Line. The reason of the explosion is concluded to be a bomb placed inside a supermarket bag brought into the train.

Fortunately, nobody was killed, but there were a number of people who were injured. Most of those injured were believed to have suffered flash burns due to the fire caused by an explosive device.

The Met Police and New Scotland Yard have reason to believe that this was a terrorist attack. This turns out to be the third in a series of terror incidents taking place in London after the Westminster and London Bridge attack in 2017.

Arcler UK offers sincere condolences to all Londoners as well as the people of Britain, and condemns all terrorist activity not just in London, but all around the world.

Get well soon!


Backing up WordPress

Weary of backing up your WordPress site due to over-frequent updates? WordPress updates are coming up too often, and you never know what you’re really risking whether you do the update or not! This is why backing up the current working state of your WordPress blog or web site is essential. If you are a subscriber of the pro version of JetPack, or a user of a back-up utility plugin for WordPress, you might be doing just fine. But if you are reluctant to opt in for a paid tool or service like JetPack Premium or Professional, and not quite trusting to WordPress plugins which might get broken themselves for various reasons, including a possible unavoidable automatic version update of either PHP from the web host itself or an automatic WordPress update (the latter occurs as often as every other week) incompatible with the PHP version or settings of your web hosting server, then this article might be just right for you.

Case study: Maclord’s Mac Blog. This blog has been out there for about a decade now since the early days of WordPress when it was at version 2.x. It became out of order a couple of times due to poor maintenance, and the temporary abandoning of its owner because of getting fed up with maintaining WordPress rather than focusing on writing. Maclord had made a good start back in 2008, but after 2 years, it was left untouched for a long time. Incompatibilities between the version of PHP on its server and the version of WordPress versus some outdated plugins (which functioned just fine if neither WP nor PHP were not updated!) caused the entire site to come down with subsequent automatic and incompatible component updates, and yet, there was no proper back-up plan.

Today’s successful WordPress blogs and sites are not just those that overcome writer’s block and publish valuable articles, but also those that endure the continual change in software, and the underlying technology with a persistent commitment to its maintenance at the same time.

Lessons Learned

So what do we do when we see a news headline like the following?

WordPress 4.8.1 is available! Please update now.

Backing up your database in three easy steps:

If you prefer to get things done quickly, and practically with GUI-based (i.e. Graphical User Interface) easy-to-use tools, that’s where Navicat comes exceedingly handy in accomplishing anything database-related. Of course there are other tools like phpMyAdmin available for free for those who are a bit more ‘techie’, and who wouldn’t mind getting past the learning curve to get used to the tool. However Navicat is one of the few tools which helps get things done in fewer steps with a few clicks, and it is extra handy when you are managing multiple databases on different servers and locations – an extra bonus score especially if the database servers consist of a set of heterogeneous platforms.


Database dump to sql file with Navicat

In this part of our mini tutorial series on database management, we will show how to dump a WordPress blog database to a file in .sql format using Navicat. This is one way to export the entire database in a matter of minutes.

No web-based control panels, and no phpMyAdmin or any tedious work, but right from within one application where you manage all your databases if you are using a powerful yet easy-to-use tool like Navicat. The only one-time pre-requisite to this simple tutorial is that you need to have defined the connection settings your web host’s database server from within Navicat. If you haven’t already done so, check out this tutorial first on how to do so.

While in Navicat, start by connecting to the server where your database is located, by double-clicking the name of the server you had previously defined in Navicat. Expand the database listing in the tree-view by switching the tiny triangle-shaped icon, and right-click the name of the database. In our case, we want to back up our company blog database to a local file on a Mac.

Dump SQL file > Structure + Data from Navicat Screenshot

From the contextual menu(s), select Dump SQL file... > Structure + Data, and Navicat will prompt you to provide a name and location for the .sql file in which it will dump the entire database.

Wordpress Database Dump in NavicatFor this one, I type in “WordPress Database Dump”, leave the location to save, as Desktop, and click Save. A modal dialog box with a progress bar comes up indicating the state of dumping the data to the sql file. Initial gathering of information takes a while in the beginning, yet I’m in Europe, and the database server is in the United States.

Navicat database dump progress window screenshotSure enough, we verify the contents of the .sql file by opening it in a text editor like TextWrangler which is some sort of a Mac alternative to NotePad++ on Windows, and there we are:

Navicat-dumped SQL file opened in TextWrangler

In such a short time as 3 minutes, we have obtained an SQL dump of our entire company blog database (~ 50 MB) to a local file system on a laptop computer, directly from the MySQL server which is located overseas, using just Navicat.

Navicat Wordpress Database Connection

In the first of our mini tutorial series, we will demonstrate how to define a database connection in Navicat. In this case it is a MySQL database located on a Dreamhost server in the US which has a mirror of this blog.

Dreamhost is one of the web and cloud hosting companies preferred by Arcler, and aside from the great customer support, they have some cool features many hosting and cloud service companies still neglect at present, such as free SSL certificate issuing and installation, free version control system repositories, and SSH access.

Defining the hostname

First things first: we define a new hostname for the database server at the database hosting side beforehand.

Defining a database server name on Dreamhost

In this case, from the Dreamhost control panel, we define a new server name as mysql.arcler-it.com for the database server. Dreamhost leaves it up to the user what hostname(s) the database server shall have and you can define as many server names as you want for the same server.

Define additional database server (host) name in Dreamhost

Providing remote access privilege to database user

The next thing we want to do is to make sure that the database server accepts remote connections. For this, we need to grant access to the database user to connect to the server from a client (in this case Navicat) with our current IP address. The steps are illustrated by the following screenshot taken on the Dreamhost control panel:

Define database user privileges in Dreamhost

Defining the connection in Navicat

Now that all the access information for the database is clear, time to enter them in Navicat connection properties.

Whilst in Navicat, click the File menu and select New Connection… and then select the type and platform of your database. In our case we are using Navicat Premium which supports multiple databases and major platforms. We are dealing with a remote MySQL server at this time, however.

Next we define the properties of the connection as appointed in the previous section, and illustrated in the following screenshot:Defining a database connection in Navicat - part 2Finally we simply hit the “Test Connection” button, and a small round green light appears next to the button in the event of a successful connection getting established. After that all we need to do is to double-click the connection name we defined listed in the left sidebar pane, and we are done!

Screenshot of Navicat Premium v12 with a database connection established

Navicat Book Cover Photo

Master the tools you thought you knew and discover the features you never knew existed with this book.

Any database designer, developer or administrator who wants to accomplish both everyday tasks and more advanced actions with a few clicks or drag-and-drops can now do so using Navicat’s advanced tools and this book. Starting with the basics before progressing with advanced features, the book can be read from cover to cover, or simply used as a reference guide for any problems you encounter.

The only book ever written and published for Navicat at the time of this writing, MySQL Management and Administration with Navicat features ‘work along’ tutorials, tips and tricks about Navicat for MySQL. It even features some intermediate to advanced SQL tutorials. The book reveals some features of Navicat which you may have never known existed – features such as drawing E-R diagrams, generating database tables from them, or reverse-engineer a database for vice versa, editing foreign keys with only a few clicks, designing functions and stored procedures, event triggers, creating batch jobs, scheduling them, and more…

Available in both paperback (softcover) in print as well as various electronic formats such as ePub and Kindle, MySQL Management and Administration with Navicat is an ideal resource to master not just Navicat for MySQL or Navicat for MariaDB, and unlock its true potential, but also a great resource for mastering generic Navicat Premium features which you can use for Oracle database, and Microsoft SQL Server.

rcler & PremiumSoft shaking hands

On 26th January 2017, Arcler partnered with PremiumSoft CyberTech, Ltd as their reseller to add Navicat suite of products to Arcler’s software distribution portfolio.

PremiumSoft was founded in 1999 and develops a wide variety of applications for Windows, macOS (X), and Linux. Their team of software engineers is known for producing top-quality software and we maintain a stellar reputation for providing world-class customer support.

PremiumSoft’s research and development team works constantly to keep their products relevant in a rapidly evolving market. They also have an experienced customer support team devoted to building lasting relationships with Navicat customers. In response to customer feedback, they continue to provide award-winning products that address business needs.

Best Database Administration Solution 2016Navicat, the intuitive and cost-effective database tool for MySQL, MariaDB, Microsoft SQL Server, SQLite, Oracle Database and PostgreSQL development and management, provides easy-access to major relational database brands from different operating systems such as Microsoft Windows, macOS X, Linux, and iOS. It is also the winner of “Best Database Administration Solution” in 2016 DBTA Readers’ Choice Awards.

Navicat  increases the user productivity and lowers cost of ownership for related applications and technologies. In fact all PremiumSoft products have an intuitive user interface and a wide array of powerful features that simplify database management, allowing users to produce high-quality applications and databases quickly and efficiently with ease.

Navicat Data Modeler is a powerful and easy-to-use database design tool which helps users build high-quality logical and physical data models. Supports the same variety of database systems including MySQL, MariaDB, Oracle Database, Microsoft SQL Server, PostgreSQL, and SQLite.

In addition to these six database platforms, Navicat is also compatible with Drizzle Server, OurDelta, and Percona Server as well as databases in the cloud such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft SQL Azure, Oracle Cloud and Google Cloud.