Difference between revisions of "User:BigChimp"

From Free Pascal wiki
Jump to navigationJump to search
(ppu stuff)
(Wiki/forum license)
Line 1: Line 1:
 
== Who? ==
 
== Who? ==
 
Just a guy fiddling with computers. I don't have a Delphi or formal programming background... but Lazarus/FreePascal really works for me!
 
Just a guy fiddling with computers. I don't have a Delphi or formal programming background... but Lazarus/FreePascal really works for me!
 +
 +
== Wiki/forum contributions license ==
 +
Unless explicitly indicated in the contribution itself, I herewith
 +
* place my past, present and future contributions to the Lazarus and FreePascal wikis and forums in the public domain. However, I won't accept any liability.
 +
* in jurisdictions where that is not possible, I grant permission to use them in any way (e.g. copying, modifying) but do not accept any liability.
  
 
== Database test framework run ==
 
== Database test framework run ==

Revision as of 10:38, 25 February 2014

Who?

Just a guy fiddling with computers. I don't have a Delphi or formal programming background... but Lazarus/FreePascal really works for me!

Wiki/forum contributions license

Unless explicitly indicated in the contribution itself, I herewith

  • place my past, present and future contributions to the Lazarus and FreePascal wikis and forums in the public domain. However, I won't accept any liability.
  • in jurisdictions where that is not possible, I grant permission to use them in any way (e.g. copying, modifying) but do not accept any liability.

Database test framework run

Ran database test framework for FPC trunk on 25 September 2012.

Remarks on some TTestFieldTypes tests:

  • TTestFieldTypes.TestInsertLargeStrFields tries to create a 16000 character field; UTF8 encoded Firebird dbs only support up to about 8000 characters (32768 bytes). So the same problem as the UTF8 field length issue.
  • TTestFieldTypes.TestCrossStringDateParam: exception invalid variant type cast=>conversion error or something? would require stepping through the code to find out what's wrong I suppose
  • TTestFieldTypes.TestTemporaryTable: fixed test; Firebird supports temp tables
  • TTestFieldTypes.TestLargeRecordSize: fields are 8192 chars; same issue as TTestFieldTypes.TestInsertLargeStrFields

todo: do the rest

SQLDB internals

dsMaxStringSize (e.g. in fields.inc) indicates maximum (string field)? size that an internal buffer provides. If a field is larger, a temporary buffer will need to be used.

Interesting things

  • Gdb 7.3.50 appears broken for i386 running with Lazarus since about 1.1; get invalid application or something when running under debugger. 7.2 (as distributed with current installers) does seem to work.

Perhaps worth having a look:

  • Firebird 3 driver (split out from ib); perhaps based on C++ code using SWIG
  • DB performance/stress testing
  • Visual SQL Query designer (see forum posts) => incorporate into database desktop

LCL documentation link:

  • Internal error 200306067: can happen with PPU loading (stale PPUs etc). Compile with -vut to show which unit loads are attempted.