Have you ever consider to use GDA (www.gnomedb.org), is a GLIb based library small, easy to use and wraps lots of DB's like sqlite, postgresql, mysql, others supperted by JDBC and others using a simple common API. It has python bindings and is part of Gnome next 2.26 relase.
2009/3/11 Walter Leibbrandt <[email protected]> > F Wolff wrote: > >> ** > >> > >> WHERE DOES VIRTAAL FIT IN? > >> > >> If all of the above is implemented, Virtaal could always directly used > >> database-backed translation stores to do its work. Virtaal would > >> instantly benefit from the fast indexing code which would make Pootle > >> fast. Complex queries on big files would be very fast. And Virtaal would > >> use much less memory when dealing with large files. > >> > >> This would mean excellent re-use of code between Virtaal & Pootle. > >> > > > > This sounds nice, but the good performance you mention comes at the > > price of pre-calculating lots of things, which is a price to pay at > > startup time. We need to look carefully at our trade-offs between > > startup speed and query speed. Of course, there are ways to get both, > > but that is just a little bit more work. > > > Sounds like exciting times for Pootle! :) However... > > I cannot see this as viable for Virtaal until different databases are > supported. Specifically it would be crucial for at least sqlite to be > usable for all database storage. Adding a requirement for MySQL, > PostgreSQL or anything similar to Virtaal will be a very bad move. > > Of course a "real" DBMS is necessary to maximise the performance gain > presented by these ideas. This means that the database back-end(s) > should be DBMS-agnostic. Does this point toward something like SQLAlchemy? > > -- > Walter Leibbrandt http://translate.org.za/blogs/walter > Software Developer +27 12 460 1095 (w) > Translate.org.za > > Recent blogs: > * Firefox-style button with a pop-up menu > > http://www.translate.org.za/blogs/walter/en/content/firefox-style-button-pop-menu > * Virtaal's MVCisation > * Things that changed the way I code > > > > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are > powering Web 2.0 with engaging, cross-platform capabilities. Quickly and > easily build your RIAs with Flex Builder, the Eclipse(TM)based development > software that enables intelligent coding and step-through debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > Translate-pootle mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/translate-pootle > -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (en trámite, pero para los cuates: LIBRE) ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
