The way to develope a graphical application to manage a Postgres database
Hi, I'm new to python. I'm searching for a way to develope a Python graphical application for a Postgresql database. I have installed on my Debian GNU/Linux testing/sid system many python packages, among others: eric, geany, idle, ninja-ide, pida (it doesn't work here), python2.7, python-easygui, python-forgetsql, python-gasp, python-glade2, python-gobject-2, python-gtk2, python-pip, python-pygresql, python-pyside.qtsql, python-subversion, python-tk, python-wxglade, spyder, python3-psycopg2, python-psycopg2, XRCed. I did search in the Google but can't find any good tutorial except for wxpython tutorial: http://wiki.wxpython.org/FrontPage, wxGlade tutorial: http://wiki.wxpython.org/WxGladeTutorial There is a tutorial for using python-psycopg2 here: http://wiki.postgresql.org/wiki/Psycopg2_Tutorial Still I don't know how to put these all together? XRCed is the most interesting way for me. Can one advices me where to go? -- Regards from Pal -- http://mail.python.org/mailman/listinfo/python-list
Re: The way to develope a graphical application to manage a Postgres database
Verde Denim writes: > Sounds like you have enough pieces-parts... is it a question of the > development process? Yes, it is. First question is about GUI. Say I start to create a GUI with XRCed for such an application for managing a concrete postgresql database. On a Frame (window) which object should I draw to get a Table of the database when I write the code? If I want to use say python-pygresql to connect to the database then I must study the http://www.pygresql.org/pg.html documentation and after that I must to write code to connect it with the GUI. Is on the Internet such a tutorial that can help me in this effort? -- Regards from Pal -- http://mail.python.org/mailman/listinfo/python-list
Re: The way to develope a graphical application to manage a Postgres database
Dennis Lee Bieber writes: > On Thu, 02 Aug 2012 20:24:36 +0200, Csanyi Pal > declaimed the following in gmane.comp.python.general: >> >> I'm searching for a way to develope a Python graphical application for a >> Postgresql database. >> > A predefined database, or a general access module? A predefined, already existing database. >> I have installed on my Debian GNU/Linux testing/sid system many python >> packages, among others: >> eric, geany, idle, ninja-ide, pida (it doesn't work here), python2.7, >> python-easygui, python-forgetsql, python-gasp, python-glade2, >> python-gobject-2, python-gtk2, python-pip, python-pygresql, >> python-pyside.qtsql, python-subversion, python-tk, python-wxglade, >> spyder, python3-psycopg2, python-psycopg2, XRCed. >> > Well... I'd suggest figuring out which GUI toolkit you want to > use... You have GTK, Tk, I'd say Wx but you didn't list wxpython. You > also have two competing PostgreSQL adapters -- pick one... I just installed wxpython packages: wx2.8-i18n, python-wxgtk2.8, python-wxtools. > Eric, geany, and idle are all editor/development environments and > not directly related to what the application itself runs. > > For a predefined database, you may just want to explore Dabo. For a > general access (eg; one where you tell the program which PostgreSQL > database to connect to, and it extracts the schema information from the > database at run-time) you'll need to study the advanced features of the > database engine and adapter. I'm exploring now Dabo. -- Regards from Pal -- http://mail.python.org/mailman/listinfo/python-list
Re: The way to develope a graphical application to manage a Postgres database
Walter Hurry writes: > On Thu, 02 Aug 2012 20:24:36 +0200, Csanyi Pal wrote: > >> I'm searching for a way to develope a Python graphical application for a >> Postgresql database. > > I use wxGlade/wxPython to build the GUI, and then hand code the database > access using psycopg2 into the generated application. Works very well for > me, but I do know SQL and Postgres. Well, I tried out many adviced ways but none of them works on my Debian GNU/Linux testing/sid system. Always get some error in one of the part of the software. Can you give a short tutorial for newbies how to start to develope with tools you used successfully? -- Regards from Pal -- http://mail.python.org/mailman/listinfo/python-list
Re: The way to develope a graphical application to manage a Postgres database
Mark Lawrence writes: > On 05/08/2012 16:58, Csanyi Pal wrote: >> Walter Hurry writes: >> >>> On Thu, 02 Aug 2012 20:24:36 +0200, Csanyi Pal wrote: >>> >>>> I'm searching for a way to develope a Python graphical application for a >>>> Postgresql database. >>> >>> I use wxGlade/wxPython to build the GUI, and then hand code the database >>> access using psycopg2 into the generated application. Works very well for >>> me, but I do know SQL and Postgres. >> >> Well, I tried out many adviced ways but none of them works on my Debian >> GNU/Linux testing/sid system. Always get some error in one of the part >> of the software. > > If you give precise details by cutting and pasting the error people > will be able to help. I shall do that later. >> Can you give a short tutorial for newbies how to start to develope with >> tools you used successfully? >> > Seek and ye shall find!!! Ye, if I find spare time I shall do that certainly. -- Regards from Pal -- http://mail.python.org/mailman/listinfo/python-list
