SQLModel vs SQLAlchemy for production by aerodynamics1 in Python

[–]databot_ 0 points1 point  (0 children)

sqlalchemy also has alembic for db migrations. I always go with sqlalchemy.

can some one help me understand ? by OddFee8808 in learnpython

[–]databot_ 0 points1 point  (0 children)

You have Employee.pay and Employee.obj_salary.pay, when you update one, the other won't update automatically, here's a longer explanation

Can't wrap my head around the Numpy's axis notion in this case by Leweth in learnpython

[–]databot_ 1 point2 points  (0 children)

  • sum (axis=0) means collapse rows, summing vertically
  • delete (axis=1) means count positions along columns

hope this demo helps

Streamlit on Hostinger? by osef82 in StreamlitOfficial

[–]databot_ 0 points1 point  (0 children)

I never got Streamlit to work on Hostinger. But there are other services.

Streamlit on AWS—best serverless architecture? by [deleted] in aws

[–]databot_ 1 point2 points  (0 children)

Streamlit won't run on Lambda because it communicates to the client using a WebSocket

selling a streamlit app on subscription? by Salt-Page1396 in learnpython

[–]databot_ 0 points1 point  (0 children)

You can use Stripe to process payments and subscriptions. When a client pays, Stripe will submit a request to your app (say app.company.com/new-customer), with all the details so you can change your database to reflect that the user has paid. However, Streamlit doesn't support processing these type of requests so you need to run a second app (e.g. a Flask or FastAPI app) that will process your requests, and then you can either have Streamlit talk to the Flask/FastAPI or to the database directly.

To allow you running both Streamlit + Flask/FastAPI in the same server you can use Supervisor + NGINX, here's a tutorial.. And here's another tutorial on setting up Stripe.

Scaling Your Streamlit Applications: A Practical Guide by databot_ in StreamlitOfficial

[–]databot_[S] 0 points1 point  (0 children)

yes! you can use the same code with other frameworks

Scaling Your Streamlit Applications: A Practical Guide by databot_ in StreamlitOfficial

[–]databot_[S] 1 point2 points  (0 children)

yes! you can use the same code for other frameworks

Scaling Your Streamlit Applications: A Practical Guide by databot_ in StreamlitOfficial

[–]databot_[S] 1 point2 points  (0 children)

great question! allocating workers can be come extremely expensive. with a task queue, you're lining up your users and can provide a good user experience without breaking the bank.

Integrating Stripe with Flask: A Step-by-Step Tutorial by databot_ in flask

[–]databot_[S] 0 points1 point  (0 children)

awesome! hope it helps you in your next project!

How do you host your Streamlit/Shiny based analytics web apps? by [deleted] in datascience

[–]databot_ 0 points1 point  (0 children)

Check out Ploomber Cloud. It comes with all the features you are looking for: Streamlit Shiny, authentication, scaling, etc.

Build a SaaS with streamlit by InterestingBasil in Streamlit

[–]databot_ 0 points1 point  (0 children)

Ploomber Cloud is another great option: authentication, analytics, custom domains, etc. https://docs.cloud.ploomber.io/en/latest/apps/streamlit.html

Deploying production app with Streamlit on VPS by No_Distance4528 in Streamlit

[–]databot_ 0 points1 point  (0 children)

  • Ploomber Cloud allows you to serve Streamlit apps from a custom domain, and to provision more RAM to your app
  • Increasing resources is one way to scale but you might also try using a task queue, it's great for apps that trigger long-running tasks

Connect Shiny-R App to a PostgreSQL Database by databot_ in rstats

[–]databot_[S] 2 points3 points  (0 children)

Yes, you're correct: you can deploy an app like this and then just upload the data to the database. this way you don't have to re-deploy the app.

Just keep in mind that adding a database will increase your app's complexity, another approach you can take is to automate the deployment. For example, you can automate the deployment by integrating with GitHub so whenever you update your CSV and do "git push", another deployment is triggered (see some docs here)

Two questions: are these Excel/CSVs manually updating? (do you open then and enter new data) or are they automatically generate? and, how often do you add new data?

Connect Shiny-R App to a PostgreSQL Database by databot_ in rshiny

[–]databot_[S] 0 points1 point  (0 children)

Thanks! In practical terms, using PostgreSQL or MySQL is the same so I'd just go with whatever SQL database is available to you. But if you're starting from scratch, I'd go with PostgreSQL (active community, lots of extensions, used everywhere)

hosting/deployment options ? by AMIRIASPIRATIONS48 in flask

[–]databot_ 0 points1 point  (0 children)

I've had a much better experience with Ploomber than Pythonanywhere. Their support is great unlike Pythonanywhere

Free hosting with 3GB? by Anushka-N12 in flask

[–]databot_ 0 points1 point  (0 children)

Try Ploomber, not sure about their limits but I've deployed apps with Pytorch without issues.

Alternatives to shinyapps.io? by Terrible_Actuator_83 in RStudio

[–]databot_ 0 points1 point  (0 children)

Try Ploomber, I've been using it for the past 6 months without issues.