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 <[email protected]> wrote: > 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. > > that would help me understand pyramid and postgresql more. > > thanks Steve > > > On Thursday, August 11, 2022 at 7:12:24 PM UTC+3 Steve Piercy wrote: > >> 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 <[email protected]> wrote: >> >>> 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 logic , *something that I know will not change any time >>> soon* , into PostgreSQL directly using functions etc. >>> >>> can you please point me to the right direction of using pyramid without >>> it ? what might be the pitfalls of not using an ORM with pyramid ? >>> >>> >>> >>> Thanks ! >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "pylons-discuss" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pylons-discuss/309895e7-5ea4-49c6-b7e3-d7dff9c62337n%40googlegroups.com >>> <https://groups.google.com/d/msgid/pylons-discuss/309895e7-5ea4-49c6-b7e3-d7dff9c62337n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/pylons-discuss/35285c99-37a7-4062-8d72-033a168c03d5n%40googlegroups.com > <https://groups.google.com/d/msgid/pylons-discuss/35285c99-37a7-4062-8d72-033a168c03d5n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAOSXUXtBawdbZOLUGk0zgNWbL-7D-nw7s1wZRCjBBzKNGRYwyw%40mail.gmail.com.
