Re: [open-cobol-list] Splitting files by platform, cobc performance survey

[Brian Tiffin]

Patrick;

I'm a fair huge fan of SQLite, and its author Richard Hipp.  SQLite
source code is public domain but still primarily maintained by Dr.
Hipp.  He also writes Fossil, my SCM of choice.  Fossil is like
github, in a box, single executable.

See http://oldsite.add1tocobol.com/tiki-list_file_gallery.php?galleryId=12
for some source code that links to SQLite, using the API and another
version emulating the sqlite3> command line embedded in OpenCOBOL,
commands and data passed back and forth as strings.

BUT ... that is old already, and a shiny new ocesql has arrived from
Japan.  OpenCOBOL fully supports EXEC SQL now, for PostgreSQL.  See
http://sourceforge.net/p/open-cobol/discussion/109661/thread/6c52b611/
for some details.  Turns out the Firebird team just recently got their
gpre EXEC SQL preprocessor to work with OC1.1 as well.

Steve is posting some sample code to
http://sourceforge.net/p/open-cobol/discussion/2526793/thread/1183a23c/
and the latest addition includes ocesql in the examples.  Good stuff
that thread.

Cheers,
Brian

On 9/15/13, Patrick <address@hidden> wrote:
> Hi Brian
>
> I just posted to the SqLite list to see what these folks would say. I
> received two responses. One person thought that SqLite would be too
> slow. His company develops OpenLDAP:
>
> http://www.openldap.org/
>
> He said that it is smaller and faster then BDB and had a no nonsense
> licensing scheme, I haven't really checked it out yet.
>
> The other fellow thought that SqLite might work fine but he did not know
> enough about the application.
>
> The author of Tokyo Cabinet seems to be pushing people to use his Kyoto
> Cabinet now and he wants $12000 per year for commercial use of it, not
> sure where this leaves Tokyo Cabinet.
>
> Maybe SqLite would not replace BDB but it it would be nice to be able to
> interact directly with SQL from within Cobol. There are samples in Cobol
> unleashed, I have never written code like this but I would like to be
> able to write code like this:
>
> EXEC SQL SELECT * INTO FOO
>                                     FROM POO
>                                     WHERE TITLE = 'moo'
> END-EXEC
>
> -Patrick
>
> BTW I don't put too much faith in these programming popularity websites
> but Cobol seems to be doing just fine here, moving up 5 spots:
>
> http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html
>
> I have a little more faith in this one because the metrics are published:
>
> http://lang-index.sourceforge.net/
>
>
>
>
>
>
>
>