FWD » Core Development » Database

01/28/2019

02:47 AM Feature #3758: misc database features

3750b/11317 adds basic runtime support for the {READ|WRITE}-JSON methods. Basic JSON import and export work with some... Eric Faulhaber

01/22/2019

12:16 PM Feature #3870: enhance conversion and import to make it feasible for multiple OpenEdge databases ...

Another concern is that ABL code may be written to explicitly CONNECT/DISCONNECT with a database that is to be merged... Eric Faulhaber

06:51 AM Feature #3758: misc database features

Eric Faulhaber wrote:
> What is the actual requirement in this regard? When does the transaction id need to be gener... Ovidiu Maxiniuc

01/21/2019

02:53 PM Feature #3758: misc database features

Ovidiu Maxiniuc wrote:
> The new implementation is largely based on the old code of @TransactionUpdater@, but the da... Eric Faulhaber

01:03 PM Feature #3758: misc database features

3750b was updated. The list of changes in 11303 is the following:
* added support for @CURRENT-CHANGED@, @FIND-CURRE... Ovidiu Maxiniuc

12:14 PM Bug #3896: improve performance of the _lock metadata implementation

Greg Shah wrote:
> Also, isn't the @_connect@ user-specific? If I recall, you can't see all the other user's connec... Eric Faulhaber

11:33 AM Bug #3896: improve performance of the _lock metadata implementation

All of these cases involve resources that only ever exist in limited numbers.
* transactions - one per user that i... Greg Shah

11:08 AM Bug #3896: improve performance of the _lock metadata implementation

> Can't we just enhance our current lock manager data structures to maintain enough information such that the @_lock@... Eric Faulhaber

10:46 AM Bug #3896: improve performance of the _lock metadata implementation

Most applications will almost never access the @_lock@ table. When it is used, generally it relates to a custom util... Greg Shah

10:33 AM Bug #3896: improve performance of the _lock metadata implementation

Another tweak on this idea is periodically (maybe once every minute or few minutes?) to flush the diff data to the da... Eric Faulhaber

10:22 AM Bug #3896: improve performance of the _lock metadata implementation

FWD's implementation of the @_lock@ metadata is too slow. The current implementation updates an in-memory H2 database... Eric Faulhaber

10:09 AM Bug #3896 (Closed): improve performance of the _lock metadata implementation

Eric Faulhaber

01/18/2019

09:29 AM Feature #3758: misc database features

> Where should I commit? My update is based on 3750a.
Please use 3750b. It is based on trunk 11298 (which is 3750a). Greg Shah

01/17/2019

08:02 AM Feature #3758: misc database features

Continuation:
The @DBTASKID@ function is related to @_trans@ VST. However, the relation is not 1:1. If, in a transac... Ovidiu Maxiniuc

01/16/2019

04:04 PM Feature #3758: misc database features

Status & notes:
> *BUFFER:FIND-CURRENT Method*
> Needs to be wired to existing, backing support in the persistence ... Ovidiu Maxiniuc

01/15/2019

12:45 PM Feature #3757: add metadata support

The attached code was delayed and dropped from working branch as @_ActLock@ is not needed for the current deadline. Ovidiu Maxiniuc

07:23 AM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

Yes, it was the cumulative content of 3791b plus stable parts that I was intending to commit there. Since that branch... Ovidiu Maxiniuc

01/14/2019

03:21 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

Ovidiu Maxiniuc wrote:
> The changes from 3791b were copied to 3791c as r11309. 3791b can be dropped.
There are a... Eric Faulhaber

03:10 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

The changes from 3791b were copied to 3791c as r11309. 3791b can be dropped. Ovidiu Maxiniuc

02:12 PM Bug #3651: regression in server startup when _connect metadata is active and a database is loaded...

Ovidiu Maxiniuc wrote:
> The fix for this issue was committed in 3791b, r11299.
Thanks for fixing this. Please mo... Eric Faulhaber

02:07 PM Bug #3651 (Feedback): regression in server startup when _connect metadata is active and a databas...

The fix for this issue was committed in 3791b, r11299. @BufferManager@ and @ConnectionManager@ are initialized in 2-s... Ovidiu Maxiniuc

12:28 PM Feature #3757: add metadata support

Most (if not all) of these missing metadata items seem to be for admin/monitoring/debugging/profiling purposes. I do... Greg Shah

08:31 AM Feature #3757: add metadata support

At the end of last week, I found the runtime support for following VST is currently missing from FWD:
* @_ActIndex@ ... Ovidiu Maxiniuc

10:20 AM Support #3871: determine how to change codepages/locales during import

Greg Shah wrote:
> Questions:
> 1. How do we control the encoding when we read the .d inputs? Do we have work here... Ovidiu Maxiniuc

01/11/2019

02:57 PM Feature #3872: implement a two stage import process

Users with very large databases might have import times that are longer than the outage window which can be arranged.... Greg Shah

02:37 PM Feature #3872 (New): implement a two stage import process

Greg Shah

12:54 PM Support #3871: determine how to change codepages/locales during import

> Regarding the import as UTF-8. Do we need special care for this? Don't we keep character data as Java Strings in me... Greg Shah

12:50 PM Support #3871: determine how to change codepages/locales during import

I am placing previous email discussions here.
From Greg:
> How much development is needed for FWD to support co... Greg Shah

12:45 PM Support #3871 (Closed): determine how to change codepages/locales during import

Greg Shah

12:42 PM Feature #3870: enhance conversion and import to make it feasible for multiple OpenEdge databases ...

Customers often have artificially split their single logical database into multiple physical database instances. Thi... Greg Shah

12:27 PM Feature #3870 (New): enhance conversion and import to make it feasible for multiple OpenEdge data...

Greg Shah

10:39 AM Feature #3757: add metadata support

Eric Faulhaber wrote:
> The current implementation causes a regression, in that the server will fail to start for an... Ovidiu Maxiniuc

09:40 AM Feature #3757: add metadata support

Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > I think the @_database-feature@ and @_startup._startup-locktable... Eric Faulhaber

01/08/2019

12:34 AM Feature #3757: add metadata support

Ovidiu Maxiniuc wrote:
> Yes, I think this can be done. The @RecordLockEvent@ received by @LockTableUpdater@ seems t... Eric Faulhaber

01/07/2019

04:05 PM Feature #3757: add metadata support

Eric Faulhaber wrote:
> I think the @_database-feature@ and @_startup._startup-locktable@ changes can be handled via... Ovidiu Maxiniuc

01/03/2019

03:07 PM Feature #3757: add metadata support

Greg Shah wrote:
> What runtime work is needed to complete this task?
I think the @_database-feature@ and @_start... Eric Faulhaber

01:13 PM Feature #3500: implement CLOB and BLOB support

Greg Shah wrote:
> What work is left in this task?
Basic LOB CRUD access is supported, but some language features... Eric Faulhaber