1102
Daily Python News Question, Tips and Tricks, Best Practices on Python Programming Language Find more reddit channels over at @r_channels
Need assistance connecting SQL Alchemy app db to Web App
I am building a WebApp with Flask, and Python. I have attempted to connect the database to the app, but I am unable to enter/retain any data. I am certain the databaseb exists, as I can see the empty file and can read the success messages:
Database URI: sqlite:///projects.db
Database initialized successfully.
* Debugger is active!
I get the error below when attempting to enter any data as a result:
sqlite3.OperationalError: no such table: projectsqlite3.OperationalError: no such table: project
/r/flask
https://redd.it/1g3yfh1
Tuesday Daily Thread: Advanced questions
# Weekly Wednesday Thread: Advanced Questions 🐍
Dive deep into Python with our Advanced Questions thread! This space is reserved for questions about more advanced Python topics, frameworks, and best practices.
## How it Works:
1. **Ask Away**: Post your advanced Python questions here.
2. **Expert Insights**: Get answers from experienced developers.
3. **Resource Pool**: Share or discover tutorials, articles, and tips.
## Guidelines:
* This thread is for **advanced questions only**. Beginner questions are welcome in our [Daily Beginner Thread](#daily-beginner-thread-link) every Thursday.
* Questions that are not advanced may be removed and redirected to the appropriate thread.
## Recommended Resources:
* If you don't receive a response, consider exploring r/LearnPython or join the [Python Discord Server](https://discord.gg/python) for quicker assistance.
## Example Questions:
1. **How can you implement a custom memory allocator in Python?**
2. **What are the best practices for optimizing Cython code for heavy numerical computations?**
3. **How do you set up a multi-threaded architecture using Python's Global Interpreter Lock (GIL)?**
4. **Can you explain the intricacies of metaclasses and how they influence object-oriented design in Python?**
5. **How would you go about implementing a distributed task queue using Celery and RabbitMQ?**
6. **What are some advanced use-cases for Python's decorators?**
7. **How can you achieve real-time data streaming in Python with WebSockets?**
8. **What are the
/r/Python
https://redd.it/1g3uko4
Auth external provider ?
Looking to use Supabase or Auth0 for auth.
I am leaning towards Supabase as their free tier also offers a managed db which looks generous.
Anyone got any recommendations of auth? Looking for Google SSO mainly. Something with a decent free tier
/r/flask
https://redd.it/1g3d4jn
My first python package got 844 downloads 😭😭
I know 844 downloads aint much, but i feel so proud.
This was my first project that i published.
Here is the package link: [https://pypi.org/project/Font/](https://pypi.org/project/Font/)
Source code: [https://github.com/ivanrj7j/Font](https://github.com/ivanrj7j/Font)
## **What My Project Does**
My project is a library for rendering custom font using opencv.
## **Target Audience**
* Computer vision devs
* People who are working with text and images etc
## **Comparison**
From what ive seen there arent many other projects out there that does this, but some of similar projects i have seen are:
* [https://pypi.org/project/a-cv2-putTrueTypeText/](https://pypi.org/project/a-cv2-putTrueTypeText/) this project get the job done, but have really messy code and doesnt have any documentation.
/r/Python
https://redd.it/1g3gcz9
Old school 2000s mouse accessory: Particles following your mouse! Get color under cursor! And more!
I would have loved to instead call this thread: "You can now have shit stuck to your mouse", but I felt it wouldn't take very long until it was removed.
# What my project does:
I've had an idea somewhere in 2022: I want rainbow trails for my mouse cursor. Available software was naught. So I made it myself!
- It can draw particles of any number and color spawning from your mouse cursor. With multiple vectors, influences from mouse motion and rotation, many ideas can be realized: Crazy or decent, river or beehive, smoke or explosion.
- or it can be the time
- Get RGB or RGB complementary color
- or get RYB and RYB complementary color from under it.
- Also useless stuff like the time with milliseconds, system cpu and ram usage, individual or at the same time, if you need it visible there for some obscure reason.
- An image is also possible - default is the poop emoji, of course.
(Just got a new idea: get color from under cursor and spawn particle with it for a sort of "scraping off pixels" effect)
The function to
/r/Python
https://redd.it/1g32kaw
Which tier for how many average users ?
Hey everyone,
I'm trying to buy my own server for the first time. What criteria do I need to consider before buying? I know I can change the plan and I'm asking for educational purposes. I'm curious about how many requests each server can handle and how many users it can support. Thanks!
KVM 1~~US$13.99~~SAVE 64%US$4.99/mo
For 24-month term
Choose planUS$7.99/mowhen you renew1 vCPU core4 GB RAM50 GB NVMe disk space4 TB bandwidthData centers worldwideLinux operating systems
MOST POPULAR
KVM 2~~US$17.99~~SAVE 61%US$6.99/mo
For 24-month term
Choose planUS$10.99/mowhen you renew2 vCPU cores8 GB RAM100 GB NVMe disk space8 TB bandwidthData centers worldwideLinux operating systemsKVM 4~~US$29.99~~SAVE 65%US$10.49/mo
For 24-month term
Choose planUS$22.99/mowhen you renew4 vCPU cores16 GB RAM200 GB NVMe disk space16 TB bandwidthData centers worldwideLinux operating systemsKVM 8~~US$59.99~~SAVE 66%US$19.99/mo
For 24-month term
Choose planUS$44.99/mowhen you renew8 vCPU cores32 GB RAM400 GB NVMe disk space32 TB bandwidthData centers worldwideLinux operating systems
/r/django
https://redd.it/1g38zpv
I want to create nth number of forms on an html page using pure flask and jinja and flask wtf forms. Is this possible and what would be the best way ?
I want to create nth number of forms on an html page using pure flask and jinja and flask wtf forms. Is this possible and what would be the best way ?
/r/flask
https://redd.it/1g2gezv
Monday Daily Thread: Project ideas!
# Weekly Thread: Project Ideas 💡
Welcome to our weekly Project Ideas thread! Whether you're a newbie looking for a first project or an expert seeking a new challenge, this is the place for you.
## How it Works:
1. **Suggest a Project**: Comment your project idea—be it beginner-friendly or advanced.
2. **Build & Share**: If you complete a project, reply to the original comment, share your experience, and attach your source code.
3. **Explore**: Looking for ideas? Check out Al Sweigart's ["The Big Book of Small Python Projects"](https://www.amazon.com/Big-Book-Small-Python-Programming/dp/1718501242) for inspiration.
## Guidelines:
* Clearly state the difficulty level.
* Provide a brief description and, if possible, outline the tech stack.
* Feel free to link to tutorials or resources that might help.
# Example Submissions:
## Project Idea: Chatbot
**Difficulty**: Intermediate
**Tech Stack**: Python, NLP, Flask/FastAPI/Litestar
**Description**: Create a chatbot that can answer FAQs for a website.
**Resources**: [Building a Chatbot with Python](https://www.youtube.com/watch?v=a37BL0stIuM)
# Project Idea: Weather Dashboard
**Difficulty**: Beginner
**Tech Stack**: HTML, CSS, JavaScript, API
**Description**: Build a dashboard that displays real-time weather information using a weather API.
**Resources**: [Weather API Tutorial](https://www.youtube.com/watch?v=9P5MY_2i7K8)
## Project Idea: File Organizer
**Difficulty**: Beginner
**Tech Stack**: Python, File I/O
**Description**: Create a script that organizes files in a directory into sub-folders based on file type.
**Resources**: [Automate the Boring Stuff: Organizing Files](https://automatetheboringstuff.com/2e/chapter9/)
Let's help each other grow. Happy
/r/Python
https://redd.it/1g33d10
Multiple Long Running task > 500 seconds stuck in STARTED state
I am building a celery (remote workers) + flask application(using send_task). The issue I am facing is that when I send multiple tasks to the celery worker, the tasks are executed (2 API calls are successful both return 200, one takes less than 60 seconds and the other takes greater than 400 seconds) but the task status is stuck in STARTED state. I have tried to increase the timeout for the API, added the soft_time_limit and time_limit, but whenever I add more task the task start they execute but the state is stuck. If I only send one task then it executes correctly and the status is also updated correctly. I am just not able to figure out the problem.
/r/flask
https://redd.it/1g2zeie
wow redis cache is a game changer..
I made my ecommerce with django + RDS PostgresQL..
It was quite fast, it took about 120~150ms for fetching data..
However, I took 3s for the first page load. it felt a bit slow when I search my page on google or Instagram..
I set redis for caching.. and now 20ms for data fetching and when I go on my site, the page shows immidiately.. less than a sec, it is super fast.. what a game changer..
/r/django
https://redd.it/1g2m3nn
I shared a 1+ Hour Streamlit Course on YouTube - Learn to Create Python Data/Web Apps Easily
Hello, I just shared a Python Streamlit Course on YouTube. Streamlit is a Python framework for creating Data/Web Apps with a few lines of Python code. I covered a wide range of topics, started to the course with installation and finished with creating machine learning web apps. I am leaving the link below, have a great day!
https://www.youtube.com/watch?v=Y6VdvNdNHqo&list=PLTsu3dft3CWiow7L7WrCd27ohlra\_5PGH&index=10
/r/Python
https://redd.it/1g2sip1
Production server help?
This is for my work. I can’t go into it too much here. Currently I am using waitress server. I am getting acceptable performance but I need to improve it. I am using nginx and waitress. Nginx for serving static and acting as reverse proxy. I have done lots of research and alternative options but the problem comes down to is Windows. This is a hard set requirement that it needs to run on windows. I can’t use gunicorn because it doesn’t support windows. I read about CHERRYPY WSGI SERVER - not sure about performance, uWSGI - (but I read it is made for Unix system), I read about hypercorn (I know this is asynchronous server) but it said in documentation that is can be served as sync. I don’t know about the performance. I am not sure.
What are some alternatives web servers that I can use and runs on windows that will give better performance than waitress?
I am pretty new to this so I greatly appreciate for helping me guide to the right direction.
/r/flask
https://redd.it/1g2l9tj
When working with multiple threads working on one model object, is there something about related fields that saves the primary objects data?
I have some celery tasks that run at the same time working on one model object. I'd thought I had been very careful about using transactions.atomic and select_for_update and using update_fields...etc.
I've run into one scenario i cannot explain
`conversion_successful` calls `.delay` on two other tasks and then updated a field on the object, as such:
load_skips.delay(pk=pk)
send_notification.delay(pk=pk)
with transaction.atomic():
m= MyModel.objects.select_for_update().get(pk=pk)
m.system_notes['processing_finished'] = timezone.now().isoformat()
m.save()
However what keeps happening is that the `processing_finished` in `system_notes` is very hit an miss as to whether or not it ends up in `system_notes` at the end of the day.
I tested moving the call to the two other tasks AFTER commiting the `processing_finished` data and its 100% always there. So there's something going on in those other two tasks.
The thing is, the other two tasks are a notification task which only get()'s the model and never saves, while the second task is loading data into a related model like the following:
m = MyModel.objects.get(pk=pk)
m.skips.get_or_create(
/r/django
https://redd.it/1g2cwsc
I'm making a periodic table on python.
I'm making a periodic table that has almost everything that a element can have. I made a Github repository, so check it out! Also, the "discussion" flair is because I know that the code is pretty bad, so if anybody has anything to add (both for the table and for the code ), please tell me!
Github link:
https://github.com/Mountainkaio/Python-s-periodic-table
/r/Python
https://redd.it/1g2af5p
website broken after 2 months
/r/django
https://redd.it/1g1xbd7
Teaching the world's largest programming lesson
This past Saturday I taught the world's largest programming lesson, with 1668 students, breaking the previous record of 724 students.
We broke the record in Portugal 🇵🇹 and the event was co-organised by a local university and a company I used to work at.
It was an insane event.
I have been in plenty of events with WAY more than 2k people.
Music festivals, sports matches, etc.
And yet, nothing beat being on stage, teaching Python to ~1750 students.
(The official record is at 1668 because some students were disqualified for not actually following the lesson 🤦.)
The lesson was split in three and I taught the middle segment, which was scheduled to last for half of the lesson.
The professor before me taught the students what an algorithm was, conceptually.
One of the examples provided was a brute forcy algorithm to solve a Sudoku puzzle.
Then, I taught them some basic Python syntax.
The objective was for me to introduce enough syntax so that we could implement the algorithm described in the first part on top of an abstraction that I created beforehand.
Finally, a third professor showed a couple of more advanced applications of Python, like creating a RAG application to interact with a major literary work that Portuguese students
/r/Python
https://redd.it/1g3loz8
Which libraries have the best docs?
Hi,
Out of all the available python libraries and frameworks, which ones do you think have the best documentation?
I am looking for examples to learn how to create good docs for a project I am working on.
Thanks!
/r/Python
https://redd.it/1g3hrkl
Django-Routify
Released Django-Routify new v0.3.3 version with cool feature and has been writen documentation!
Downloads last month on PyPI: 1800+
Github:
https://github.com/vitaliypopel/django-routify
Check docs here:
https://vitaliypopel.github.io/django-routify-docs/homepage
Django-Routify is a lightweight package designed to simplify routing views in the classic Django framework.
Example:
https://preview.redd.it/nwvnmjgb4qud1.png?width=625&format=png&auto=webp&s=345073c0d149b95c66946192dc89b5082f9156ba
https://preview.redd.it/7lpp9m3d4qud1.png?width=530&format=png&auto=webp&s=a7421b81a3048526f28f4db0a1beb2d2b9abb2a1
/r/django
https://redd.it/1g3fqvv
I made a website for finding deals on Pokemon cards on Ebay
Site: https://www.jimmyrustles.com/pokemondeals
Github: https://www.github.com/sgriffin53/pokemontcgdealfinderapp
What My Project Does
For the past few weeks I've been working on a Pokemon deal finder website. It works by finding listings from Ebay and card valuations from Pricecharting then returns the listings with the biggest difference in card price compared to card valuation.
It searches Ebay for 112 different sets and right now it has around 200,000 listings.
The listings will be updated every 8 hours.
It seems pretty successful at identifying cards. Most of the misidentification seems to be when a seller has mislabelled the card or set in the title, but for the most part, it seems good at identifying the cards.
It seems to find deals well, though a lot of the deals are heavily played cards that are underpriced due to their condition. For example, on the front page, there's a heavily played Umbreon EX #112 from Unseen Forces that's valued at $165.60 and the price is $19.96.
Target Audience
There's a large market for people buying and selling cards on Ebay. Users are constantly looking for good deals, and this tool is a way to automate looking for deals by comparing listing prices to valuations.
Comparison
There was a site a while ago that I believe did the same thing,
/r/Python
https://redd.it/1g2xje2
How to enable zsh terminal in jupyter when launching from conda environment
So basically I want the terminal that is launched within jupyter (specifically jupyter-lab) to be zsh instead of bash.
If I am have not expressed the my querry clearly attached screenshots might help.
ss-1: default zsh shell with 'ml0' conda env
ss-2 : terminal launched from jupyter-lab uses bash by default and also loses the conda env
And my major motive is to preserve the conda environment in the jupyter from which it is launched.
/r/IPython
https://redd.it/1g3alsy
Comprehensive Django Deployment Guide for Beginners
https://selftaughtdev.hashnode.dev/comprehensive-django-deployment-guide-for-beginners
/r/django
https://redd.it/1g2thsv
Database preference
Hey all, newish to python, wanted to start working with data. In my previous work i dealt a lot with sql, so iam used to looking at that type of layout. What do yall suggest that has a similar layout. Thanks!
/r/Python
https://redd.it/1g2zms9
Planning a project and getting things “connected”
I think I know the basics of Django but when I comes to connecting the pieces of a project together. For someone with little to no experience, what are ways to learn?
Example. For my work I was thinking of building a “hotel/barracks rooms” management system. Kind of similar to a hotel. Issues; some rooms share a bathroom, some rooms have to be female only since they share a bathroom, if a female is assigned to the room block any male from being assigned. The majority of rooms are male BUT some male rooms will need to be converted if there’s more females than males during that period. I would need a check in and “check out date” we don’t know when they checkout as it depends on them getting in-processed into the installation.
For someone with experience this might seem easy, for someone learning planning a project is difficult. What are some ways to fix this?
/r/djangolearning
https://redd.it/1g2tnd6
rendertemplate refuses to find my html file
hello! i am building a basic flask web app and cannot get render\template to correctly find my html file. i have scoured the web and tried many solutions, but it still says "template file 'index.html' not found". for reference my IDE is PyCharm. I have tried moving index.html in the exact same directory as the app, putting index.html inside a folder called "templates", and giving the Flask object a second input of "template_folder=[file path\]". None of these solutions work. My app.py is shown below (the if name==main part is below it with correct syntax, that just wasn't relevant here). Both app.py and the templates folder are in the same directory.
from flask import Flask, rendertemplate
app=Flask(name)
@app.route('/')
def index():
return rendertemplate("index.html")
/r/flask
https://redd.it/1g309a2
Table don't create in database
Hi guys, I'm new in flask, when I want to create table with this:
with app.app_context():
db.create_all()
Nothing happened. And when I see inside of database there is nothing in there..
I try various methods like app_context().push() and.... But they didn't work.
Can you guide me?
/r/flask
https://redd.it/1g2sag8
Environments Utils - Detect Your (quirky) Python Runtime Environment
Hey, r/Python!
What My Project Does:
Over the years, I’ve been working on a Python package called **Environments Utils** that helps detect characteristics of the environments where your Python script is running. It’s built to handle various edge cases and odd environments I’ve encountered. For example, it can determine if your script runs inside a Jupyter Notebook, on a SLURM cluster, or within Rosetta on macOS. The package also identifies system architecture, operating system, GPU availability, and even whether you have an internet connection - all with no additional dependencies!
Target Audience:
This package is designed for developers and data scientists who work in diverse environments, such as cloud platforms and high-performance computing clusters. I find it particularly useful when I need to adapt a pipeline depending on which system it is being installed on.
Production Use: You can use the package to adapt your script's behaviour based on the runtime environment (e.g., using different logging mechanisms in a SLURM cluster).
Development/Debugging: If you're writing code that needs to adapt to odd environments like Colab, TMUX, or hybrids like macOS Rosetta, this package can save you some headaches. I had several scripts that only broke down in COLAB or Rosetta etc, and this made
/r/Python
https://redd.it/1g2lh97
Why pandas transpose keys from exel provides RangeIndex while only keys provides List
workbook = pd.read_excel('data.xlsx')
workbook.keys():
`\`\`\` Index(['Comment:' 'count'], dtype='object') \`\`\``
workbook.transpose().keys():
`RangeIndex(start=0, stop=128, step=1)`
/r/Python
https://redd.it/1g2iztz
Sunday Daily Thread: What's everyone working on this week?
# Weekly Thread: What's Everyone Working On This Week? 🛠️
Hello /r/Python! It's time to share what you've been working on! Whether it's a work-in-progress, a completed masterpiece, or just a rough idea, let us know what you're up to!
## How it Works:
1. Show & Tell: Share your current projects, completed works, or future ideas.
2. Discuss: Get feedback, find collaborators, or just chat about your project.
3. Inspire: Your project might inspire someone else, just as you might get inspired here.
## Guidelines:
Feel free to include as many details as you'd like. Code snippets, screenshots, and links are all welcome.
Whether it's your job, your hobby, or your passion project, all Python-related work is welcome here.
## Example Shares:
1. Machine Learning Model: Working on a ML model to predict stock prices. Just cracked a 90% accuracy rate!
2. Web Scraping: Built a script to scrape and analyze news articles. It's helped me understand media bias better.
3. Automation: Automated my home lighting with Python and Raspberry Pi. My life has never been easier!
Let's build and grow together! Share your journey and learn from others. Happy coding! 🌟
/r/Python
https://redd.it/1g2d9f2
Determined to start and deploy webapp before the end of the year
I am super brand new to web development and I know my current passion and determination and confidence is part of the Dunning-Kruger effect
I’m fully aware I know nothing, not even a strong foundation in python
However this week I have built the essential codes for the main product of the web app using colab and chatpgt
I’ll be reinstalling python on my machine (did it wrong the first time lol get to eager and didn’t click on the little box asking about Paths)
Hope it’s okay if I use this group to keep myself accountable and share my journey especially when I eventually realise how much I really don’t know and lose some of my confidence lol
Also the app is meant to be my financial freedom project so with some luck I really do believe I can create something into being that other people will find true value in
Wish me luck x
/r/djangolearning
https://redd.it/1g1wj1n
asyncio vs uvloop vs gevent
What’s the exact difference between asyncio standard library, uvloop, and gevent?
When do I need to use one over another?
Is there recent development better than them?
/r/django
https://redd.it/1g1xf8x
