SbK state of the project

The server spin has been a hit. Its one of the most downloaded SbK spins, and takes less time to make than all the others. The 1125 release included the Apache HTTP server, but I am not done adding to the spin. I would love to have a configured LAMP stack. It likely wont be all inclusive of every possible option, but Apache configured for PHP and a working local instance of a MariaDB server.

I had a little free time. So far I have PHP working following the Arch Wiki basic libphp setup. Next is MariaDB. It will be noted in the release announcement to change the password from the default after install. I would like to add phpmyadmin, but the setup looks to be hard to accomplish automatically.

Any suggestions on other things to add are welcome. Especially easier options than phpmyadmin.

1 Like

Possibly a few scripts created to install packages for two/three/four of the most popular scenarios might offer some added versatility.


Maybe this:

It’s still phpmyadmin (with another name) but this comment looks at least promising:

(emphasis, mine)

It’s not in the Manjaro repo’s, but there is an AUR page;

Perhaps you can still glean something useful from it.


Non-Web based:

I don’t know how suitable these may be for the purpose; both are available from the repos:

  • DBeaver
  • MySQL Workbench (in repo)

Cheers.

I’m not sure if I can be all that helpful. My preferred Database for my needs is SQLite. If was going to develop any Web applications I’d be opting for a Python framework, such as CherryPy, which when I was using it, felt most like what I had been doing when I was Developing C# Web apps.

For Python Programmers who want to do Web applicaation development theres a great list of frameworks to choose from.including
Django
Flask
Pyramid

perhaps scripts to choose from those and or others.

That just gave me an idea for improving my media App, and perhaps getting my partner to use it, turn it into a web app.

Thanks for the suggestion. Since its for the server I want something web based in case the minimum iso without a desktop is installed, or its headless. Im going to give it a try.

1 Like

Adminer looks to be good to go. I did install it to /srv/http/ā€random named directoryā€/index.php for a little added security.

1 Like

I will look into it. I went with LAMP because I have used it in the past, so there was some familiarity. Which of these is the most common so I can try it first.

I actually do not know, those 3 plus CherryPy, which I use, appear to be the most used, by large installations.

I personally chose CherryPy because it required, as far as i could tell the least amount of setup, and I liked the documentation, and I could choose how I implemented my object model, also it reminded me of the C# web development model I was familiar with.

I’m afraid i can’t make much more by way Of recommendation.