[pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread pzzcc
Thanks Eldav , yes I would like to implement my own really to have a better understanding of how things work. thanks for the input and the resource. On Thursday, August 11, 2022 at 7:25:27 PM UTC+3 Eldav wrote: > sorry, database *abstraction* (stupid typo) > > > Le jeudi 11 août 2022 à

Re: [pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread Michael Merickel
As Laurent said, if I were starting from scratch a new project I would personally use the pyramid-cookiecutter-starter sqlalchemy and then rip out what I didn’t need but only one part of that cookie cutter is the ORM. It has several other features that you need to solve one way or another so

Re: [pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread Steve Piercy
Take SQLAlchemy, subtract psycopg2, the resulting differences are all the pitfalls you would get. There are too many to list, when the SQLAlchemy feature list gives you all that you need. --steve On Thu, Aug 11, 2022 at 9:21 AM pzzcc wrote: > Hello Steve , > > I would like to use psycopg2, I

Re: [pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread pzzcc
Hello Steve , I would like to use psycopg2, I am reading this now : https://docs.pylonsproject.org/projects/pyramid-cookbook/en/latest/database/index.html but I would like to see if anyone can share his experience / or point any pitfalls. what part of pyramid API should I look more into.

Re: [pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread pzzcc
Thanks Laurent and Michael. I want to avoid using *SQLALCHEMY* all together really to have a better understanding of how things work inside pyramid for integrating the tool with other tools already in place. so I think that is the correct route. once I get this to work , I will have a deeper

[pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread Eldav
sorry, database *abstraction* (stupid typo) Le jeudi 11 août 2022 à 18:22:07 UTC+2, Eldav a écrit : > Hello, > > afaik, nothing forces you to use SQLAlchemy with Pyramid (after all, you > could decide to use a non-relational database such as the ZODB or MongoDB). > > If you are sure that you

[pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread Eldav
Hello, afaik, nothing forces you to use SQLAlchemy with Pyramid (after all, you could decide to use a non-relational database such as the ZODB or MongoDB). If you are sure that you won't need database attraction later, you can talk to psycopg2/3 directly. By doing so, you will also lose the

Re: [pylons-discuss] Re: using pyramid without an ORM ?

2022-08-11 Thread Mike Orr
On Thu, Aug 11, 2022 at 9:54 AM pzzcc wrote: > I want to avoid using SQLALCHEMY all together really to have a better > understanding of how things work inside pyramid for integrating the tool with > other tools already in place. so I think that is the correct route. once I > get this to work ,

Re: [pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread Mike Orr
On Thu, Aug 11, 2022 at 8:59 PM Mike Orr wrote: > Somebody in our local Python group was doing that, although not with > Pyramid. He ran a PostgreSQL consultancy, and one of his staff gave a > talk about the benefits of using Postges' role system for user > accounts and permissions, and custom

Re: [pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread Mike Orr
Somebody in our local Python group was doing that, although not with Pyramid. He ran a PostgreSQL consultancy, and one of his staff gave a talk about the benefits of using Postges' role system for user accounts and permissions, and custom Postgres functions for querying and modifying data. They

[pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread pzzcc
Hello , I am building an application ( more of a tool really ) that have a web interface , and I am trying to avoid using ORM all together. plus I want to try postgresql features and experiment more with them. I don't want things to be overly complicated on the web interface so I put lots of

Re: [pylons-discuss] using pyramid without an ORM ?

2022-08-11 Thread Steve Piercy
For starters, how will you convert the results of a query into a useful Python object? For more things, read SQLAlchemy's description and features. https://www.sqlalchemy.org/ --steve On Thu, Aug 11, 2022, 8:53 AM pzzcc wrote: > Hello , > > I am building an application ( more of a tool