Is there a simple database app which works well on mobile and is self
hosted?
reddit / selfhosted

----------------------------------------------------------------------
ReactiveMatter · 2023-10-08 07:10

I need a simple app to maintain a database online which can be edited
and viewed by other authorized users.

The important thing is it will be mainly accessed by mobile. The data
is sensitive so it needs to be self hosted and open source as well.

Only CRUD and search operations are required.

----------------------------------------------------------------------
Matt_0550 · 2023-10-08 07:25

You can use Memento Database available on Android and IOS. You can
create a global account and share password

----------------------------------------------------------------------
Matt_0550 · 2023-10-08 07:26

Its also available on windows and macOS

----------------------------------------------------------------------
ReactiveMatter · 2023-10-08 07:31

Looks good. Is there self hosted version of this?

----------------------------------------------------------------------
Matt_0550 · 2023-10-08 07:32

Unfortunately not, as an alternative you could host a mysql server and
find some app to view data from mobile. You can also always create a
simple Dashboard

----------------------------------------------------------------------
ReactiveMatter · 2023-10-08 07:38

This is what I want. But end users are very technical. They would need
simple forms to access. I know it is not a big task and should a 3-4
task, but I am not very good in authentication, and do not want to
implement any solution which may be vulnerable.

----------------------------------------------------------------------
Ashiqhkhan · 2023-10-08 08:38

Just build using flutterflow or tooljet, appsmith using google sheets
as DB which is secured using google login if its just MVP or use
postgress db. All open source except for flutterflow.

----------------------------------------------------------------------
ReactiveMatter · 2023-10-08 08:46

Will try

----------------------------------------------------------------------
lilolalu · 2023-10-08 09:38

Depending on your skillset that sounds very easy to achieve with a
regular MySQL and your favourite web framework, i.e. ruby on rails, or
python flask or php symphony. If you cannot do it yourself, you can
hire someone in Fiverr to program you a simple webUI for your
database, just fill it with random data for the development to avoid
privacy problems.

Run development in a docker container, put traefik in front as proxy.
Run authentik with traefik forward auth for security.

https://goauthentik.io/docs/providers/proxy/forward_auth

----------------------------------------------------------------------
ReinoutWolter · 2023-10-08 10:32

I would recommend [https://wip2p.com](https://wip2p.com) its a self
hosted social database. Very flexible, can store json or binary data.

All the demo applications are all mobile friendly.

Let me know if you want some assistance testing it out.

----------------------------------------------------------------------
ErvinBlu · 2023-10-08 11:35

There is a another way, install Symfony with API Platform Core,
connect it to a database and use it as a API Server, Symfony has built
in tools like auth and firewall, no need to write from scratch, you
then just need to build a simple Frontend to communicate with the
API/Backend.

----------------------------------------------------------------------
patrickhilker · 2023-10-08 15:18

Maybe Directus could help you. It is selfhostable.
https://directus.io/

----------------------------------------------------------------------
ReactiveMatter · 2023-10-08 16:04

Thankyou for the replies. I have found a [PHP-CRUD-
API](https://github.com/mevdschee/php-crud-api) for SQL. Will test it
if fits the case. Front end may be created seperately.

----------------------------------------------------------------------
Eggtron88 · 2023-10-08 17:14

www.pocketbase.io

----------------------------------------------------------------------
nuno6Varnish · 2023-12-04 16:13

For simple CRUD + Search you might not need to develop a full backend.
Checkout BaaS (Backend-as-a-Service) like Supabase, CASE...