What is a tool to build an offline GUI for a SQL database

LM21 1 Reputation point
2021-08-26T18:20:40.673+00:00

I want to build a simple GUI to member database of our smallish club. Today it is really Excel sheets which I have to import first.
I can write SQL searches like, who has paid his membership dues and so on, but others are also going to use it, and using it must simpler than writing SQL queries.
It must also be offline, anything with web will cause problems here.

SQL Server | Other
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Sam of Simple Samples 5,546 Reputation points
    2021-08-26T19:15:37.923+00:00

    First you can decide what database system to use. Current versions of Windows have SQLite. You can use the following to help you decide if you want to use it.

    I am not familiar with tools for non-programmer development of database programs. If you want to learn programming then I suggest finding a book about using C# and Entity Framework.

    0 comments No comments

  2. LM21 1 Reputation point
    2021-08-27T10:48:00.277+00:00

    Is C# and entity Framework a good way to use with SQLlite? I havn't heard of Entity Framework before. It looks like it is somekind of DB Add on for .NET. I don't remember if .NET had Database API without ADD ons. That is, is it needed.

    0 comments No comments

  3. Olaf Helper 47,436 Reputation points
    2021-08-27T11:28:13.147+00:00

    It must also be offline,

    How should that work? If an application have to work with data, then it have to access it in any way.
    Why not using one of that many cloud base database as SaaS solution, there are many around and some offers free database with some limitation, like database size?

    I havn't heard of Entity Framework before.

    Entity Framework is an ORM = Object-Relation (database) mapper, it's a kind of bridge between the relational database world and the object-oriented programming world; all on client side, not on DB side.
    https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping

    0 comments No comments

  4. LM21 1 Reputation point
    2021-08-27T11:54:14.703+00:00

    The database and GUI have to be in same machine. No need to put anything on the net.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.