Add docs on how to interact with databases about pyscript HOT 5 CLOSED

This is happening as a socket cannot be created to establish a connection ( for same reason you cannot use library such as requests). The web assembly doesn't support native sockets AFAIK

from pyscript.

Would it be an idea to repurpose this to documentation describing how to interact with databases?

from pyscript.

Would it be an idea to repurpose this to documentation describing how to interact with databases?

This is definitely an interesting topic for the "How to" part of the docs.
I guess we can repurpose this issue to point to that.
In case anyone wants to tackle it, feel free to reach out to me.
We have docs on how to build the docs, and good "how to" examples that were contributed by the community in the past.
Maybe one of the docs that'd be relevant to this issue is: How to make HTTP requests using PyScript, in pure Python

from pyscript.

Hi @PartikIITD and everyone,

As mentioned earlier, using sockets directly to connect to databases like MySQL is not possible in the current setup due to the limitations of web assembly. However, you can still interact with databases using alternative methods, such as making API calls to a server-side script that handles the database operations.

For instance, you can create a server-side script (using Flask, Django, or any other preferred framework) that interacts with the MySQL database, and then expose an API endpoint to perform the required database operations. Next, use PyScript to make HTTP requests (GET, POST, etc.) to these API endpoints to perform the desired tasks.

Here's a high-level outline of the steps:

1. Develop a server-side script (e.g., in Python, PHP, or Node.js) that connects to the MySQL database and performs the necessary operations.
2. Expose API endpoints for the server-side script to perform CRUD operations on the database.
3. Use PyScript to make HTTP requests to the API endpoints to interact with the database indirectly.

I hope this helps! Please let me know if you have any questions or need further assistance.

from pyscript.

PyScript works on the browser, where it's hard to install MySQL or PostgreSQL in any meaningful way so sockets and libraries to connect via sockets or REST API is needed.

However, I think sqlite would work out of the box, but it would likely be an in-memory (hence volatile) solution.

There are JS libraries that persist SQLite on the browser and maybe there's something in the Python Web world too, but this is how it works and there's no action for us to take directly.

Closing for the mentioned reason.

from pyscript.