There is no built-in embedded DB in GC as standard.
If you are using DBD then yes you can use its full capability to use SQL
and the other functions but should point out that some of use use other
tools such as Mysql/MariadDB, Postgres, Oracle, DB-2 Express utilising
the various SQL pre-compilers.
All of the above can process blobs for storing photo's.
Vince
On 06/10/16 10:59, Nehad Shello wrote:
Does the GnuCOBOL's default built-in embedded DataBase, limited or
not?
If I need to process picture(photo) fields, what a Free Open
Source DataBases do you advise to use with GnuCOBOL?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2022-04-25
what are the precompilers sql for postgress or db2?. and how are they installed?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
All of them are free and unlimited except db2 express-c. The DB2 Express-C database engine is limited to use up to 16GB RAM (increase from 4GB with v10.5) and two CPU cores. Oracle You have to pay ofcourse.
Last edit: thomas 2016-10-06
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
They are all free and unlimited for NON commercial purposes.
If you wish to create such or sell on then you need the correct version
for most of them if not all.
For many how ever if you supply the source code then you are still
within most of the licenses.
It really does depend on what you are going to do .
But simply put if you are going to make money then the vendors want
their share of the income :)
Vince
On 06/10/16 12:22, Nehad Shello wrote:
Excuse me, which of them, are a free DB and unlimited?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2022-04-25
excuseme. what is the sql cobol precompiler for db2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Heady COBOL though. You are dealing with very sophisticated software with those two extra layers (PostgreSQL and ocesql). Once over the hump, with a few initial programs written and working, it's a production grade setup.
ocesql is GPL for the tools and LGPL for the library runtimes. (Same as GnuCOBOL). PostgreSQL is basically an MIT free license, (but it is the PostgreSQL license, the copyright notice that must remain intact during redistribution is a little different (mentioning PostgreSQL) but the technicals are the same, free for any purpose, as long as you display the copyright notice unaltered).
If you just want to fling a few million pictures around with a limited number of simultaneous connections, SQLite would likely do fine (public domain - and Dr. Richard Hipp is a very approachable developer, a gift to the world). SQLite is a powerful little engine, but it is single threaded lock on write, so you don't want to have a thousand people all doing writes at the same time. Ten, sure, as the write time locks are short lived, but you'd need to watch the scaling much past that. There are samples of embedding the library, or simply passing system commands and piping results around. http://open-cobol.sourceforge.net/faq/index.html#other-sql-engines
But as Vince pointed out; free software is really meant to generate more free software, and if you want to get to commercial levels, it is best to be prepared to pay some dues, be that in coin or other contributions in kind, or be prepared for an industry that glares at you as a freeloader.
Have good, make well,
Brian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2022-04-25
ocessql is a sql precompiler?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is no built-in embedded DB in GC as standard.
If you are using DBD then yes you can use its full capability to use SQL
and the other functions but should point out that some of use use other
tools such as Mysql/MariadDB, Postgres, Oracle, DB-2 Express utilising
the various SQL pre-compilers.
All of the above can process blobs for storing photo's.
Vince
On 06/10/16 10:59, Nehad Shello wrote:
what are the precompilers sql for postgress or db2?. and how are they installed?
Start at https://gnucobol.sourceforge.io/faq/index.html#does-gnucobol-support-any-sql-databases
That's info is a little stale now, and the Gix-IDE, GixSQL is worth a look too.
https://github.com/mridoni/gix/releases and https://github.com/mridoni/gixsql/releases
Have good, make well,
Blue
Excuse me, which of them, are a free DB and unlimited?
All of them are free and unlimited except db2 express-c. The DB2 Express-C database engine is limited to use up to 16GB RAM (increase from 4GB with v10.5) and two CPU cores. Oracle You have to pay ofcourse.
Last edit: thomas 2016-10-06
They are all free and unlimited for NON commercial purposes.
If you wish to create such or sell on then you need the correct version
for most of them if not all.
For many how ever if you supply the source code then you are still
within most of the licenses.
It really does depend on what you are going to do .
But simply put if you are going to make money then the vendors want
their share of the income :)
Vince
On 06/10/16 12:22, Nehad Shello wrote:
excuseme. what is the sql cobol precompiler for db2
If you want something free and production grade, take a look at PostgreSQL and the ocesql preprocessor from the OSSCONS team in Japan.
See http://open-cobol.sourceforge.net/faq/index.html#ocesql for some details.
Heady COBOL though. You are dealing with very sophisticated software with those two extra layers (PostgreSQL and ocesql). Once over the hump, with a few initial programs written and working, it's a production grade setup.
ocesql is GPL for the tools and LGPL for the library runtimes. (Same as GnuCOBOL). PostgreSQL is basically an MIT free license, (but it is the PostgreSQL license, the copyright notice that must remain intact during redistribution is a little different (mentioning PostgreSQL) but the technicals are the same, free for any purpose, as long as you display the copyright notice unaltered).
If you just want to fling a few million pictures around with a limited number of simultaneous connections, SQLite would likely do fine (public domain - and Dr. Richard Hipp is a very approachable developer, a gift to the world). SQLite is a powerful little engine, but it is single threaded lock on write, so you don't want to have a thousand people all doing writes at the same time. Ten, sure, as the write time locks are short lived, but you'd need to watch the scaling much past that. There are samples of embedding the library, or simply passing system commands and piping results around. http://open-cobol.sourceforge.net/faq/index.html#other-sql-engines
But as Vince pointed out; free software is really meant to generate more free software, and if you want to get to commercial levels, it is best to be prepared to pay some dues, be that in coin or other contributions in kind, or be prepared for an industry that glares at you as a freeloader.
Have good, make well,
Brian
ocessql is a sql precompiler?