PostgreSQL on Endpoint

Endpoint
1

Hey GHI,

You know what would be so cool?

PostgreSQL on Endpoint! That way, we can run a real (as in not SQLite) RDBMS that Asp.net Blazor and other tech stacks support!

image
image640×660 47 KB

2

I would google how to install Postgres on Linux and see if Endpoint supports the commands necessary to install. If not ask for the needed commands . I thing yum is needed?

3

Yeah, yum, and a lot of stuff is needed, such as the compiler for whatever they customise in Endpoint. GHI would be the only one capable of compiling Postgres for endpoint now. That would be awesome. Also, I said Postgress, not MariaDB. Both are fine, but I want Postgress.

4

Does the existing arm32 build not work? I am going to presume not since you are talking about building an image. I don’t have my Endpoint running in front of me, but I thought it already had a package manager on it (apt?)

GHI would be the only one capable of compiling Postgres for endpoint now.

It’s possible for us mere mortals to build stuff like this, provided you don’t need GHI’s kernel root (can’t say whether postgress requires that)

The compiler issue is an easy enough one to fix. See: Calling native code on the Endpoint

I think there’s a much bigger issue, and that is one of mismatched scale. Postgres has a pretty big footprint and may not leave much of your board left over for doing anything else, if it fits at all.

Aside from being easier to work with at dev time, are there runtime use-cases that the more compact dbs can’t solve? That’s a rhetorical question, of course - you know your requirements.

5

There is no package manager on Endpoint; I tried.

I/we want to leverage existing codebases and skills from business application development onto Endpoint, which is the pure reason for having Postgress SQL. It doesn’t matter if there are 2 or 3 Endpoint chips on the same board: 1 for the DB, 1 for the core application, and 1 for the webserver. The biggest selling point is being able to start the application in 1 second after power on.

This reminds me of another question I have…

6

We will give it a try, if it is important for users or your project needs it.

Vote here so I can easily get an approval :)).

3 Likes
7

Shoot… I should really have made those 10 other fake accounts. :rofl:

Having a real RDBMs on endpoint solves a bunch of other problems. Now that I’m splitting the function, I will use an RPI for the database and figure out how fast I can marshal data via IP/CAN,