Jump to content

david berneda

Members
 View Profile  See their activity

  • Content Count

    38

  • Joined

  • Last visited

  • Days Won

    7

Everything posted by david berneda

  1. david berneda
    BIGrid2.Data := TGridify.From(BIGrid1.Data, 'Happiness', 'Year', 'Person') https://github.com/Steema/TeeBI/tree/master/demos/delphi/vcl/Grid/Gridify
  2. david berneda
    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;
  3. david berneda
    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. david berneda

    TeeGrid control, list of features

    david berneda posted a topic in Delphi Third-Party

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

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

    What is the best AI at Delphi

    david berneda replied to CoeurdeLeon's topic in VCL

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

    david berneda posted a topic in Delphi Third-Party

    Full free sources of TeeBI data-mining and visualization components for RAD Studio 12.3 released. Includes also installer tool and demos. https://github.com/Steema/Steema-BI-Samples
  12. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

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

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

    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
  15. david berneda
    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.
  16. david berneda
    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/
  17. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    TeeBI is now available at GetIt for RAD Studio 12: https://getitnow.embarcadero.com/teebi/ The listed "category" needs to be fixed, its not a "Trial" version but a fully functional, free opensource component library. More advanced demos and the BIWeb server sources are located at GitHub. The same installer detects and compiles TeeBI for other RAD versions you might have installed in your system.
  18. david berneda
    Hmm, I'm not sure if the free TeeChart Lite version has this, but sure the Pro version allows "sub axes" (what you say titles of 3 layers, are the TChart.Axes.Top (first layer with dates) and two sub axes added to it, one for hours, one for seconds. Cosmetics I think allow to match the screenshot with some customization, to some extent. Navigation (scroll, clicks, drag etc) are provided. More complex is (if I see the screenshot well) the ability to expand left side texts, like a tree/explorer of levels. It can also be done but its not as easy as a property or adding "children" rows to any row.
  19. david berneda
    TeeChart includes a basic Gantt series style with some features (resizing and moving tasks, cursors etc) but maybe not as complex as the screenshot you posted. Axes left and top are fully capable though. https://www.steema.com/docs/teechart/vclfmx/tutorials/UserGuide/html/manu8nsk.htm
  20. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    Updated sources, and a new simple demo with minimal code, import data, query it and display results. Zero code if you do it at design-time. https://github.com/Steema/TeeBI/tree/master/demos/start_here
  21. david berneda

    Physically reduce jpeg image size??

    david berneda replied to Ian Branch's topic in General Help

    You might try also the CompressionQuality property, 60% instead of 90% should reduce the size in bytes (losing quality of course) https://engineertips.wordpress.com/2021/11/27/delphi-resize-jpeg/ The Webp format is an alternative, it gets smaller size vs jpeg with the same quality, and there are Delphi libraries to do so in vcl (and fmx) https://github.com/Wykerd/delphi-webp
  22. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    Python and R plugin units are now published: https://github.com/Steema/TeeBI/tree/master/deprecated/sources/algorithms License is MIT: https://github.com/Steema/TeeBI/blob/master/LICENSE
  23. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    Yes, the features that needed Python have been deprecated and are no longer needed. The documentation will be updated to reflect this. I can upload the deprecated units at a separate folder just to archive them. Maybe in the future if there is demand it can be restored.
  24. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    Oops, you mean plugin units, or demos?
  25. david berneda

    TeeBI free full sources released

    david berneda replied to david berneda's topic in Delphi Third-Party

    Yes ! it will be posted soon, most probably MIT
×