Jump to content

Alexander Sviridenkov

  • Content Count

  • Joined

  • Last visited

  • Days Won


Alexander Sviridenkov last won the day on March 10

Alexander Sviridenkov had the most liked content!

Community Reputation

329 Excellent

Recent Profile Visitors

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

  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. https://docwiki.embarcadero.com/Libraries/Alexandria/en/System.Dispose
  11. 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.
  12. 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
  13. Alexander Sviridenkov

    New User / New UI Tutorial