Jump to content

Converty JSON to Array in fastest way


Recommended Posts

I am looking for way to convert json data into array in fastest way. I guess this could be done using regex.

This is my sample of json data:

Quote

{
    "invoices": [
        {
            "invoice_id": 28532595,
            "order_id": 151550993,
            "series_id": 454192,
            "type": "normal",
            "number": "1/ADE19/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 1,
            "postfix": "",
            "date_add": 1622534536,
            "date_sell": 1622429057,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 24.99,
            "total_price_netto": 21,
            "invoice_fullname": "",
            "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland",
            "invoice_nip": "DE814584193",
            "invoice_address": "Marcel-Breuer-Str. 12",
            "invoice_city": "München",
            "invoice_postcode": "80807",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 28735725,
            "order_id": 151551135,
            "series_id": 455582,
            "type": "normal",
            "number": "6/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 6,
            "postfix": "",
            "date_add": 1622534544,
            "date_sell": 1622484857,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 91.46,
            "total_price_netto": 74.3577,
            "invoice_fullname": "Diego Hel",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "An Der Son 112",
            "invoice_city": "Bracker",
            "invoice_postcode": "123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 2",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 3",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 287453274,
            "order_id": 1519521815,
            "series_id": 455482,
            "type": "normal",
            "number": "7/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 7,
            "postfix": "",
            "date_add": 1622534545,
            "date_sell": 1622485464,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 21.49,
            "total_price_netto": 17.4715,
            "invoice_fullname": "John Wick",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "Bluestreet 30",
            "invoice_city": "Some city",
            "invoice_postcode": "123123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "iphone 7",
                    "sku": "123",
                    "ean": "123123123aa",
                    "price_brutto": 21.49,
                    "price_netto": 17.4715,
                    "tax_rate": 23,
                    "quantity": 1
                }
            ]
        }
    ]
}

and I want to convert it into array with this structure:

429555375_arraystructure.png.2fd760ef902d253e75772426b94e34fa.png

any idea?

Link to comment
Share on other sites

  • Developers
26 minutes ago, maniootek said:

any idea?

Yes, but wondering if you even tried to look for the answer yourself before dumping the question here as there are several JSON udfs available? 

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to comment
Share on other sites

Yes I tried Json UDF and I can parse the json data into array but it takes too long time. My json files are large and I am trying to save some time. I think regex could be much faster to parse this data but I don't know to write the regex pattern. This is why I am looking for help in forum.

Link to comment
Share on other sites

  • Developers

So what about being way more specific and tell us what you have done, how long it takes now, post an example JSON file  etc etc etc .... 
It seriously can't be that hard to provide enough details so people can really help you and is it not like you are new around here. 

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to comment
Share on other sites

Thinking of faster json data parsing came up to my mind when I discovered that large files can be loaded to array very fast. I recently discovered function  _FileReadToArray which can load 1MB csv report file into array in less than 1second. Wondering now if I can achieve similar result with json data parsing.

At this moment I use JSON.au3 UDF downloaded from here:

Quote

There is not much code I use. I simply read json string into variable and then decode it. Then I use Json_ObjGet function to get needed data

Local $sJson = FileRead("test.json")
Local $oJson = Json_Decode($sJson)
Local $a_oJson = Json_ObjGet($oJson , "invoices")

for $i=0 to Ubound($a_oJson) - 1
    if Json_ObjGet(a_oJson[$i], "invoice_id") = "123" then MsgBox(0,0,1)
next

I just checked the time needed to parse the json data and result says that Json_Decode() function need 17.6seconds to load 1.7MB JSON file in my PC. I belive I can load the data faster. Or maybe I am wrong?

Edited by maniootek
Link to comment
Share on other sites

Did you try Chilkat UDF ?

Signature beginning:
Please remember: "AutoIt"..... *  Wondering who uses AutoIt and what it can be used for ? * Forum Rules *
ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Codefor other useful stuff click the following button:

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST APIErrorLog.au3 UDF - A logging Library * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 *

 

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskSchedulerIE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) * PDF Related:How to get reference to PDF object embeded in IE * IE on Windows 11

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

I also encourage you to check awesome @trancexx code:  * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuffOnHungApp handlerAvoid "AutoIt Error" message box in unknown errors  * HTML editor

winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2023-04-24

Link to comment
Share on other sites

Link to comment
Share on other sites

15 hours ago, mLipok said:

Did you try Chilkat UDF ?

I need to install some component to make it work, right?

15 hours ago, Nine said:

Maybe something along those lines ?

#include <Constants.au3>
#include <Array.au3>

Local $sJson = FileRead("Test.txt")
Local $aArray = StringRegExp($sJson, '("invoice_id"|"order_id"|"series_id"): (\d+)', 3)

_ArrayDisplay($aArray)

 

After some modification I have this code:

#include "Array.au3"

$json = FileRead("test.json")

;Local $aArray = StringRegExp($json, '"(.*)": (\[[^[]+]|[^,]+)', 4)
Local $aArray = StringRegExp($json, '"(.*)": ("([^""]+)"|\[[^[]+]|[^,]+)', 4)

_ArrayDisplay($aArray)

for $I=0 to Ubound($aArray) - 1
    _ArrayDisplay($aArray[$i])
Next

test.json:

Quote


        {
            "invoice_id": 28532595,
            "order_id": 151550993,
            "series_id": 454192,
            "type": "normal",
            "number": "1/ADE19/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 1,
            "postfix": "",
            "date_add": 1622534536,
            "date_sell": 1622429057,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 24.99,
            "total_price_netto": 21,
            "invoice_fullname": "",
            "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland",
            "invoice_nip": "DE814584193",
            "invoice_address": "Marcel-Breuer-Str. 12",
            "invoice_city": "München",
            "invoice_postcode": "80807",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 28735725,
            "order_id": 151551135,
            "series_id": 455582,
            "type": "normal",
            "number": "6/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 6,
            "postfix": "",
            "date_add": 1622534544,
            "date_sell": 1622484857,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 91.46,
            "total_price_netto": 74.3577,
            "invoice_fullname": "Diego Hel",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "An Der Son 112",
            "invoice_city": "Bracker",
            "invoice_postcode": "123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 2",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 3",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 287453274,
            "order_id": 1519521815,
            "series_id": 455482,
            "type": "normal",
            "number": "7/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 7,
            "postfix": "",
            "date_add": 1622534545,
            "date_sell": 1622485464,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 21.49,
            "total_price_netto": 17.4715,
            "invoice_fullname": "John Wick",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "Bluestreet 30",
            "invoice_city": "Some city",
            "invoice_postcode": "123123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "iphone 7",
                    "sku": "123",
                    "ean": "123123123",
                    "price_brutto": 21.49,
                    "price_netto": 17.4715,
                    "tax_rate": 23,
                    "quantity": 1
                }
            ]
        }
 

but it is much more slower, about 304seconds :(

Edited by maniootek
Link to comment
Share on other sites

The provided sample is malformed for a strict JSON parser. This fixes that:

Quote

{
    "invoices": [
        {
            "invoice_id": 28532595,
            "order_id": 151550993,
            "series_id": 454192,
            "type": "normal",
            "number": "1/ADE19/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 1,
            "postfix": "",
            "date_add": 1622534536,
            "date_sell": 1622429057,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 24.99,
            "total_price_netto": 21,
            "invoice_fullname": "",
            "invoice_company": "Amazon EU S.à r.l., Niederlassung Deutschland",
            "invoice_nip": "DE814584193",
            "invoice_address": "Marcel-Breuer-Str. 12",
            "invoice_city": "München",
            "invoice_postcode": "80807",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 28735725,
            "order_id": 151551135,
            "series_id": 455582,
            "type": "normal",
            "number": "6/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 6,
            "postfix": "",
            "date_add": 1622534544,
            "date_sell": 1622484857,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 91.46,
            "total_price_netto": 74.3577,
            "invoice_fullname": "Diego Hel",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "An Der Son 112",
            "invoice_city": "Bracker",
            "invoice_postcode": "123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "Some item name",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 2",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                },
                {
                    "name": "Some item name 3",
                    "sku": "123123",
                    "ean": "123123123",
                    "price_brutto": 24.99,
                    "price_netto": 21,
                    "tax_rate": 19,
                    "quantity": 1
                }
            ]
        },
        {
            "invoice_id": 287453274,
            "order_id": 1519521815,
            "series_id": 455482,
            "type": "normal",
            "number": "7/APL23/06/2021",
            "year": 2021,
            "month": 6,
            "sub_id": 7,
            "postfix": "",
            "date_add": 1622534545,
            "date_sell": 1622485464,
            "date_pay_to": 0,
            "currency": "EUR",
            "total_price_brutto": 21.49,
            "total_price_netto": 17.4715,
            "invoice_fullname": "John Wick",
            "invoice_company": "",
            "invoice_nip": "",
            "invoice_address": "Bluestreet 30",
            "invoice_city": "Some city",
            "invoice_postcode": "123123",
            "invoice_country": "Germany",
            "invoice_country_code": "DE",
            "seller": "My company\r\nStreet 123\r\n12345 City center\r\nVatid DE123123123",
            "payment": "Amazon",
            "additional_info": "",
            "correcting_to_invoice_id": 0,
            "correcting_reason": "",
            "correcting_items": false,
            "correcting_data": false,
            "external_invoice_number": "",
            "external_id": "",
            "exchange_currency": "PLN",
            "exchange_rate": 4.4845,
            "exchange_date": "2021-05-28",
            "exchange_info": "102/A/NBP/2021",
            "items": [
                {
                    "name": "iphone 7",
                    "sku": "123",
                    "ean": "123123123",
                    "price_brutto": 21.49,
                    "price_netto": 17.4715,
                    "tax_rate": 23,
                    "quantity": 1
                }
            ]
        }
    ]
}

Indeed, you want and array of invoices, each entry having an array of items.

You can load such a JSON data into an SQLite table using the json1 extension. From there it's easy to navigate, select, compute, change, remove thanks to SQLite power. You can as well build a table of invoices and a linked table of sold items.

Given that Amazon JSON uses a defined format for all invoices, things are pretty trivial.

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Link to comment
Share on other sites

7 hours ago, jchd said:

The provided sample is malformed for a strict JSON parser.

The original sample JSON was not malformed for a strict JSON parser.  It met all JSON formatting standards.  You only modified one line and that modification had nothing to do with strict-formatting.  The data may be bad, but it is strictly-formatted.

You changed:

"ean": "123123123aa",

to

"ean": "123123123",

Both values are strings, so it made no difference as it relates to strictly-formatted JSON?

 

Edit:

I see that you must have been referring to the last sample that was supplied.  As I stated, I was referring to the original sample that was posted.

Edited by TheXman
Highlighted that I referred to the original post's JSON, not the last sample.
Link to comment
Share on other sites

Doesn't it lack a closing bracket?

It contains a list of unnammed invoices. Turning that list into an array removes the need to give each a name (a different name, that is, for strict JSON).

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Link to comment
Share on other sites

1 hour ago, TheXman said:

You changed:

No, I didn't.

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Link to comment
Share on other sites

6 hours ago, maniootek said:

I need to install some component to make it work, right?

Yes. 

For JSON it is free as far as I remember.

Edited by mLipok

Signature beginning:
Please remember: "AutoIt"..... *  Wondering who uses AutoIt and what it can be used for ? * Forum Rules *
ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Codefor other useful stuff click the following button:

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST APIErrorLog.au3 UDF - A logging Library * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 *

 

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskSchedulerIE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) * PDF Related:How to get reference to PDF object embeded in IE * IE on Windows 11

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

I also encourage you to check awesome @trancexx code:  * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuffOnHungApp handlerAvoid "AutoIt Error" message box in unknown errors  * HTML editor

winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2023-04-24

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...