Alexander Sviridenkov

Small example of using custom HTML/JS inside Report control. JS code send pallet and boxes params to Server (Delphi), receive calculated pallet loading and display it. pallet.mp4

It's under development, just preview. Release is expected in May and will be included in HTML Library bundle for customers on subscription.

Memory is around 20Mb and doesn;t depend on file size. No SQLite or other external solutions are used, everything is written in plain Delphi - SQL parser, SQL execution classes, etc. https://delphihtmlcomponents.com/sql/

This is quite strange. Does unit map looks correct (all other units are present)?

Last version should show all files used in application, not only ones mentioned in .dpr. It starts from .dpr units and recursively find all units listed in inteface and implementation sections. Of course IDE Library path and projects paths settings are used when scanning. BTW it can extract interface and implementation units even if only .dcu is available.

Link to latest build: https://delphihtmlcomponents.com/graph.zip

There are no tables. Query is executed directly on CSV file.

Scaling is not linear there. Real 10^9 file (16.5 Gb) is processed in 15 minutes (936 sec) on Ryzen 5 4600H notebook (single thread).

HTML Library / SQL framework: 0.33s. Zero lines of code)

Yes, two or four (for symbols behind BMP).

Unicode (UTF16) symbol size is at least 2 bytes, so after deleting 1 byte string became incorrect.

https://docwiki.embarcadero.com/Libraries/Alexandria/en/System.Dispose

var p: PMyRec; New(p);

Delphi 12 support. New htide unit - installed Delphi versions, Library paths, PAS and DCU parsing, etc. New demo (/Sample Projects/graph) - Unit dependency viewer. Video: https://youtu.be/ec0pOy2uY4w Compiled demo: https://delphihtmlcomponents.com/graph.zip Cairo canvas support on Linux and Windows for Delphi and Lazarus. Canvas supports precise text rendering so PDF and other documents converted by HTML Office library now can be properly displayed on Linux. PDF export on Linux via Cairo. Reports library now supports Lazarus Big upgrade of SQL framework: perform SQL queries on CSV and text files, JSON, XML, Excel, Outlook, SQL scripts and other sources. Video: https://www.youtube.com/watch?v=IzV9jZe6ksQ Compiled demo: https://delphihtmlcomponents.com/sqltest.zip Manual: https://delphihtmlcomponents.com/sql/ What it can do: Convert to/from CSV, JSON, XML, HTML, Excel, SQL script. Upload files/objects to database Export data from database Check data consistency Display data/objects in DB-aware controls, HtPanel, StringGrid, VirtualTreeview, ControlList Extend database capabilities (f.e. use Pivot in Firebird). Serialize and deserialize objects Reduce calls to REST server by using already loaded data. Supported data sources: CSV file JSON file JSON string XML file HTML file Text file with fixed size fields SQL script ZIP archive XLS/XLSX Excel sheet (requires HTML Office Library). Outlook PST/OST file (requires HTML Office Library). TList<T> TObjectList Any class with IEnumerable or GetEnumerator support TDataset array of T SQL Query Custom sources can be added by implementing IDMDatasource interface. Supported dialects: SQL 92 Oracle MS SQL Server Firebird MySQL PostrgesSQL SQLite ElevateDB Result can be exported to CSV XML JSON SQL script TDataset TStringList TObjectList SQL table HTML (plain table or using template) Array of variant Binary file or any other format, using custom processing of result data.

One day 20% discount on HTML Component Library, HTML Editor Library, Bundle (Editor + Reports) and HTML Office Library. Please use coupon code BF2023 https://delphihtmlcomponents.com/order.html

https://www.helpandmanual.com/hx/index.html

AFAIK this list is created using TControlList component. If you want to use HTML and create more complex layouts, there is HTML Component Library that allows to use HTML in Delphi controls and create layouts of any complexity. https://delphihtmlcomponents.com/

Maybe this come from SKIA webp support?

Sample test application for SQL framework. https://delphihtmlcomponents.com/sqltest.rar What it can do? Extract and transform data directly from Excel, CSV, JSON and XML files and archives. How to use: choose file or folder and write SQL query. Example: select all data from Excel sheet (sample.xlsx is included): select * from sample.sheet1 List of countries (we should exclude first row with caption using _row pseudo field). select distinct b from sample.sheet1 where _row > 0 Calculate sum of sales by country select B country, sum(H) sales from sample.sheet1 where _row > 0 group by 1 Countries (B) present in both segments (A) select B from sample.sheet1 where A = 'Government' intersect select B from sample.sheet1 where A = 'Midmarket' JSON file (customers.json is included): select * from customers where email like '%.ca' Using joins (sales_data.zip is included, it contains four JSON files: sales, orders, customers and products): select c.name, o.orderId, o.date, p.name, s.quantity from sales_data.sales s join sales_data.orders o on o.orderid=s.orderid join sales_data.customers c on c.customerid=o.customerid join sales_data.products p on p.productid=s.productid Calc percent from max quantity select c.name, o.orderId, o.date, p.name, round(100 * s.quantity / (select max(cast(quantity as float)) from sales_data.sales)) qpercent from sales_data.sales s join sales_data.orders o on o.orderid=s.orderid join sales_data.customers c on c.customerid=o.customerid join sales_data.products p on p.productid=s.productid List of products by order select o.orderId, o.date, list(p.name, ', ') products from sales_data.sales s join sales_data.orders o on o.orderid=s.orderid join sales_data.products p on p.productid=s.productid group by 1, 2 XML (cust.xml example included). Sometimes XML files has comples structure and contain different objects. To select only necessary objects we use XPATH. Also XPATH can be used in field names: select CustomerID, "/CompanyName" Company, "/FullAddress/City" City from cust('/Customers/Customer') Join with orders in the same file: select c.CustomerID, c."/CompanyName" Company, c."/FullAddress/City" City, cast(o."/OrderDate" as Date) OrderDate from cust('/Customers/Customer') c join cust('/Orders/Order') o on o."/CustomerID" = c.CustomerID CSV (survey.csv is included) Same naming scheme as for Excel. Excample: top 10 industries by income select C industry, sum(H) income from survey where F = 'Total income' group by 1 order by 2 desc rows 1 to 10 What is supported: select from select join, left join union, union all, intersect distinct, order by, group by, rollup, having first skip last rows limit fetch nulls last sum, max, min, avg, list/listagg = <> > >= < <= + - * / mod || in between like not like starting with and or exists, any, some, all subselects cast, decode, iif, case, coalesce Almost all Firebird funcions https://firebirdsql.org/refdocs/langrefupd21-intfunc.html, Oracle and MSSQL functions.

@Renate Schaaf just for reference: I've implemented blur using two pass box blur and SIMD, speed is 20ms for 3000x1200 image (180 000 000 px/sec). Here is compiled sample: delphihtmlcomponents.com/blur.zip

Thank you. Just uploaded 1.0.0.29 - fixed black ellipses and reverted layout to initial settings.

Could you please show a screenshot?

1.0.0.28 Show unit initialization order.