Jump to content

david berneda

Members
  • 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 Excellent

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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;
  2. BIGrid2.Data := TGridify.From(BIGrid1.Data, 'Happiness', 'Year', 'Person') https://github.com/Steema/TeeBI/tree/master/demos/delphi/vcl/Grid/Gridify
  3. TDataItem class is just four units, no dependencies, 100% Pascal code. It can be used standalone from TeeBI. uses BI.DataItem; var MyData := TDataItem.Create https://github.com/Steema/TeeBI
  4. Comprehensive list of TeeGrid features: https://github.com/Steema/TeeGrid-VCL-FMX-Samples/wiki/3.-Getting-Started TeeGrid is free for non-commercial use.
  5. 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;
  6. Visualize complex multi-dimensional data using #TeeBI Composer control. Minimal code, automatic output. https://github.com/Steema/TeeBI/tree/master/demos/delphi/Visualization/Composer
  7. Demo source code: https://github.com/Steema/TeeBI/tree/master/demos/delphi/Geographic/USA_Counties Note: This demo needs the "Pro" version of TeeChart.
  8. david berneda

    Calling routines overhead

    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.
  9. david berneda

    What is the best AI at Delphi

    I guess most Delphi code is private, never available to AI agents to train, something like dark-matter or dark-energy. A pity 😓
  10. 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;
  11. david berneda

    TeeBI free full sources released

    🤣🤣 And a youtube video ! Clarity first !
  12. david berneda

    TeeBI free full sources released

    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
  13. david berneda

    Vcl DBChart Line Series Set Line Thickness

    Series1.LinePen.Width := 3; should work fine
  14. 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.
  15. 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/
×