Anvil App + RaspberryPi + Database

marcosandretavaresfe · May 15, 2020, 4:38pm

Hello,

Thanks to this tutorials:
1 - https://github.com/anvil-works/anvil-runtime/blob/master/doc/getting-started.md
2 - https://github.com/anvil-works/anvil-runtime
3 - https://anvil.works/blog/open-source

I can create my web app in RaspberryPi (Thats great )
https://anvil.works/build#clone:3NJCBG2T75UPVLXG=4PAG7VAKQK6ETQ3RSMFO2SKV

However, in Anvil IDE I add a Data Table, but when I open my app in my RaspberryPi, I dont have the Data Table.

I install psql command-line client.
I follow the topic : “Acessing the database” in the tutorial 2 above, and then this:

Can someone tell me what I miss ?
Thank you

Matthias · May 15, 2020, 9:14pm

You can take a look at your

anvil.yaml

file. There should be a section called

db_schema:

There you should find the definitions of your tables. Are they there?

marcosandretavaresfe · May 15, 2020, 9:23pm

yes

Matthias · May 15, 2020, 9:33pm

Then you should be able to start the app server with

anvil-app-server --app <app_dir> --auto-migrate

But the tables will be empty as it is a separate database. Just with the same schema.

marcosandretavaresfe · May 15, 2020, 10:03pm

I can start the server look:

the question is: i cant have acess to database like i have in Anvil IDE. I think i have install some more things but i dont know what

I fetching to the database strings to fill the drop down.

marcosandretavaresfe · May 15, 2020, 10:06pm

Should I have to install postgresql and create the table like I create in Anvil IDE ?

Sorry and never do this, i new in Anvil.

p.colbert · May 15, 2020, 10:14pm

Postgres is already built in. From https://anvil.works/blog/open-source:

Wait, don’t I need to set up a database?

Nope! The App Server comes with Postgres built in, and by default will set up a new, private database in the .anvil-data/ directory.

marcosandretavaresfe · May 15, 2020, 10:32pm

What I miss ?

I follow this, from Meredydd

github.com

anvil-works/anvil-runtime/blob/master/doc/getting-started.md

# Running Anvil apps locally

You can export any Anvil app from the Anvil Editor and run it on your computer using the open-source [Anvil App Server](https://github.com/anvil-works/anvil-runtime). 

You can also **build and deploy your apps in Anvil's cloud** -- by far the easiest way to build a web app. Build your app using our [online IDE](https://anvil.works), complete with drag-and-drop UI designer and autocomplete -- then [click one button](https://anvil.works/docs/deployment), and it's live on the web!

Follow this how-to guide to export an Anvil app from the online IDE and run it on your own machine.

All you need to do to run your app locally is:

1. Install the Anvil App Server
2. [Clone an Anvil app onto your local machine with git](https://anvil.works/docs/version-control/git)
3. Launch your app

## Set up your environment

### Dependencies

You will need to install the **Java virtual machine**. On Debian-based Linux systems (like Ubuntu and Raspbian), you can do:

This file has been truncated. show original

I dont understand.

stucork · May 15, 2020, 11:06pm

How did you populate your data tables in the anvil ide?

As @Matthias mentions.
The anvil run time will create datatables according to the same schema but they will be empty. You have to repopulate the data…

marcosandretavaresfe · May 15, 2020, 11:18pm

Ah Ok … basically I wrote their manually … thanks i will try

Matthias · May 16, 2020, 2:56pm

Hi @marcosandretavaresfe,
hope that worked for you. However, before you go further down this route, could you explain a bit, what you intend to achieve?
For instance, why do you intend to host the whole Anvil app server on your raspi? You can do this, of course, but why would you?
I am just asking cause you write that you are new to Anvil. And managing the whole app server on your raspi yourself is not really what I’d consider a beginner’s topic.

marcosandretavaresfe · May 16, 2020, 8:12pm

Im doing my final projet at University.
What Im trying to do is:

In my work (yes, Im studying and working at the same time) i have to many different PCBs that need to be tested.
What I’m trying to do is to create a box, inside it will have a RaspberryPi runnig a app (at first I think in PyQt5), and a touchscreen to control the app.
For each PCB (for start I choose 4) I create one python file to test if this PCB is good or not, and its working.

Now I want to create this app with Anvil. This app it will have to run this python files i create.
Thats what i want.

Of course, in future i will add more PCBs, so i need a database, i will need to have acess in my PC, so open the app on the network, and much more stuff that anvil has and its great.

Matthias · May 16, 2020, 8:37pm

Alright, I do not really understand why you need to run Anvil locally on your raspi, but you surely have your reasons.
As far as I understand it, you could just run all the PCB testing code with a python script on the raspi, send the results via Anvil uplink to the database, use this database for your app which is running under domain “whatever-appname.anvil.app” and access this from anywhere you want.

marcosandretavaresfe · May 16, 2020, 8:52pm

A Web app will give “more points” in the final evaluation its much better I have a app running in a browser, with a touchscrenn, thats it.

I will try to do that and you all people will help (i think)

PS: i forgot to say, that my box will need to be portable, so this is the main reason i need the Anvil app server … control it in local

Matthias · May 22, 2020, 10:10am

Hi @marcosandretavaresfe,
I understand, but the decision criterion for deciding whether you need to run Anvil locally is whether your box has an internet connection or not. It can be portable and still have internet connection. In that case their is no need to run it locally.
Another argument would be if you’d have huge amount of data that you would send to the DB. Then it might be as well be advisible to run locally.

marcosandretavaresfe · May 22, 2020, 10:26am

I dont have internet connection … this is for a factory, and there i have intranet not internet like i have in my home … the Pi cant have acess to internet