Building an effective TKL App Base
There are many components to setting up an effective IT infrastructure. Different systems have different capabilities. This is one of the reasons I like the Turnkeylinux set of applications. They are very consistent in their operating model and it is possible to install them in to a wide variety of server environments. When installed, the main "outward" work of the App works well, but the Linux management is generally consistent between apps.
Each can be easily accessed via SSH, WebShell or Webmin interfaces. This gives a full range of capabilities as well as a reduntant and intuitive access approach. All those with Database backends come with, generally, the Adminer database access module with which most simple edits and explorations can be pursued.
But even with this installation capability and their excellent set of apps which surround there are things that you may want to accomplish. Further there is an excellent backup system built into TKL Apps, TKLBAM, with which it is normally possible to migrate an App between servers and server generations. Daily Security updates are de rigour.
For me, one of those things. are data-access via separate Database Clients. I happen to like both Navicat and FileMaker pro for database interactions and both systems can access TKL data if approached in a deliberate, security oriented method. The advantage to this of course is that you can very much streamlilne some of your interactions with your systems which are otherwise bogged down by assumed needs put forth by the app centric programming, and the somewhat limited Adminer Interface. (Do note that you can install PHPMyAdmin nd PSGAdmin (get the names right!) with a little extra work.
Server Platforms to which TurnkeyLinux Aps can be installed are wide and many. Nearly any computer, or Virtual Platform can be done quite easily. TurnkeyLinux also makes it easy to install to AWS (Amazon Web Services). For my part, I have found the best value and performance to be with Linode.com. I need to come back around to how I actually got my installs built, but once there they run like a charm. I will post a related article on making a Turnkey Linode install soon.
TurnkeyLinux's Web site can be found here https://www.turnkeylinux.org/