×

Arcler – App Development and Software Services

Arcler can help you or your business

1 Boost sales

2 Train your staff

3 Develop 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

What's Up?

Get Informed and Have a Say!

CodeIgniter Wizard – a new PHP CRUD Code Generator from Ozar

CI Wiz logo
CodeIgniter Wizard is a PHP developer utility / rapid application development (RAD) tool which helps quickly generate an advanced starting point for MySQL database-driven web applications with administrative interfaces. By having CodeIgniter Wizard generate common boilerplate code for database-driven CRUD operations with both front-end and back-end components with a simple, intuitive, GUI-based Mac app, you can save weeks, even months from your routine coding time.
Read more
No Comments

New Data Modeling Capabilities of Navicat in Action

Finished Logical Data Model in Navicat
Navicat comes with an incredibly responsive and elegant user interface design with improved usability, and it has been enabling users to get a visually appealing and semantically precise data models from their databases for almost a decade now. Released in November 2019, Navicat 15 (and Data Modeler 3.0) has some nice surprises in store, with an even more improved data modeling capability. You can now design generic data models and then convert them for a specific database platform. Together with an accurate field type prediction feature and unlimited undo/redo capability, it reduces design and development time, and offers a quick and efficient way to create and edit your table/view structures. In this article, I will show you how to design a simple data model with two entities in Navicat 15 from scratch, and then how to automatically create tables and fields from this model in a newly created blank MySQL database.
Read more
No Comments

Dropping Tables of a MySQL / MariaDB Schema All At Once

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.
Read more
No Comments

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.
Read more
No Comments

How to rapidly create a full-fledged Java EE 7 web application in less than 15 minutes

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.
Read more
No Comments

Switching your WordPress Site to HTTPS

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
Read more
No Comments

2 Ways to Back up your WordPress Files and Database Manually with a few clicks and steps

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.
Read more
No Comments

Get a dump of your remote database in minutes with Navicat

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.
Read more
No Comments

How to define a remote server connection in Navicat to your WordPress blog’s MySQL database on your web host

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.
Read more
1 Comment

The Book of MySQL Management and Administration with Navicat

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

Read more
No Comments

PHP CRUD Code Generator


The simple, intuitive and powerful rapid web application development tool and CRUD code generator for the Mac. CI Developers want to delegate their routine PHP boilerplate coding tasks to this powerful RAD tool.

Discover »

Navicat Book

Recent Stories from our Blog

Archives

GET FREE ASSESSMENT & FREE CONSULTING

Please fill out the following form, and let Arcler help you with a suitable solution for your software consulting needs.

TOP