notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.
New feature planned: get notified when the package is available. Now is the time to contribute ideas/suggestions.
non port: databases/cego/pkg-plist

Number of commits found: 28

Sunday, 4 Jul 2021
07:48 Kurt Jaeger (pi) search for other commits by this committer Author: Bj√∂rn Lemke
databases/cego: update 2.47.3 -> 2.47.6 and devel/lfcbase: 1.16.1 -> 1.16.2

lfcbase:
- Added HashT::getRangePos and HashT::RemovePos for more efficient
  hash array manipulation

cego:
- Fix in CegoQueryCacheEntry::cleanCache, reset of all relevant
  variables. Furthermore, in CegoQueryCache methods, remove from
  hasharray is checked for return code true
- Usage of new HashT methods ( getRangePos and RemovePos ) for
  CegoQueryCache to remove entries from query cache array more efficient
- Fix in CegoFactor::evalFieldValue(), for case CegoFactor::QUERY,
  the fetched value must be saved to a local copy, otherwise the
  buffer could be overwritten by the subsequent nextTuple method call
  to complete the query for query cache. As a result, wrong values
  are returned in case of heavy buffer cache relocation.
commit hash: 5aa5b648b19ff6d5cdf3ad047167fac2c7d594f8 commit hash: 5aa5b648b19ff6d5cdf3ad047167fac2c7d594f8 commit hash: 5aa5b648b19ff6d5cdf3ad047167fac2c7d594f8 commit hash: 5aa5b648b19ff6d5cdf3ad047167fac2c7d594f8 5aa5b64
Thursday, 4 Jul 2019
19:13 pi search for other commits by this committer
databases/cego: upgrade 2.44.14 -> 2.45.0

- Added table alias feature to grammar definition. Table aliases
  allow alternate table name and attribute name definitions for a
  table ( create alias ... )
- Added classes CegoAliasObject and CegoAttrAlias for table alias handling
- Implemented base semantic actions for creating, listing and
  describe alias objects ( still no usage )
- In CegoDistManager::registerObjects, added registration for fkey,
  check, trigger and alias
- Added alias mapping for insert, update and delete queries (
  CegoQueryHelper::mapAliasPredicate still to implement )
- Basic alias mapping for select works, here's a sample SQL script
  drop if exists table t1;
  list alias;
  desc alias a1;
  drop if exists alias a1;
  create table t1 ( a int, b string(30));
  create alias a1 on t1 ( a as ax, b as bx );
  insert into a1 ( ax, bx ) values ( 1, 'XXX');
  insert into a1 ( ax, bx ) values ( 2, 'YYY');
  insert into a1 ( ax, bx ) values ( 3, 'ZZZ');
  select ax from a1;
- More work on table alias handling. Now works with more sophisticated
  select queries ( e.g. select ax from a1 aa where aa.ax = 1; ) For
  this, some fixes had to be done in CegoContentObject, since the the
  table alias attribute ( _tabAlias ) was not setup in constructor
  and other methods
- Added alias and trigger xml export and import feature ( trigger
  xport was still not implemented ) Fix in CegoDbThread::loadObjects
  for trigger reload, instead of triggerList.Next(), triggerList.First()
  was called, which result in an infinite loop in case of existing
  trigger objects
- Added trigger and alias object handling to CegoXPorter binary
  export and import

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:505863 
Sunday, 21 Apr 2019
13:31 pi search for other commits by this committer
devel/lfcbase: update 1.11.9 -> 1.13.0
devel/lfcxml: update 1.2.6 -> 1.2.10
databases/cego: update 2.39.16 -> 2.44.1
databases/cegobridge: update 1.4.0 -> 1.5.0
databases/p5-DBD-cego: update 14.0 -> 1.5.0

- Warning: storage format has changed
  Export to xml format before upgrade and re-import after the upgrade
  See UPDATING
- recompile all applications linked to libcego
- Lots of changes, among them:
  o improved crash recovery
  o fixes to SQL expected behaviour
  o better CDATA handling
  o fixes primary key handling design issue
  o changes to serialisation for export/import, XML export/import is still
    possible

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Changelog:	http://www.lemke-it.com/litexec?request=pubnews&user=&lang=en&numlog=1000
Original commitRevision:499537 
Wednesday, 28 Feb 2018
18:53 pi search for other commits by this committer
databases/cego: update 2.38.20 -> 2.39.1

- Introduced table locking statements to set an explicit lock on a
  table ( e.g. for update synchronisation ). This feature replaces
  the "set update sync on/off" command
- Trigger implementation basically completed
- Fix in CegoQueryHelper::encodeFVL, for blob/clob values lists,
  the corresponding index variables ( blobidx/clobidx ) have not been
  increaed while encoding lob data. This might lead to invalid results
  and seg faults in case of multiple lobs values in one insert/update
  operation.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:463258 
Saturday, 25 Mar 2017
18:06 pi search for other commits by this committer
devel/lfcbase: update 1.9.1 -> 1.9.2
databases/cego: update 2.32.14 -> 2.33.0

lfcbase:
- Added CommandExecuter::executeStream method to catch stdout for
  any forked process
- Added class OutStream to catch stdout from forked programs via popen

cego:
- Added database verify006 to check multidimensional btrees also in
  combination of null value handling.
- Fix in CegoObjectCursor::getNext, double method call for unlockData removed
- Small grammar correction to treat distinct flag for select-star statement
- Fix in CegoBTreeCursor::compValue, null values have not been handled
  correctly. For string values, string termination was not clean, which
  also might lead to wrong cursor results
- Introduced archive manager, which can be triggered, to perform
  an online backup. For now, online backups have to be triggered
  externally.
  The achive manager should make backup / restore handling more convenient
- Update to version 2.33.0 since the backup feature changes the product
  specification.
- Integration of newly introduced lfcbase OutStream class to catch output
  from backup manager. This allows to indicate a more detailed
  output from backup manager on the admin console.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:436911 
Saturday, 6 Feb 2016
15:59 pi search for other commits by this committer
devel/lfcbase: 1.7.0 -> 1.7.2
databases/cego: 2.28.3 -> 2.29.1
databases/cegobridge: 1.1.1 -> 1.1.2

Please note: Updating cego databases needs an export/import
             cycle for 2.28 -> 2.29

lfcbase:
- Fix in Datetime.cc, added include config.h, otherwiese the local
  implementation of strptime ist used. This should just be done, if
  the system API does not provide this call ( e.g. MINGW ) .
- Memory leak fixed in File::readLine

cego:
- Started with clob datatype implementation
- Fix in CegoSelect constructor, _cacheEnabled var was not initialized
  in the decoding constructor, which might lead to core dumps in case
  of recovery of complex with enabled querycache Fix in CegoAdminThread
  constructor, disableAuth method for TableManger called, otherwise
  tableset recovery might fail with auth error
- Required network protocol expansions done for clob handling
  (putclob, getclob, delclob)
- More work on clob handling. A fix was done for update operations
  on clob values in CegoTableManager::updateTuple method. Before
  updating the tuple, all clob references must be cloned, otherwise
  in case of untouched clobs, references are invalid. This approach
  is brute force, better would be, to stay on the untouched clob
  references. But in terms of transaction and recovery handling,
  this is not trivial
- Very long strings are handled now in CegoAction and CegoClient
  to also parse large clob values
- Modification in cgclt for raw mode, Now just plain data is listed,
  with the command line option --raw=X, a separator token can be setup
  as a column separator

cegobridge:
- fix build problem

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:408300 
Saturday, 7 Nov 2015
09:28 pi search for other commits by this committer
databases/cego: 2.26.7 -> 2.26.9

- Version passed concurrent load test with 10 million concurrent
  operations ( random insert, update and delete on one table with 2
  processes )
- Fix in CegoFileHandler::allocatePage, In case of page exceed with
  appendMode = true, a second try is done with appendMode = false
- Small fix in CegoObjectManager::reorgObject, ref page id information
  for append mode is set to new last page id
- Small fix in CegoSelect::filterRefs, allow expressions with constant
  values ( getAttrRefList= 0 ) in aggregation
- Locking improvements for delete and update operations.
  All delete operations are done now via transactions ( introduced
  CegoTableManager::deleteDataTableAtomic ). This allows to use a
  shared lock as the table lock for using the table
  (CegoDistManager::deleteLocalDataTable and
  CegoDistManager::updateLocalDataTable )
  As a result, a table can be accessed in parallel during a ( long
  running ) delete operation on the table( e.g. delete from table).
  E.g. select count(*) from table will not block anymore, rather
  indicates the remaining number of tuples in the table.
  This modification is still under investigation and must verfied
  ( also in combination with btree/index objects on the table )
- Fix in CegoBTreeManager::deleteBTree, the relevance value was not
  calculated correctly
  Fix in CegoQuery, cache invalidation is done before query operations.
  Otherwise, if the query is aborted, an exception is thrown and
  the cache is not cleaned
- Small modifications on cgblow load simulation client
- Changed locking for delete an update operations to exclusive due
  to concurrency prpblems with btree operations
- Added page locking to AVLIndexManager and AVLIndexCursor
- Improvements for locking done. Since locking is done on page level,
  Insert and delete operations can be done now in parallel . For this
  locking had to be introduced in CegoBtreeManager::insertBTree and
  CegoBTreeManager::deleteBTree
  Further performance path for grouping queries in CegoGroupSpace.
  Since the current grouping key is stored now in the class variable
  _groupSchema, some expensive list copy operations could be avoided.
  This improves performance for about 4%.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:400974 
Friday, 11 Sep 2015
06:19 pi search for other commits by this committer
databases/cego: 2.24.4 -> 2.25.0

- Added throw statement for stored procedures. This allows to throw
  exceptions on application level

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:396648 
Saturday, 29 Aug 2015
08:37 pi search for other commits by this committer
databases/cego: 2.23.12 -> 2.24.3

- Implemented query cache
 
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en&section=cgdoc_cgadm.html#cgadm_querycache
- SQL keywords can now be used case-insensitive, with proper CSMODE
 
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en&section=cgdoc_database_running.html#compatattr

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Original commitRevision:395533 
Friday, 15 May 2015
20:48 pi search for other commits by this committer
databases/cego: 2.23.0 -> 2.23.1

Added some missing include files to be installed

Submitted by:	Bjorn Lemke <lemke@lemke-it.com>
Original commitRevision:386483 
Thursday, 14 May 2015
06:01 pi search for other commits by this committer
databases/cego: 2.22.0 -> 2.23.0

- Introduced CegoDatabaseFormater.
  Since the API has changed (proagation of database formatting methods),
  this is 2.23.0

Submitted by:	Bjorn Lemke <lemke@lemke-it.com>
Original commitRevision:386290 
Sunday, 15 Feb 2015
16:52 pi search for other commits by this committer
databases/cego: 2.20.19 -> 2.20.20

- Added fork+setsid system calls to daemon mode
- rc.d script is now part of the distribution

Submitted by:	lemke@lemke-it.com (author)
Original commitRevision:379042 
Monday, 20 Oct 2014
10:41 bapt search for other commits by this committer
Cleanup plist
Original commitRevision:371255 
Saturday, 14 Jun 2014
20:14 pi search for other commits by this committer
databases/cego: 2.20.9 -> 2.20.10, USES libtool, strip libs

Submitted by:	lemke@lemke-it.com
Original commitRevision:357803 
Tuesday, 22 Oct 2013
04:55 danilo search for other commits by this committer
- Update from 2.19.6 to 2.19.7 [1]
- Add stage support [1]
- Convert LIB_DEPENDS to new syntax

PR:		ports/183128
Submitted by:	Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1]
Original commitRevision:331221 
Thursday, 23 May 2013
09:31 zeising search for other commits by this committer
Move devel/lfc to devel/lfcbase, to avoid conflicts with other software using
liblfc as name. [1]
Update devel/lfcbase to 1.5.4: [1]
  Several shared lib issues were addressed
  The license was changed from GPLv2 to GPLv3.

Update devel/lfcxml to 1.1.3 and chase the move of devel/lfc [2]

Update devel/dragon to 1.3.10 and chase the move of devel/lfc [3]

Update databases/cego to 2.18.6 and chase the move of devel/lfc [4]
  Several shared lib issues were addressed.
  The license was changed from GPLv2 to GPLv3.

Update databases/my2cego to 1.1.3 and chase the move of devel/lfc [5]
  Updated the autoconf setup
  Changed License from GPLv2 to GPLv3

PR:		ports/178745 [1]
		ports/178746 [2]
		ports/178747 [3]
		ports/178752 [4]
		ports/178754 [5]
Submitted by:	Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1-5]
Original commitRevision:318857 
Monday, 2 Jul 2012
06:48 culot search for other commits by this committer
- Update to 2.13.2 [1]
- Fix plist

PR:             ports/169589 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Original commit
Monday, 14 May 2012
19:20 culot search for other commits by this committer
- Update to 2.13.0

Changes:        http://www.lemke-it.com/cego_blog.html
PR:             ports/167838
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Original commit
Wednesday, 20 Jul 2011
12:57 culot search for other commits by this committer
- Update to 2.10.10 [1]
- Add missing entries to pkg-plist (cgbackup, cgmkdb and cgrecover)

PR:             ports/159054 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Original commit
Sunday, 1 May 2011
22:42 pav search for other commits by this committer
- Fix typo

Reported by:    pointyhat
Pointy hat to:  bapt (for committing without testing)
Original commit
Tuesday, 26 Apr 2011
13:01 bapt search for other commits by this committer
fix plist

Reported by:    pointyhat (pav and erwin)
Original commit
Sunday, 24 Apr 2011
09:54 bapt search for other commits by this committer
- update to 2.8.3
- use of USERS/GROUPS macros
- add rc script

PR:             ports/155405
Submitted by:   Kurt Jaeger <fbsd-ports _at_ opsec.eu> (maintainer)
Original commit
Friday, 1 Oct 2010
23:15 makc search for other commits by this committer
Update to 2.6.14

PR:             ports/150677
Submitted by:   Kurt Jaeger (maintainer)
Original commit
Wednesday, 18 Aug 2010
22:41 lwhsu search for other commits by this committer
- Update to 2.6.8

PR:             ports/149779
Submitted by:   Kurt Jaeger <fbsd-ports AT opsec.eu> (maintainer)
Original commit
Saturday, 24 Jul 2010
16:27 sahil search for other commits by this committer
- Update to 2.6.4 [1]
- Remove redundant DISTNAME assignment
- Remove license files from pkg-plist

PR:             ports/148518 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Original commit
Monday, 5 Jul 2010
13:31 sylvio search for other commits by this committer
- Update to 2.6.3

PR:             ports/148298
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe:   yes
Original commit
Sunday, 4 Jul 2010
14:40 sylvio search for other commits by this committer
- Update to 2.6.2

PR:             ports/148298
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe:   yes
Original commit
Thursday, 1 Jul 2010
05:49 miwi search for other commits by this committer
Cego is a Relational Database Management System (RDBMS). Cego
supports transactional SQL query requests in a multithreaded
architecture. For high availablility requirements, Cego supports a
database shadowing feature. Several compute nodes can be defined in
a Cego database configuration, where each node is able to manage a
number of so called table sets. For each tableset, a backup node
can be defined, which runs is recover mode for the corresponding
tableset. If required, the tableset can be switched to the backup
node and this node gets the active node for the tableset.

Many more details are available at:

WWW: http://www.lemke-it.com/

PR:             ports/147822
Submitted by:   Kurt Jaeger <fbsd-ports at opsec.eu>
Feature safe:   yes
Original commit

Number of commits found: 28