Docker image support for sqlite

[brenchley3w]

I have been testing adding a service using "peterknut/adminneo" in my docker stacks to add support to the underlying databases many apps use. The SQLite driver support seems to be missing from the dropdown selection.
Working great with the MySQL and PostgreSQL I have used.

[peterpp]

I've just added support also for SQLite.

[brenchley3w]

Thank you Peter,
Super fast response and now SQLite works perfectly. I just used a bind mount for the database.db such as below with mealie recipes
volumes:
- ./mealie-data/mealie.db:/var/www/html/mealie.db

As these sqlite docker stacks usually only ever have access to one .db file and there is no NEO_SERVERS variable I also tried a little cheat where I override the supplied adminneo-config.php. This is to save typing the name and just clicking login
volumes:
- ./adminneo-config.php:/var/www/html/adminneo-config.php

<?php
// Define configuration.
return [
"navigationMode" => "dual",
"preferSelection" => "true",
"colorVariant" => "blue",
"servers" => 
	[
		[
		"driver" => "sqlite", "name" => "mealie-db", "database" => "mealie.db", "config" => ["defaultPasswordHash" => ""]
		],
	],
];

Great project going on here 👍

[peterpp]

I also tried a little cheat where I override the supplied adminneo-config.php

This is indeed a working solution 😉

there is no NEO_SERVERS

Do you have any suggestion, how to nicely pass the complex array? Each record in servers can have up to 7 parameters + custom key. And config parameter is again an array.

[brenchley3w]

Hi,
I am afraid my php coding is pretty much useless. I tried adding a new "NEO_SERVERS" variable to the compose.yaml and then to use and parse it by copying , binding and modifying your original container adminneo-config.php. I failed. Hence I wrote out a simple override config instead.
The 7 parameter array and a sub array to boot , some populated, some not :- Maybe a plugin approach where a docker variable triggers the include of a php file that sets up the environment initially might be simpler. User supplies their own servers block?

Maybe some php guru can help with a more elegant solution? Now I am operational with adminneo both in full web LXC LAMP container and also in docker I will try to fiddle with some php a bit - I am coming from a long way back though :)