sylvain mouquet | 19 May 14:34
Picon

[gnome-db] Libgdamm + SQLCipher

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 <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 3 Apr 19:57
Picon

Re: [gnome-db] Added documentation for Vala Extensions

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 <despinosa <at> src.gnome.org>
Date:   Fri Mar 30 23:18:22 2012 -0600

    Integration GDA Vala docs to gtk-doc

commit 58914a992d594d93a2837addff8d3b3a7d14125e
Author: Daniel Espinosa <despinosa <at> src.gnome.org>
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 <despinosa <at> src.gnome.org>
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 <vmalerba <at> gmail.com>


On 27 March 2012 03:20, Daniel Espinosa <esodan <at> gmail.com> wrote:
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


This is freat, many thanks!

About integration, is there any possibility to include that documentation within Libgda's documentation (doc/C) to have only 1 HTML or devhelp document with all the documentation?

Regards,

Vivien



--
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)
_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 27 Mar 03:20
Picon

[gnome-db] Added documentation for Vala Extensions

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

--
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)

_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Kirill Scherba | 21 Mar 22:44
Picon

[gnome-db] Gdaui localization

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 <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Kirill Scherba | 19 Mar 18:47
Picon

[gnome-db] separate update buttons in GdauiGrid (RW)

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 <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 12 Mar 19:52
Picon

[gnome-db] Comments on Vala Extensions effort

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.


--
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)

_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Piotr Pokora | 9 Mar 12:16
Picon
Gravatar

[gnome-db] Update meta store (again)

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
Andrea Zagli | 27 Feb 12:33
Picon
Favicon

[gnome-db] pussible bug in mdb provider: MDB_SDATETIME undeclared

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
Attachment (patch.patch): application/octet-stream, 1097 bytes
_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 24 Feb 18:07
Picon

[gnome-db] Fwd: GNOME Foundation Membership - Accepted

Find attached an introduction for my self to GNOME Foundation Membership.

I found my welcome at:

http://www.gnome.org/news/2012/02/welcome-to-more-new-gnome-foundation-members/

But please consider to clarify my description as LIBGDA's maintainer. The formal maintainer is Vivien Malerba. I'm the maintainer of GObject Introspection and Vala support for GDA; most of my contributions goes to add bindings (GI) friendly API and some bugfixing on GDA to make it works great! to be used in other languages through GI. Now I'm developing some extensions to GDA written in Vala, expecting to be useful for any one using C and any other languages with GI support.

---------- Forwarded message ----------
From: Daniel Espinosa <esodan <at> gmail.com>
Date: 2012/2/14
Subject: Re: GNOME Foundation Membership - Accepted
To: foundation-announce <at> gnome.org


I really thanks for this distinction. I've been a GNOME enthusiasts from its early 1.x versions, but a real user since 2.x era. I've joined GNOME fan due to its philosophy and the way it is conducted by all its early and new developers.

In 1998 a took the adventure to use just GNOME as my full time desktop, trying to use StarOffice since to do my work dominated by Microsoft technologies; thanks to projects like Wine and CodeWeavers, I had been able to use MS Office to work on, that was the great step forward to use GNOME full time. At that time the killer feature of GNOME, some other free-desktops, the ability to have more than one desktop empower my productivity, allowing me to work with my work in different tasks and develop software, by quickly switching to related applications I have to use. I missed that productivity in GNOME 3 though, I hope 3.4 comes with good news - filed bug 651022 and helping on 648994 .

I've developed some PHP/PostgreSQL/Apache document management system to help me at work. Here was when I joined GNOME Data Access library and start to help them with improvements like port from custom generic data handler GdaValue to GValue with the objective to get access to C#/Mono technology and improve my database/web software, but that never happends and now Mono/Gtk+ bridge seems to be broken for me because they have unable to sync with Gtk+ improvements.

GDA and GNOME way to get thinks done, has inspired me to get more improvements in the way I conduct my innovations at work, by changing/adapting my self and co-workers (when they are ready to change) to new horizons and new technologies, like adopting IEC 61850 as the base technology for Substation Automation Systems. Then I took the oportunity to be the CEO like of new open source software, unique in an industry dominated by propietary solutions, called OpenSCLConfigurator and my own development OpenSASConfigurator to edit XML documents based on IEC 61850-6 Substation Configuration Language[1]. I started to help GXml to support Autotools and see if I can add GObject serialization to XML and use it in OpenSCL library to read/write SCL files to drop C#/Mono dependency and bring Gtk+ 3.x to my applications.

In all my efforts for innovations at my work, I've tried to help GNOME in translations; some time ago a group of enthusiasts founded www.lenmex.org, a dead effort to get GNOME to Mexican endemic languages like Nahuatl - if you found some translations on it I made them, just using a Spanish/Nahuatl dictionary-, but never get support for native speekers. At the same time I fire some suggestions on Pootle to get support to show two languages in its translation interface, in this case because most of potential translators can use Spanish but not English.

Today I'm trying to help GDA to support GObject Introspection (GI) and create the best platform to develop Database Access software, by improving API and make it bindings friendly; I love if GDA gets easy and feature rich a la Django framework, but for any language.

I'm adding new ways to access databases using Vala, by GDA's vala-extensions and implementing Gee interfaces collections. In the middle I found lots of opportunities to improve GDA's API to make it bindings friendly, by adding GI annotations and patching VAPI bindings generation.

At my work, I'm pushing to use Open Source Software as the investment protection technology for critical applications and the base for new developments for international standards. When possible and when other are ready to hear, I made elitism to choose open source solutions and distribute news about governments adopting them to ask: Can we do it too?

I used to help GnuCash to improve it and port to GObject, but found my self not productive, then I've desided to start a new library called libcash at SourceForge, but I want to re-write it using Vala to speed up its development. May be in the feature it can be used as a GNOME 3 application to manage your money.

[1] http://sourceforge.net/projects/opensclconfig/


2012/2/14 GNOME Foundation Membership Committee <membership-committee <at> gnome.org>
Dear Daniel Espinosa Ortiz,

We are pleased to inform you that you are now part of the GNOME
Foundation Membership. You are now eligible to become a candidate
for election and to vote in the annual Board of Directors elections
held each June before Guadec. You have been subscribed to the
foundation-announce mailing list, where all the major GNOME Foundation
announcements are sent. It is a low volume list and does not allow
subscribers to post emails. If you would like to read the archives
you can do so here:
   http://mail.gnome.org/mailman/listinfo/foundation-announce

You are also encouraged to subscribe to the foundation-list mailing
list. It is open to the public (even non-members) and is used to discuss
any issue relating to the GNOME Foundation. This is the place for you to
suggest ideas and voice your opinions on issues pertaining to the GNOME
Foundation. To subscribe or read the archives, go to:
   http://mail.gnome.org/mailman/listinfo/foundation-list

It's not mandatory but usually a nice thing to do if you could send an
introduction to the foundation-list mailing list to introduce yourself
and your work to the other Foundation members and GNOME contributors.
They will be more than happy to know yet another GNOME lover.

For more information about the GNOME Foundation, visit the GNOME
Foundation's web page at:
   http://foundation.gnome.org

Thanks for your contributions to GNOME.

Sincerely,

The GNOME Foundation Membership Committee






--
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)



--
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)
_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 16 Feb 17:11
Picon

Re: [gnome-db] Some questions

GDA uses, as you already now, GObject and then events are present for a while. GdaDataModel have several notification events for insert, update, delete rows, they can be used for your Python, Vala, C or any language with GObject events support.

If you consider your improvements could be a benefit for GDA, I encourage you to work directly in GDA. May be you want to add Python examples, or write some code for GDA's web-server, or so.

2012/2/16 Alaney Dória <27978 <at> alunos.isel.ipl.pt>
Ok thanks.

Yesterday I was investigating gloms code to allow some table events. The idea is to allow user to put some custom code when, for example, a new record is created on table. I would like to discuss some development approach but appear to me that not much people answer this mailing list. If any one is working on that already please stop me :).




On 02/16/2012 01:32 AM, Daniel Espinosa wrote:
For PyGDA, I can say that GDA supports GObject Introspection, then PyGObject is also supported. All the API can be located in the gir-1.0/Gda-5.0.gir for 5.x releases. But may be is useful to see PyGObject documentation first in order to now how to use most of GDA in python.

Some samples will be present, some of them already are there, to use GDA in Python, located in the source code at samples/Gir directory.

May be some one will take the time to write documentation for GDA in Python, but most of the C code can be easily translated to Python.

2012/2/13 Alaney Dória <27978 <at> alunos.isel.ipl.pt>
Hi

There is any what to insert on a table every time 2 or more different tables have new values? Imagine I have 3 tables A B and C I want to be able to insert new line in C every time A and B have new data. Also the same effect but just to update, this would allow to perform like small stock management.

I also would like to know any documentation or tutorial for pygda?

Any way in glom python to get the logged in user?

Regards
Alaney Dṍria
_______________________________________________
glom-devel-list mailing list
glom-devel-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/glom-devel-list



--
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)


_______________________________________________
glom-devel-list mailing list
glom-devel-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/glom-devel-list




--
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)
_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list
Daniel Espinosa | 13 Feb 21:33
Picon

[gnome-db] Deprecate GdaMetaContext?

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?

--
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)

_______________________________________________
gnome-db-list mailing list
gnome-db-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-db-list

Gmane