Jump to content

Alexander Sviridenkov

Members
  • Content Count

    253
  • Joined

  • Last visited

  • Days Won

    25

Everything posted by Alexander Sviridenkov

  1. 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/
  2. Alexander Sviridenkov

    Hunting a unit reference

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

    Hunting a unit reference

    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.
  4. Alexander Sviridenkov

    Hunting a unit reference

    Link to latest build: https://delphihtmlcomponents.com/graph.zip
  5. There are no tables. Query is executed directly on CSV file.
  6. 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).
  7. HTML Library / SQL framework: 0.33s. Zero lines of code)
  8. Alexander Sviridenkov

    Delphi 12 : Encoding Unicode strange behaviour

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

    Delphi 12 : Encoding Unicode strange behaviour

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

    Unit dependency viwer

    Unit dependency viewer for Delphi - small tool created using HTML Component Library and ForceAtlas2 algo. https://delphihtmlcomponents.com/graph.rar Video:
  11. https://docwiki.embarcadero.com/Libraries/Alexandria/en/System.Dispose
  12. Alexander Sviridenkov

    HTML Library 4.8 Released

    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.
  13. Alexander Sviridenkov

    20% Black Friday discount on HTML Library

    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
  14. Alexander Sviridenkov

    New User / New UI Tutorial

    https://www.helpandmanual.com/hx/index.html
  15. Alexander Sviridenkov

    Creating an output style from various data sources

    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/
  16. Alexander Sviridenkov

    Loading .webp images into tbitmap?

    Maybe this come from SKIA webp support?
  17. Alexander Sviridenkov

    Coming soon

    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.
  18. Alexander Sviridenkov

    Coming soon

  19. Alexander Sviridenkov

    Parallel Resampling of (VCL-) Bitmaps

    @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
  20. Alexander Sviridenkov

    Unit dependency viwer

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

    Unit dependency viwer

    Could you please show a screenshot?
  22. Alexander Sviridenkov

    Unit dependency viwer

    1.0.0.28 Show unit initialization order.
  23. Alexander Sviridenkov

    Coming soon

    No, this will be included in Reports (Bundle)
×