Re: kinterbasdb error connection
On 12/31/2010 04:41 PM, Ale Ghelfi wrote: On 09/12/2010 15:17, Uwe Grauer wrote: On 12/07/2010 04:35 PM, Ale Ghelfi wrote: (i'm under Ubuntu 10.10 amd64 and python 2.6 and kinterbasdb 3.2 ) I try to connect my database of firebird 2.5 by kinterbasdb. But python return this error : You are not using the current kinterbasdb version. See: http://firebirdsql.org/index.php?op=develsub=python Uwe kinterbasdb 3.2.3 is the Really current version for Ubuntu 10.10 AMD64. Kinterbasdb 3.3.0 exists only for ubuntu 10.10 i386 I've check in the repository. AFAIK 3.2.3 doesn't work for FB 2.5. If you don't get 3.3.0 from the ubuntu repositories you could do a manual install for 3.3.0 Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: kinterbasdb error connection
On 12/07/2010 04:35 PM, Ale Ghelfi wrote: (i'm under Ubuntu 10.10 amd64 and python 2.6 and kinterbasdb 3.2 ) I try to connect my database of firebird 2.5 by kinterbasdb. But python return this error : You are not using the current kinterbasdb version. See: http://firebirdsql.org/index.php?op=develsub=python Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: kinterbasdb + firebird 1.5 with python 2.6 ?
Laszlo Nagy wrote: Uwe Grauer írta: Laszlo Nagy wrote: Get it from here: http://www.firebirdsql.org/index.php?op=develsub=python Thanks. Unfortunately, this does not support Firebird 1.5 anymore. I can only find Python 2.5 + Firebird 1.5. But not for Python 2.6. I'm going to downgrade. :-( Can you point me to where you read about stopped support for FB 1.5? Could it be that you have to just compile it against FB 1.5 libs to get a working version? Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: kinterbasdb + firebird 1.5 with python 2.6 ?
Laszlo Nagy wrote: Does anyone know how to get firebird 1.5 driver (kinterbasdb) for FireBird 1.5? My problem: * python 2.6 already installed on a server * there is a firebird 1.5 database on the same server * I need to access it from python 2.6 Any thoughts? Get it from here: http://www.firebirdsql.org/index.php?op=develsub=python You should have mentioned your OS to get better answers. Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: ANN: P4D 1.2
Kay Schluehr wrote: P4D = E4X style embedded DSL for Python but without E and X. The main feature of P4D 1.2 are *Bytelets*. While the primary purpose of P4D 1.1 was the support textual data which can be considered as isomorphic to XML the new release is focussed on binary data. Bytelets are P4D objects that are assembled from hexcode which is reified as a Hex object. Bytelets can also be serialized as Hex objects which makes them apt for low level communication. Bytelets can be used to parse hexcode into other Bytelets of the same structure and Bytelets can be cloned like object prototypes which makes it easy to produce sequences of variations of one Bytelet ( usually you do not derive from a Bytelet but modify a prototype ). For more information see: http://pypi.python.org/pypi/P4D http://www.fiber-space.de http://www.fiber-space.de/EasyExtend/doc/p4d/bytelets.html That's a really bad name for the project as there is P4D (Python for Delphi) already. Maybe try to find a different naming to help distinguish your project from other meanings. Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: sqlite3 alternative option
Gandalf wrote: Hi every one I'm looking for a good alternative db to replace sqlite I'm using pySQlite3, And I tried to translate very big database from Mysql to sqlite. I generated through PHP a python script that insert 200,000 records to my sqlite db and took me more then 5 hours and managed to insert only 100,000 records. I have almost million records so I need a better solution. thank you Use Firebird. It has a small footprint and runs in different enviroments from embedded to server with single process per connection. http://www.firebirdsql.org http://www.firebirdfaq.org Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: sqlite3 alternative option
Gerhard Häring wrote: Uwe Grauer wrote: Use Firebird. It has a small footprint and runs in different enviroments from embedded to server with single process per connection. Firebird may be nice, but has nothing to do with this performance problem. I suggested Firebird because the OP asked: Hi every one I'm looking for a good alternative db to replace sqlite Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: kniterbasdb and datetime
Laszlo Nagy wrote: Hi All, I connected to a FireBird 1.5 database this way: import kinterbasdb kinterbasdb.init(type_conv=200) # See http://kinterbasdb.sourceforge.net/dist_docs/usage.html#faq_fep_is_mxdatetime_required Then I try to update the database: sql = UPDATE TABLE1 SET DATEFIELD=? where ID = ? params=[datetime.date(2007,11,01),2341] cursor.execute(sql,params) I get this error: kinterbasdb.ProgrammingError: (-413, 'isc_dsql_execute: \n conversion error from string 2007-11-01') What is wrong here? Thanks, Laszlo Just tested this against my 2.03 firebird db: import datetime import kinterbasdb as db db.init(type_conv=200) con = db.connect(dsn='myhost:fbtool-dev', user='sysdba', password='pwd') sql = update jnp set gebdat = ? where iid = ? params = [datetime.date(2007, 11, 01), 152] cur = con.cursor() cur.execute(sql,params) con.commit() It worked. What version of kinterbasdb are you using? Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: Adding GNU Readline after installation?
[EMAIL PROTECTED] wrote: I compiled Python from source on a bunch of my development machines without enabling the readline modules. Is it possible to add readline support after installation? I really just want to get my up arrow history working... No. You have to uncomment readline support in Modules/Setup, call make again and do a reinstall. Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: Python Database Apps
[EMAIL PROTECTED] wrote: Kindof a poll, kindof curiosity... What is your favorite python - database combination? I'm looking to make an app that has a local DB and a server side DB. I'm looking at python and sqlite local side and sql server side. Any suggestions Darien http://dabodev.com/ -- http://mail.python.org/mailman/listinfo/python-list
Re: Icons for GUI development
Benjamin wrote: I'm developing a mail client. Since GUI are usually improved with some icons, I'm looking for some. Because I'm not a very gifted artist I'm searching for a library of GPL or public domain icons. Any suggestions? http://tango.freedesktop.org/Tango_Icon_Library -- http://mail.python.org/mailman/listinfo/python-list
Re: Looking for a wxPython GUI builder
Jens Thiede wrote: On Jun 16, 3:18 am, Dick Moores [EMAIL PROTECTED] wrote: How about SPE? Any others? And which ones do people actually use? Commercial or Freeware. Thanks, Dick Moores There's Boa Constructor... (http://boa-constructor.sourceforge.net/ Screenshots). I haven't actually used it though. You should also take a look at Dabo: http://www.dabodev.com It has a fairly nonrestrictive license. -- http://mail.python.org/mailman/listinfo/python-list
Re: dabo framework dependancies
daniel gadenne wrote: Paul McNett wrote: Shameless plug: consider using Dabo on top of wxPython - we feel it makes wxPython even easier and more pythonic, but admittedly there's a bit of a learning curve there too. Even though Dabo is a full application framework originally meant for desktop database applications, it is modular and you can choose to only use the UI bits... http://dabodev.com Hi Paul, I'm considering moving over to dabo for wxpython development. However I do not write traditional database applications à la foxpro (I'm a 20 years user of fox...) anymore. Only xml-fed applications. I'm a bit hesitant to jump onboard since dabo seemns to carry over its own lot of database connectivity dependancy. Can you reasonably use dabo for plain datafree application? François Yes, the only database dependency is sqlite as a store for app-preferences. But even this could get changed easily. Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: a better solution for GUI in python
ce wrote: Hi, My company is using python currently for our website. We need to develop a GUI front-end for our ERP that would be portable (Windows and Linux). My question is which solution would be better for the GUI (and easier to implement)? I knew there are something like wxidgets, QT and pyGTK? actually we will need some complicated stuff in the GUI and yet I don't know much about GUI programming. Any recommendation guys? Take a look at Dabo. It is using wxWidgets and runs on Windows, Mac, Linux. http://www.dabodev.com Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: Newbie Question
Stef Mientki wrote: [EMAIL PROTECTED] wrote: On 9 fév, 14:06, Stef Mientki [EMAIL PROTECTED] wrote: will explain the rest Delphi is a (dying) proprietary, MS-Windows-only[1] software relying on a low-level language. Well it may be dying, but for the moment it beats Python with a factor of 10, when it comes to user (the majority of PC users) friendly GUI ;-) Would you mind explaining yourself and backing your above assertion ? Like, ie, on which points does Delphi beats Python wrt/ GUIs, what special magic would make so that GUIs designed with Delphi would be more user-friendly, and where does this factor 10 comes from ? Maybe I should have written it in quotes factor of 10 ;-) But here are a few points - in Delphi the GUI design itself is done in a graphical environment, making it much easier and faster - auto-scaling of components on a form is very easy (so if the user changes form size ..) - even making everything on a form movable by the end-user is just 1 mouse-click - using the designers style, or the user style is just 1 click - very good feedback, so creating interactive graphs is very easy, cross-hair, slopes, region of interest etc. - a very huge collection of controls is standard available - print / clipboard / export to almost any graphical file format, just 1 line of code but to be honest ... ... I never even tried to write a GUI in Python, ... ... just looked at others examples, ... and still not seen what I can perform in Delphi ;-) cheers, Stef Mientki Good luck... There is dabo which is a tool on top of wxwidgets: http://dabodev.com/ Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: C/C++, Perl, etc. to Python converter
mm wrote: Is there a Perl to Python converter? Or in general: a XY to Python converter? Is see, that Python is much better then Perl anyway. But for beginners, they whant to konw how is this done with Python etc. Sure, there are some docus out there in the internet. But a converter? Maybe this can help in converting from prel to python: http://www.crazy-compilers.com/bridgekeeper/ Uwe -- http://mail.python.org/mailman/listinfo/python-list
Python for Lazarus (not Delphi)
Does anyone know if something similar to Python for Delphi does exist for lazarus? Thanks for any pointers, Uwe -- http://mail.python.org/mailman/listinfo/python-list
How to stop winpdb programatically
How can i stop winpdb at a special point in a file? I know that there is set_trace() in pdb which stops execution in the debugger, but how to do this in winpdb? Thanks for hints, Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: ANN: FreeImagePy 1.2.2
Andrew Gwozdziewycz wrote: Knowing some details about PIL and as good as no details about FreeImage, I would like in this context to become enlightened by the answer to the question, when does it make sense to use FreeImage instead of PIL? From what I know up to now I can't see any use for FreeImage :-( . both freeimagepy and freeimage are released under the GPL, PIL is not. -- Andrew Gwozdziewycz [EMAIL PROTECTED] http://ihadagreatview.org http://plasticandroid.org Did you read the PIL licence? Seems to be a more free licence than GPL. A. Software License The Python Imaging Library is: Copyright © 1997-2003 by Secret Labs AB Copyright © 1995-2003 by Fredrik Lundh By obtaining, using, and/or copying this software and/or its associated documentation, you agree that you have read, understood, and will comply with the following terms and conditions: Permission to use, copy, modify, and distribute this software and its associated documentation for any purpose and without fee is hereby granted, provided that the above copyright notice appears in all copies, and that both that copyright notice and this permission notice appear in supporting documentation, and that the name of Secret Labs AB or the author not be used in advertising or publicity pertaining to distribution of the software without specific, written prior permission. SECRET LABS AB AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL SECRET LABS AB OR THE AUTHOR BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. Uwe -- http://mail.python.org/mailman/listinfo/python-list
Re: Programming Language for Systems Administrator
Kanthi Kiran Narisetti wrote: Hi All, Thank You for your suggestionsI request you all to eloborate the Uses(In Practical) for systems administrator.Some of my questions regarding the same follows. 1)Can i build web applications in Python ? If so how. I am planning to build a web application for intranet use which deals with workflow of Internal office communication. Look here: http://www.python.org/moin/WebProgramming 2)Which is best opensource database to be used with Python ? I personally think that Firebird is a very good Database: http://www.firebirdsql.org/ http://kinterbasdb.sourceforge.net/ 3)When i write a remote execution script in python is it required that python should be installed in remote system. 4)I heard about Perl/CGI and that CGI application done by python too.Is CGI still valid when PHP has taken over the WebApplication Development, Dominating. Sorry if these questions are out of this group , but answers to these ? will help me a lot. Thanks in Advance Kanthi. -- http://mail.python.org/mailman/listinfo/python-list
Re: database in python ?
Pierre-Frédéric Caillaud wrote: MySQL is an excellent option is very well documented. It is also a defacto standard for OpenSource databases. MySQL sucks for anything but very very basic stuff as it supports no transactions, foreign keys, procedures, triggers, concurrency, etc. Postgresql is a lot better, free, and the psycopg adapter for Postgres is *very very* fast (a lot faster than the MySQL one) and it has a dictfetchall() method which is worth its weight in donuts ! Yes, Postgresql is a lot better than MySQL but take a look at Firebird to see how easy a full featured db-System could be. Use kinterbasdb from Sourceforge to get Firebird into Python. Uwe -- http://mail.python.org/mailman/listinfo/python-list