×

Arcler – IT consulting, App Development and Software Services

Arcler can help you or your business

1 Boost sales

2 Train your staff

3 Have Apps

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

Making open-source work for you and for your business

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...

FORGOT YOUR DETAILS?

CREATE ACCOUNT

Drop All Tables Of MySQL
Looking for a short way to drop all tables of a MySQL or MariaDB database? This is a quick tutorial showing how to delete all tables of a MySQL / MariaDB database instantly bypassing the foreign key constraints in a couple of easy steps in Navicat.

What makes a website great?

Responsive web design example
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.
Sakila web - Editing film record (screenshot) from sakila database
This article will demonstrate how to rapidly develop a database-driven AJAX-based enterprise-class web application featuring the key Java EE 7 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.
In this article I will describe how to switch your WordPress-based web site to SSL or TLS so that its web address will be preceded by https:// rather than http:// no matter what when a user types in its address in the URL field, or a search engine robot came over to index or re-index the site. I will try to be brief and explain all in a few, simple steps while trying to avoid looooong and boring explanations as much as possible. 1. Get an SSL or TLS Certificate, and have it installed on your web domain. 2. Configure your WordPress installation to use HTTPS rather than HTTP: 3. Update your site or blog's URL either from within WordPress Admin Dashboard > Settings > General or from the database
backing up Wordpress conceptual image
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.
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.
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.
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, this book can be read from cover to cover, or simply used as a reference guide for any problems you encounter.

The book features ‘work along’ tutorials, tips, and tricks, some of which will surprise you by revealing features of Navicat which you may never have known existed – features such as drawing E-R diagrams, generating database tables from them, or reverse-engineer a database for vice versa, designing functions and stored procedures, event triggers, creating batch jobs, scheduling them, and even more...

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.

TOP