-
Content Count
38 -
Joined
-
Last visited
-
Days Won
7
david berneda last won the day on August 17
david berneda had the most liked content!
Community Reputation
50 ExcellentRecent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
TeeGrid example, create multiple sub-grid levels using FireDAC datasets. 🤓
david berneda posted a topic in Delphi Third-Party
Example sources: https://github.com/Steema/TeeGrid-VCL-FMX-Samples/tree/master/demos/FireMonkey/Database/Master_Detail_FireDAC TeeGrid can be easily programmed to display unlimited sub-grid levels. Just add an "expander" render to enable "+" and "-" clicks, and set an event to obtain your desired sub-rows. uses Tee.Renders; var Expander : TExpanderRender; Expander:=TeeGrid1.Grid.Current.NewExpander; -
TGridify, convert a flat table into a pivot-grid in one line of code
david berneda posted a topic in Delphi Third-Party
BIGrid2.Data := TGridify.From(BIGrid1.Data, 'Happiness', 'Year', 'Person') https://github.com/Steema/TeeBI/tree/master/demos/delphi/vcl/Grid/Gridify- 3 replies
-
- pivot-table
- datamining
-
(and 2 more)
Tagged with:
-
Comprehensive list of TeeGrid features: https://github.com/Steema/TeeGrid-VCL-FMX-Samples/wiki/3.-Getting-Started TeeGrid is free for non-commercial use.
-
TeeBI new free demo: One Billion cells in your laptop
david berneda posted a topic in Delphi Third-Party
https://github.com/Steema/TeeBI/blob/master/demos/experiments/bigdata/OneBillion/readme.md This demo shows TeeBI capabilities with big quantities of data, rows and cells. It first creates a default dummy database of One Billion cells (thousand millions). Data is saved to a disk file in your TEMP folder: "big_data.bi" (4.5GB) in aprox 4 seconds. Once data has been created it can be loaded again from disk in aprox 2.5 seconds. The "Query and Visualize" form uses this big data to do some visualizations. (Queries traversing so many millions of rows are not immediate, of course !) But you can run them in a normal laptop. // Sum the amount of Sales year by year, all rows: BIQuery1.Measures.Add(BigData['Sales']['Total'], TAggregate.Sum); BIQuery1.Dimensions.Add(BigData['Sales']['Date']).DatePart := TDateTimePart.Year; BIComposer1.Data := BIQuery1.Calculate; -
TeeBI Composer example, automatic visualization of complex data
david berneda posted a topic in Delphi Third-Party
Visualize complex multi-dimensional data using #TeeBI Composer control. Minimal code, automatic output. https://github.com/Steema/TeeBI/tree/master/demos/delphi/Visualization/Composer -
Demo source code: https://github.com/Steema/TeeBI/tree/master/demos/delphi/Geographic/USA_Counties Note: This demo needs the "Pro" version of TeeChart.
-
Calling routines overhead
david berneda replied to PeaShooter_OMO's topic in RTL and Delphi Object Pascal
The "if" inside the "for" is also taking time. Try with 2 for loops, one for direct and another for indirect. Also the indirect routine could be marked as "inline" to eliminate the call. This is fine for short small routines. -
I guess most Delphi code is private, never available to AI agents to train, something like dark-matter or dark-energy. A pity 😓
-
New TeeBI demo, one line of code calls the Google Gemini api and imports the results into normal TeeBI structures. These data then can be simple visualized or queried. The idea is to add more AI agents (ChatGPT etc) transparently in the near future. https://github.com/Steema/TeeBI/tree/master/demos/3rd_party/AI uses BI.AI, BI.DataItem; procedure TForm_AI_Demo.Button1Click(Sender: TObject); var Data1 : TDataItem; begin // One line of code, call Gemini and get a data structure: Data1:=TBIAI.From('your key', 'Give me the list of the highest 10 mountains by elevation in csv format, just the list', TBIAI.GoogleGemini); // Visualize it: BIGrid1.Data:=Data1; // in the grid BIChart1.Data:=Data1; // in the chart end;
-
TeeBI free full sources released
david berneda replied to david berneda's topic in Delphi Third-Party
🤣🤣 And a youtube video ! Clarity first ! -
TeeBI free full sources released
david berneda replied to david berneda's topic in Delphi Third-Party
Showcasing the TeeBI Query editor, drag and drop fields to create pivot tables of multiple dimensions, custom functions and features not available with SQL (like histograms, by code expressions, or using your functions and events to control the query "where/having" filters etc). Free and opensource: https://github.com/Steema/TeeBI -
Vcl DBChart Line Series Set Line Thickness
david berneda replied to Henry Olive's topic in General Help
Series1.LinePen.Width := 3; should work fine -
Chart Github users contributions with Delphi and TeeChart
david berneda posted a topic in Delphi Third-Party
Small example to access Github's contributions of a given user and display them using TeeChart. https://github.com/Steema/TeeChart-VCL-GitHub-Contributions This demo is made with VCL but almost identical code works in Firemonkey. -
Any VCL/FMX Gantt Chart or visual components that can have such functions
david berneda replied to ChrisChuah's topic in VCL
Just an alternative, TeeGrid can be used for gantt applications too. A customer from Canada recently sent us their app, the grid allows multiple top layers (columns and subcolumns, for year, month, date, etc) and rows (tasks) can contain children rows (unlimited levels, subtasks) with a "+" left column to expand / collapse. Tasks are then custom painted using the grid Canvas (Rectangle, Triangle, etc methods) using the columns coordinates. https://www.steema.com/product/gridvcl https://steema.com/wp/blog/2025/06/18/powering-precision-in-manufacturing-intelligence-dynafact-dms-with-teechart/