http://blog.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://comments.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://comments.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://comments.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://comments.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://comments.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# Finally, because implementations at b) are important for a first preview of this technology, could you tell me your release plan for 5.2 in order to see if they will be ready on time or I need to move my plans to 5.4. </pre> Daniel Espinosa 2012-03-12T18:52:30 http://comments.gmane.org/gmane.comp.gnome.db/6372 <pre>Hi! I am quite confused with meta store functionality. First, all operations are very slow (if you compare to direct RDBM queries) and frnakly speaking I have no idea how to improve them. Second, I have problems with GdaConnection options. All is working fine, when I open connection with GDA_CONNECTION_OPTIONS_NONE and update meta store on demand: https://github.com/midgardproject/midgard-core/blob/ratatoskr/src/midgard_core_query.c#L58 I tried to set up the same database as meta store, which seems to improve performance a bit, but fails with postgres provider: syntax error at or near "'Nullable'" LINE 1: ...eric_precision, c.numeric_scale, c.is_nullable AS 'Nullable'...^, No:(-1), src:gda-postgres, SQL: 42601 Setting GDA_CONNECTION_OPTIONS_AUTO_META_DATA doesn't help, as meta store has to be updated still after any table layout change. I am finding some examples here and there, and my question is: What is the best way to manage meta store? Code complexity doesn't matter. It should work and have acceptable performance. For now, I should support libgda 4.0.12 (Debian stable), 4.2 and 5.x. Piotras </pre> Piotr Pokora 2012-03-09T11:16:30 http://comments.gmane.org/gmane.comp.gnome.db/6368 <pre>i'm trying to compile libgda 4.2 under gnu/linux with latest mdbtools (0.7-rc1) (not the libgda embedded) and i get the error in object i simply add the little patch attached (it also converts the file to utf8) thanks in advance _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Andrea Zagli 2012-02-27T11:33:32 http://comments.gmane.org/gmane.comp.gnome.db/6364 <pre>I'm trying to figure out how to make easy for bindings to use MetaStore and MetaContext. GdaMetaContext is a pure C struct with arrays of strings and values, but are hard for bindings because is not clear how to set its members. At first, I've tried to add simple API to it by commit: http://git.gnome.org/browse/libgda/commit/?id=ba3f677d5fe3445ea1bf9a04d50bc069545969a7(I have minor fixes for return values ready to commit) But it requires to change some GdaConnection related functions to work. But even that I found that GdaMetaContext is not defined as a GBoxed and GIR doesn't like that for new gda_meta_context_new method, tagging it as Not Introspectable!!!! This is a problem for bindings, you can't create a context any way. Are there any reason to not change GdaMetaContext to GBoxed? </pre> Daniel Espinosa 2012-02-13T20:33:19 http://comments.gmane.org/gmane.comp.gnome.db/6363 <pre>Hi, I try to use read-write Grid in my application. When I execute 'gda_connection_statement_execute_select' I have an Warning in terminal window, and can't edit eny data, when I double-click the grid - it don't switch to edit mode. The errors in terminal window is: (ksnews_3:2599): Gtk-WARNING **: Theme parsing error: &lt;data&gt;:5:10: 'xthickness' is not a valid property name (ksnews_3:2599): Gtk-WARNING **: Theme parsing error: &lt;data&gt;:6:10: 'ythickness' is not a valid property name What's wrong? To use the read-write grid I have coped all code of 'do_grid_rw' function of the 'gdaui-demo-5.0' example. 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-02-13T18:06:31 http://comments.gmane.org/gmane.comp.gnome.db/6361 <pre>I thing that LIBGDA_5.0 branch will be for systems that will use Vala 0.14 and not 0.15 as is today set for upcoming 5.0.4 version, is this correct? I think that we need to keep it at 0.14 and restrict to that version. Vala 0.15 will be used for GDA 5.2, in systems with GLIB 2.32, where the deprecated symbols are present. </pre> Daniel Espinosa 2012-02-07T18:34:54 http://comments.gmane.org/gmane.comp.gnome.db/6357 <pre>Dear Gnome-DB developers, I may have stumbled upon a bug in the SQLite engine having to do with deleting rows after having selected fields containing BLOB values. It appears that libgda-4.0 does not delete rows if a blob has been selected previously. In fact, it will seem to have been deleted to the program itself, but in subsequent runs of the program, the row turns out to have persisted. I have attached a testcase. It is in vala, but there's a shebang so you should be able to execute it like a script. Is this familiar behaviour to any of you? Could you think of a workaround? Should I put this on bugzilla? Thanks and best regards, Timo Kluck _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Timo Kluck 2012-02-03T09:27:05 http://comments.gmane.org/gmane.comp.gnome.db/6349 <pre>Hi, I have try to use libgda-ui read-write form. I have an error in function 'gda_data_select_compute_modification_statements': Can't get the prepared statement's actual statement. My SQL table is simple and my code is simmilar to the gdaui-demo-5.0 sample. What's wrong? I have looked to the gda_data_select_set_modification_statement () and can't understand how to write SQL request for mod_stmt parameter - what format etc... ?? To study it I have used libgda documentation at the http://developer.gnome.org/libgda/5.0/, and examples from the libgda-5.0.2 sources pacage. Is there any other documentation and some examples about my questions?? Thanks. 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-02-01T13:12:15 http://comments.gmane.org/gmane.comp.gnome.db/6348 <pre> Hi! I have a simple query: SELECT p.firstname AS name, p.lastname AS lastname FROM person AS p; Why both functions: gda_data_model_get_column_name gda_data_model_get_column_title return the same value? For 'p.firstname AS name' both return 'name'. Also, how can I get qualifier name, field name and as parts used in query? gda_data_model_describe_column seems to be good choice but none of its method returns those. Piotras </pre> Piotr Pokora 2012-01-30T17:41:50 http://comments.gmane.org/gmane.comp.gnome.db/6343 <pre>Hi... First, hello to wveryone, I'm new to the list. And now the bad things ;). I an just trying to use gda-browser to connect to a mysql server, and I just get an error on startup about the syntax of 'where Variable_name = ...' thing. I will reproduce it from mysql (well, really mariadb) cli client: werewolf:~&gt; mysql --host=xxxxx --user=magallon --password=xxxxx magallon Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 891633 Server version: 4.1.7-log Copyright (c) 2000, 2011, Oracle and/or its affiliates. 2009-2011 Monty Program Ab This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [magallon]&gt; show variables where Variable_name='lower_case_table_names'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where Variable_name='lower_case_table_names'' at line 1 This is the error I get from gda-browser-5.0 on connection. It looks like the sorrect syntax is something like: MySQL [magallon]&gt; show variables like 'lower_case_table_names'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 0 | +------------------------+-------+ 1 row in set (0.06 sec) Is this really a bug ? Is mysql 4.1 too old for gda ? TIA </pre> JA Magallón 2012-01-24T23:49:25 http://comments.gmane.org/gmane.comp.gnome.db/6334 <pre>I've finished most of the samples and Unit Tests for an implementation of Gee interfaces that allows you to: * Create a database row, set its values and append to the table in the table. Any column not set in your object is set to its default. * Create a GObject derived from GdaData.Record to manage information in a database. Object persistence. * Create a object to iterate, chop or filter over all Records in a Gda.DataModel. Called RecordCollection that implements Gee's interfaces Collection, Iterable and Traversable * I've added a set of interfaces, that use Vala's Generics, in order to allow others to implement the same functionality using other database wrapper different than GDA. GdaData namespace contains all these interfaces definitions and a set of classes implementing them using GDA infrastructure. === Comming API changes ==== * Field is defined as a generic class, I want to change it as not generic. * DbCollection, DbSchema, DbTable and its class implementators DataBase, Schema and Table, will be updated as required to implement new functionalities === Comming Planned Features === ==== Milestone 2: DbTable and Table ==== * Allow to synchronize fields attributes, foreign keys and list of tables that reference it * Allow to create new tables in databases, by using a HashMap collection holding fields definitions ==== Milestone 3: DbSchema and Schema ==== * Allow to get DbTables/Tables from database * Allow to add new schemas to database ==== Milestone 4: DbCollection/Database ==== * Allow to add new databases </pre> Daniel Espinosa 2012-01-11T00:12:44 http://comments.gmane.org/gmane.comp.gnome.db/6329 <pre>Thanks to Sebastian Bacher and others, libgda-5.0 is now packaged in the latest versions of Debian and Ubuntu: https://bugs.launchpad.net/ubuntu/+source/libgda5/+bug/872860 </pre> Murray Cumming 2012-01-05T12:57:42 http://comments.gmane.org/gmane.comp.gnome.db/6329 <pre>Thanks to Sebastian Bacher and others, libgda-5.0 is now packaged in the latest versions of Debian and Ubuntu: https://bugs.launchpad.net/ubuntu/+source/libgda5/+bug/872860 </pre> Murray Cumming 2012-01-05T12:57:42 http://comments.gmane.org/gmane.comp.gnome.db/6324 <pre> Hi. It it possible to work with BDB as a hash (key-value) storage using GDA? I see methods inserting values in specified row id, but don't see examples using key/value in gda. Is it possible? (Particularly in Vala). Thanks. _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Denis Kuzmenok 2012-01-04T16:39:30 http://comments.gmane.org/gmane.comp.gnome.db/6329 <pre>Thanks to Sebastian Bacher and others, libgda-5.0 is now packaged in the latest versions of Debian and Ubuntu: https://bugs.launchpad.net/ubuntu/+source/libgda5/+bug/872860 </pre> Murray Cumming 2012-01-05T12:57:42 http://comments.gmane.org/gmane.comp.gnome.db/6324 <pre> Hi. It it possible to work with BDB as a hash (key-value) storage using GDA? I see methods inserting values in specified row id, but don't see examples using key/value in gda. Is it possible? (Particularly in Vala). Thanks. _______________________________________________ gnome-db-list mailing list gnome-db-list&lt; at &gt;gnome.org http://mail.gnome.org/mailman/listinfo/gnome-db-list </pre> Denis Kuzmenok 2012-01-04T16:39:30 http://comments.gmane.org/gmane.comp.gnome.db/6321 <pre>Hi, guys. Can you point me to CSV parsing example? Thanks, in advance. </pre> Denis Kuzmenok 2011-12-30T11:31:18 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.gnome.db