http://permalink.gmane.org/gmane.comp.gnome.db hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.gnome.db/6397 <pre>Hi, I have downloaded and compiled libgda and libgdamm with SQLCipher provider. When i run : gda-sql-5.0 -L i have the SQLCipher enabled : Ldap │ Provider for database where tables are based on data contained in an LDAP direc SQLCipher │ Fournisseur pour SQLCipher SQLite │ Fournisseur pour bases de données SQLite Web │ Fournisseur pour serveurs mandataires de serveur Web (4 rows) But i dont know why i cannot to read and write a database with SQLCipher. My code : Gnome::Gda::init (); try { con = Gnome::Gda::Connection::open_from_string ("SQLCipher", "DB_DIR=.;DB_NAME=db5", "", Gnome::Gda::CONNECTION_OPTIONS_THREAD_SAFE); } catch (Gnome::Gda::ConnectionError e) { std::cout &lt;&lt; "error = " &lt;&lt; e.code() &lt;&lt; endl; if (code == Gnome::Gda::ConnectionError::CONNECTION_OPEN_ERROR ){ std::cout &lt;&lt; "error = " &lt;&lt; "CONNECTION_OPEN_ERROR" &lt;&lt; endl; } con-&gt;statement_execute_select ("PRAGMA KEY='demo'"); con-&gt;stat</pre> sylvain mouquet 2012-05-21T21:35:45 http://permalink.gmane.org/gmane.comp.gnome.db/6396 <pre> Read "gda-sql-4.0 -L" insdead (upper case L). Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-05-19T14:26:21 http://permalink.gmane.org/gmane.comp.gnome.db/6395 <pre> you have installed Libgda using your distribution's, check you have installed the package named "libgda-sqlcipher" (or similar). If you have installed Libgda from sources, make sure you have compiled the SQLCipher provider as well. In any case, you can always obtain the list of installed providers using the "gda-sql-4.0 -l" command. Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-05-19T14:00:50 http://permalink.gmane.org/gmane.comp.gnome.db/6394 <pre>Hi, I am looking for using the sqlcipher with libgdamm but i dont found example for doing it. When i try ( http://developer-next.gnome.org/libgda/5.0/provider_notes_sqlcipher.html) : gda-sql-4.0 "SQLCipher://DB_NAME=testcrypt" i get this error : "Impossible d'ouvrir la connexion 1 : Pas de fournisseur « SQLCipher » installé". How can i do for adding the SQLCipher provider ? Thanks, Sylvain _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> sylvain mouquet 2012-05-19T12:34:24 http://permalink.gmane.org/gmane.comp.gnome.db/6393 <pre> Ok, will do it ASAP. Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-04-07T19:56:09 http://permalink.gmane.org/gmane.comp.gnome.db/6392 <pre>Il giorno ven 09 mar 2012 22:03:30 CET, Vivien Malerba ha scritto: could you port it to branch 4.2? thanks </pre> Andrea Zagli 2012-04-07T08:38:19 http://permalink.gmane.org/gmane.comp.gnome.db/6391 <pre>Ok thanks. I've start my personal features freeze for Vala Extensions, no new implementations in Objects. I'll review some bug reports and try not to change Code, because I've not time for that now. Performance improvements will be in next releases and hope to get your announce about Providers expose internal queries to avoid GdaMetaStore, but just to be discussed later. 2012/4/4 Vivien Malerba &lt;vmalerba&lt; at &gt;gmail.com&gt; </pre> Daniel Espinosa 2012-04-05T15:06:08 http://permalink.gmane.org/gmane.comp.gnome.db/6390 <pre> I agree on using that Features/Code Freezes before releases. However for the upcoming release, because I have some code I've been working on but not yet committed (LDAP write), I would like to start that process only after I commit that code, which might be in a few days. Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-04-04T19:37:02 http://permalink.gmane.org/gmane.comp.gnome.db/6389 <pre>I'll review some bug reports regarding Vala/GObject Introspection, I'll notify if I found some of them to be fixed before to release. I propose to get release procedures like in GNOME, using Features/Code Freezes with defined time frames between them as follows: a) State a Freeze for new features, may be starting today, b) wait a week (up to April 10) to review bug reports to be fixed (no new features must be added to fix them), then state Code Freeze status to wait translators to finish c) wait a week before release, may be on April 17 2012/4/3 Vivien Malerba &lt;vmalerba&lt; at &gt;gmail.com&gt; </pre> Daniel Espinosa 2012-04-03T19:59:46 http://permalink.gmane.org/gmane.comp.gnome.db/6388 <pre> This is great! Thanks a lot, Vivien BTW, I'm currently correcting some bugs, adding write support to the LDAP provider, and I'll make a new release of Libgda. _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-04-03T19:04:26 http://permalink.gmane.org/gmane.comp.gnome.db/6387 <pre>I've added support to install Yelp/Mallard documentation and a copy in HTML format to GDA's gtk-doc. Check up the following commits in master: commit c231daba86c482b73780e80bb730e07c70aa397d Author: Daniel Espinosa &lt;despinosa&lt; at &gt;src.gnome.org&gt; Date: Fri Mar 30 23:18:22 2012 -0600 Integration GDA Vala docs to gtk-doc commit 58914a992d594d93a2837addff8d3b3a7d14125e Author: Daniel Espinosa &lt;despinosa&lt; at &gt;src.gnome.org&gt; Date: Fri Mar 30 13:02:06 2012 -0600 GDA Vala Extensions now install Yelp Manual correctly. * Yelp Manual for GDA Vala Extensions now install correctly * Updates on GDA's Vala bindings commit 1131cc4e4b7cf2c97e893423e8c79682fcbc9630 Author: Daniel Espinosa &lt;despinosa&lt; at &gt;src.gnome.org&gt; Date: Fri Mar 30 11:54:47 2012 -0600 Modify Gda Vala extension documentation's file location * Temporly not integrated to GDA's gtk-doc 2012/3/27 Vivien Malerba &lt;vmalerba&lt; at &gt;gmail.com&gt; </pre> Daniel Espinosa 2012-04-03T17:57:59 http://permalink.gmane.org/gmane.comp.gnome.db/6386 <pre>I've added documentation for Vala Extensions. They are in Mallard format and includes UML diagrams figures. For now it includes: a) general view of interfaces b) general view of classes c) Record class d) Enable Vala Extentions Lacks: a) Rest of classes b) No Autotools integration to install </pre> Daniel Espinosa 2012-03-27T01:20:46 http://permalink.gmane.org/gmane.comp.gnome.db/6385 <pre>I don't know about json-glib, but GDA uses a GObject/GLib C API to wrap C API from its providers, provides prepared SQL commands to be executed directly by the providers, and so on. Look at http://www.gnome-db.org/ Vala extensions are written in pure Vala. It just use GDA Vala bindings to get access to the Database and run queries to save/load fields, this is at least for GdaData.Record class. Record class is a pure Vala implementation that use Gee classes, it internally uses Gda.SqlBuilder to run queries on load or save data; they are run when you call update() or save() methods, but you can dinamically set fields' value using set_field(), no access to database are performer jet. An example for GdaData.Record is: http://git.gnome.org/browse/libgda/tree/samples/vala/SampleDataObject.vala?id=b71b62ab68ddec29637f59dc05ae270ed10efee5 May be the only object you will get a penalty in performance (what are your requirements? Real Time?) will be GdaData.Table class, but just for update(), because it uses GDA's m</pre> Daniel Espinosa 2012-03-23T19:27:03 http://permalink.gmane.org/gmane.comp.gnome.db/6384 <pre> Good! The grid's column's title is determined automatically by Libgda: it is the "name" property of the GdaHolder holding the values for the column. Basically the GdauiRawGrid does: - from the GdaDataModel to display, create a GdaDataModelIter object - from that iterator object, determine the column's title If you want to localize the titles, you can: - modify the names of the data model's columns (for instance in the SELECT command, or afterwards with the GdaColumn object); or - modify the name attribute of the GdaHolder: GdauiRawGrid --gdaui_data_selector_get_data_set()--&gt; GdaDataModelIter --gda_data_model_iter_get_holder_for_field()--&gt; GdaHolder &amp; use the "name" property. Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-03-22T13:07:50 http://permalink.gmane.org/gmane.comp.gnome.db/6383 <pre>Hi Vivien, Thank you for previous answer. Everything is clear, I have used it. I have another one question: How to localize application which uses the Gdaui lib? I have try to use standard PO Files but it can't localize grids column titles (I have used layout file to change my grids column titles), tooltip messages and others (nothing can't localize)... Have you one more good advice? Best regards, Kirill Scherba. _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Kirill Scherba 2012-03-21T21:44:23 http://permalink.gmane.org/gmane.comp.gnome.db/6382 <pre> Instead of using the GdauiGrid, use a GdauiRawGrid (in fact the GdauiGrid concatenates a GdauiRawGrid and a GdauiDataProxyInfo, see http://developer-next.gnome.org/libgda/stable/GdauiDataProxyInfo.html). The GdauiRawGrid is basically a GtkTreeView which you can use as such. The GdauiRawGrid implements the GdauiDataProxy interface which gives you access to a GtkActionGroup object from which you can perform various actions on the GdauiRawGrid, see http://developer-next.gnome.org/libgda/stable/GdauiDataProxy.html#gdaui-data-proxy-get-actions-group. Refer to the GtkActionGroup's documentation to see how you can create your own buttons with those actions. You can also have a look at Libgda's code for examples, http://git.gnome.org/browse/libgda/tree/libgda-ui/gdaui-data-proxy-info.c Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-03-20T13:56:54 http://permalink.gmane.org/gmane.comp.gnome.db/6381 <pre>Hi, Is it possible to connect my separate Update buttons to GdauiGrid. Another words: Defult Gdaui Grid has buttons in left bottom corner. How to crete my own buttons to process the grids events. Thanks _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Kirill Scherba 2012-03-19T17:47:42 http://permalink.gmane.org/gmane.comp.gnome.db/6380 <pre> Can you try running the tests/meta-store/check_meta_store_postgresql test program (you may have to explicitely ask make to compile it first)? Note that you need to export the POSTGRESQL_META_CNC environment variable first so that the test program knows where to connect to, for example: export POSTGRESQL_META_CNC="HOST=gda;PORT=5432;USERNAME=gdauser;PASSWORD=GdaUser;DB_NAME=test" Note that you should create a test DB for this as the test creates a meta store in the identified database, and thus creates many tables in it. You should have a result similar to the one attached. Let me know how it goes. Regards, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Vivien Malerba 2012-03-14T15:10:07 http://permalink.gmane.org/gmane.comp.gnome.db/6379 <pre> To be honest I haven't had a lot of time lately (very busy at work...), and because I can't compile the Vala extension on my box, I haven't had the opportunity to "play" with it (even though I'd like to see it and discover Vala). I've only looked at the code in libgda/libgda/data/ to try to figure out how the classes are organized (BTW, I could not get Gaphor to work on my Fedora 16 box...) Could you send me a PDF (or other format) of the UML diagram you made? Yes, I saw these examples, many thanks for including them. I think what you're doing is great, I simply see it from a distance at the moment. I really need to spend some time to be able to compile the vala extension. I don't have a fixed plan for the 5.2 (I guess a few months at most would be good, but it also depends on what you think). However, I think it is necessary to have come documentation about the Vala extension in the "official doc" in doc/C, with: - what features are available in the Vala extension (a summary of all your work, w</pre> Vivien Malerba 2012-03-13T21:41:14 http://permalink.gmane.org/gmane.comp.gnome.db/6378 <pre>Vivien, Do you have any comment about my work on Vala Extensions? I've added some examples for Object persistences; I will for Tables. I really think your comments about will be great! Including the ones for my comments and ideas about meta store. I really think that may be we can expose some meta store methods (implementation made by providers) to allows others to use that information in its applications/libraries skipping SQLite storage. In my case I can access directly to improve performance; my Vala extensions gets the metainformation from GdaMetaStore and map it to GObject/Properties. Don't forget that they are C/GObject too, you can use in your C code if you want. Please let me know what are your comments, suggestions and doubts on my work, in order to continue. Plans: a) I've reached Milestone 2: Implement DbTable interface b) I'll implement DbSchema and DbCatalog interfaces c) Check for Vala to add "inline SQL commands": SQL statements that could be part of your Vala code like LinQ does for C# </pre> Daniel Espinosa 2012-03-12T18:52:30 http://permalink.gmane.org/gmane.comp.gnome.db/6376 <pre> This definitely looks like a bug which should be corrected. I'll work on it ASAP. It's up to you to define when you need information from the meta store (i.e. when you need information about tables, columns, ...). Maybe you don't need that information at all (I don't know how Midgard works regarding the tables it creates). What I tend to do is create a small separate SQLite database to keep the meta data as it is very fast to write to and read from. Agreed. However, my guess is that the actual SQL code used in the PostgreSQL provider to actually fetch metadata should benefit from being simplified (some queries are very complex). However I don't have the time to work on this for now. Of course there may be some other bottlenecks in Libgda, and probably using a profiler would help. Also keep in mind that Libgda tries to keep all the data in a meta store valid, even if out of date for some parts (meaning for example you can't update only the tables list: when you do that it also updates the columns li</pre> Vivien Malerba 2012-03-09T21:12:43 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.gnome.db