Live data from Hacker News

ERP-Application in Python, PyQt5 and PostgreSQL

news.ycombinator.com

11–20 of 35 posts

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#11
post #9
post #7

The project uses a mix of Dutch and English for symbols, docs and comments. Now you need programmers that besides Python, are also good with both Dutch and English. Sadly this greatly limits the audience.

Agreed, but that doesn't detract much from the achievement. A few screenshots would be nice, though.

The screenshots are available look: https://github.com/DirkJanJansen/Pandora/tree/master/Install...

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#13
Looking at the Github, it really feels like you should organize your code better. There are many files with the same prefix that should go into their own src/{prefix} subdirectories. The README is really lackluster and should contain installation information and screenshots at least.

https://github.com/DirkJanJansen/Pandora/blob/master/invoerI... What the heck is this supposed to be? Are you really creating a database table and then a connection, and executing that in the middle of some random code? You really need to separate this out. And this is not a cherrypicked complaint, this is the first file I randomly clicked in the repo.

https://github.com/DirkJanJansen/Pandora/search?q=create_eng... This looks like you're creating a new engine anywhere you need database access. This is NOT how you use SQLAlchemy. Create a database.py file that contains a SINGLE create_engine function, and define all your tables in one place. This code looks like a real mess.

Don't take this as a personal attack. We all had to start somewhere. But this is not something I'd call top quality or really even quality.

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#14
post #9

Earlier quoted context omitted.

Agreed, but that doesn't detract much from the achievement. A few screenshots would be nice, though.

The screenshots are available look: https://github.com/DirkJanJansen/Pandora/tree/master/Install...

Maybe putting some on the top-level README? those are two levels down, and inside a subfolder of "Installation", which I would not ordinarily look into for screenshots...

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#15

Looking at the Github, it really feels like you should organize your code better. There are many files with the same prefix that should go into their own src/{prefix} subdirectories. The README is really lackluster and should contain installation information and screenshots at least. https://github.com/DirkJanJansen/Pandora/blob/master/invoerI... What the heck is this supposed to be? Are you really creating a databas…

I'm aware, that the code could be organised better. But keep in mind, that the program is not written by a professional. It's intended as an example for integration python with a database system for the community and i am convinced that the program helds many aspects as a learning purpose for instance integrating graphs. And screenshots by the way are available in the project at https://github.com/DirkJanJansen/Pandora/tree/master/Install... And as far as to your first comment over creating tables, this is not creating tables, but defining it to the program. I should read more accurate, before commenting

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#18

Looking at the Github, it really feels like you should organize your code better. There are many files with the same prefix that should go into their own src/{prefix} subdirectories. The README is really lackluster and should contain installation information and screenshots at least. https://github.com/DirkJanJansen/Pandora/blob/master/invoerI... What the heck is this supposed to be? Are you really creating a databas…

I'm aware, that the code could be organised better. But keep in mind, that the program is not written by a professional. It's intended as an example for integration python with a database system for the community and i am convinced that the program helds many aspects as a learning purpose for instance integrating graphs. And screenshots by the way are available in the project at https://github.com/DirkJanJansen/Pando…

The problem is that if you are putting this out there for purposes of education, it should use best practices, and it clearly doesn't here. I suggest that you significantly refactor this code. I believe that it can become much better with more modularization, more clearly explaining some aspects of the code and better project structuring.

Re: ERP-Application in Python, PyQt5 and PostgreSQL

#19

Quite an accomplishment. Well done! How long have you been working on it? Echoing others, I recommend improving the readme and embedding or linking to screenshots in it :)

Thank you for your comment. I worked about 600 hours on the project, i'm retired, so i have the time. The links to the installation files and screenshots will be included in the readme. Good idea, Thanks!
Post reply on HN