{"id":11630,"date":"2018-09-07T10:38:44","date_gmt":"2018-09-07T08:38:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/"},"modified":"2025-10-24T09:26:21","modified_gmt":"2025-10-24T07:26:21","slug":"a-sqlite-extension-for-gawk-part-iii","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/","title":{"rendered":"A SQLite extension for gawk (part III)"},"content":{"rendered":"

Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here<\/a>. Part II is here<\/a>.
\nIn this final part, I’ll explain succinctly the code that was listed in part II.
\nThis part is best read while having Part II opened in another browser window.<\/p>\n

sqlite_gawk.c<\/h3>\n

Line 48: All the operations on a database requires a handle that is initialized once the database is successfully opened. The handle is of type (sqlite3 *). Obviously, gawk does not know pointers; therefore what gets returned to gawk after a database has been opened is an integer which is an index into a static array of (sqlite3 *). The array has a fixed size of 100 for up to 100 concurrently opened database, which should be largely enough (if not, just increase MAX_DB on line 46 and recompile, or implement a dynamically resizable array instead). When a database is closed, the free slot is of course recycled for the next database to open.<\/p>\n

Line 56: Some initialization is performed, mostly of the array of database handles.<\/p>\n

Lines 77 to 315: this code has been lifted from sqlite3.c, the SQLite shell, and only slightly edited. It provides the SQL extension functions readfile() (read file into a blob) and writefile() (dumps a blob into file) for working with blobs from SQL statements. These functions can then be used seamlessly as follows:
\n
\nINSERT INTO test_with_blob(n1, my_blob) VALUES(1, readfile(\"gawk-4.2.1.tar.gz\")
\nSELECT n1, writefile('yy' || rowid, my_blob) FROM test_with_blob
\nUPDATE test_with_blob set my_blob = readfile('\/home\/dmadmin\/dmgawk\/gawk-4.2.1\/extension\/sqlite_gawk.c') where n1 = 1000
\n<\/code>
\nSQLite makes it possible to extend the set of functions that can be called in SQL statements. The function sqlite3_create_function() allows to register a new user-defined function, which must comply with a standard profile. Afterwards, they are invoked by SQLite as callbacks if they are present in SQL statements. This is not an exclusive feature since Oracle for example allows such functions but they are stored functions written in PL\/SQL (or in java or C\/C++ for external procedures with a PL\/SQL interface to the database). SQLite even allows those user-defined functions to perform aggregation like the usual sum(), count() or avg() functions, which is useful for example to supply the missing stddev() function.
\nreadfile() works with a buffer allocated from memory with the same size as the file to read, which can can be problematic with huge files, but blob size is currently limited to about 10^9 bytes by the compilation, and to about 2 GiB by the implementation (see the limits here<\/a>). A readfile() test with a 900 millions bytes file worked flawlessly (see the test script tsqlite.awk). In memory challenged machines, SQLite incremental blob I\/O functions have been put to good use to work with smaller buffers (see overloadd function sqlite_exec() starting at line 406).<\/p>\n

Line 323: get_free_sqlite_handle() is called each time a database is opened. It returns the index of the next free slot in the array of database handles. It does a sequential search in the array but again a maximum of 100 opened database are currently supported, so it is acceptable.<\/p>\n

Line 335: do_sqllite_open() is the interface’s wrapper around SQLite sqlite3_open(). It passes it the name of the database and, if successful, receives a database handle. SQLite databases are entirely contained in one file and no password are needed to open it. The received handle is saved into the array of handles and its index is returned to gawk for future use. When gawk calls another function for the opened database, it passes this index to the function which looks into the array for the corresponding handle, which is used to talk to SQlite functions.
\nIn do_sqllite_open(), the readfile() and writefile() user-defined functions are registered to be used in SQL statements as callbacks.<\/p>\n

Line 387: do_sqlite_close() closes a database and marks the slot in the array of handles as available. Nothing special here.<\/p>\n

Line 406: do_sqllite_exec(). This is a big one as, in addition to the expected DML\/DDL statements, it also deals with incremental blob I\/Os. It implements both acceptations of the gawk function sqlite_exec(). Both are distinguishable from each other by the number of parameters they take:
\n1. int sqlite_exec(db, stmt);
\n2. sqlite_exec(db, db_name, table, blob_column, rowid, “readfile(file_name)” | “writefile(file_name)”);
\nThe first version takes 2 parameters, the database handle and the expected DML\/DDL statement to send to the database. It returns 0 if OK and -1 if not.
\nThe second one is for incremental blob I\/Os and takes 6 parameters:
\nthe database handle;
\nthe database name; this is an surprising one but is required later by SQLite in function sqlite3_blob_open() documented here<\/a>. It is a symbolic name (not the file name of the opened database) and must be set to either “main” for the main database, to “temp” for a temporary table, and to the name after the AS clause for ATTACHed databases (see here<\/a>).
\nthe triplet (table, column, rowid) is also required to identify the blob to access;
\nthe last parameter tells the operation to perform on the blob, either update it with a content of from a file (parameter “readfile(filename)”) or dump it to a file (parameter “writefile(filename”)). Here, contrary to what has been said for lines 77 to 315, readfile and writefile are not user-defined SQL extensions but just place-holders for the requested operations. An alternative syntax could have been:
\n
\nsqlite_exec(db, db_name, table, blob_column, rowid, \"read\" | \"write\", file_name);
\nor
\nsqlite_exec(db, db_name, table, blob_column, rowid, \"load\" | \"dump\", file_name);
\n<\/code>
\nbut it was felt that reusing the verbs readfile() and writefile() was more standard, albeit admittedly a bit weird.
\nThe filename between the parentheses should not be quoted for the real parameters to sqlite_exec() are the strings “readfile(filename)” or “writefile(filename)”. Internally, cf. starting at line 500, they are parsed and the operation and the filename get extracted from the strings; see regular expressions strings *RE_readfile and *RE_writefile.
\nWhen reading into an existing blob, SQLite does not allow its size to be changed in function sqlite3_blob_write(), therefore the blob is first UPDATEd with a value of the new size. This is done by assigning it zero bytes via the SQLite function zeroblob() during the UPDATE; this function is efficient in that it does not need to first instantiate a memory buffer of that size and fill it with zeros before assigning it to the blob. Once the blob is updated, it must be reopened.<\/p>\n

Line 573 and 605: For an efficient transfer of data between the file and the blob, a 10 MiB large memory buffer is allocated.
\nOverall, there are a lot of goto statements in this function. Don’t be shocked or disgusted and rather consider them as “exit

Line 678: All the data functions that displays results from a SQL SELECT statement are actually callbacks; they are invoked by SQLite sqlite3_exec() from within the extension do_sqlite_select() and must comply to a precise profile. In order to keep some control of their behavior from our own code, it is possible to pass them a pointer to some data, which is the purpose of the DISPLAYED_TABLE C struct. It contains formatting parameters and on familiar-to-awker variable, NR, which gets updated by the callbacks at each call. sqlite3_exec() invokes the callback for each row that it fetches from the database, and the callback (all the select_callback_* except select_callback_array which stores it into a gawk associative array, more on this later) displays that row according to the parameters in struct DISPLAYED_TABLE. The callbacks are:
\n
\nselect_callback_raw()
\nselect_callback_draft()
\nselect_callback_sized()
\nselect_callback_array()
\n<\/code>
\nEach of these displays the rows with its particular format, as discussed in here<\/a>, so I won’t repeat myself here. As it is expected, presentation code is always quite lengthy, especially for all this line-truncation with or without ellipsis, and line-wrapping.<\/p>\n

Line 960: An interesting functionality, much shorter to implement since no presentation is required, is storing the rows into a gawk associative array, done in function select_callback_array(). When gawk invokes sqlite_select() with 4 parameters (the 3rd is a dummy one introduced just to tell the acceptations apart), select_callback_array() is selected as sqlite3_exec()’s callback, e.g.:
\n
\nsqlite_select(db, \"select rowid from test_with_blob where n1 = 1000 limit 1\", 0, a_test)
\n<\/code>
\nThe associative array a_test receives the rows and columns and stores them as shown in the function’s comment. On lines 1000 to 1011, another approach was attempted, which however I couldn’t make work. This is not so bad as it looked a bit weird. It consisted in programmatically creating the gawk array (with a the given name) and injecting it into the gawk script so that it would magically appear in the script’s global variables. The gawk call would have been:
\n
\nsqlite_select(db, \"select rowid from test_with_blob where n1 = 1000 limit 1\", 0, \"a_test\"<\/em><\/strong>)
\n<\/code>
\nNote the string “a_test”, the name of the array to create. Upon returning, an array with that name would have been created and added to the script’s symbol table, and could be accessed as usual through a_test[line<\/em>][col<\/em>]. Currently, the array must already exist and have been “typed” as an array in the gawk script, which is more natural. The array is then filled using gawk’s extension API as documented in the Gawk Manual.<\/p>\n

Line 1190: do_sqlite_select() terminates by directly invoking the callbacks to give them the opportunity to print an epilogue such as the number of processed rows or optimum column widths (by select_callback_draft()).
\nLine 1206: the extension functions are registered in gawk as usual. Note the varying arities, do_sqlite_exec() takes from 2 to 6 parameters while do_sqlite_select() takes from 2 to 4 parameters.<\/p>\n

tsqlite.awk<\/h3>\n

This is the gawk test script.<\/p>\n

Line 6: the SQLite extension is loaded here. The name is the one that was given to it on line 1218 of sqlite_gawk.c.<\/p>\n

Line 9 to 20: Database opening is tested here. Apparently, it is not a problem to have the same database opened several times. In effect, SQLite allows concurrent reading but locks the entire database when a writing is performed; its concurrency is far limited here but in practice it is not a problem as the locks stay for a few milliseconds only.<\/p>\n

Line 23: sqlite_exec() is tested with a DDL statement. Actually, SQLite allows to insert any value in a column, even though the types and sizes don’t match. It uses type affinity to convert between types (see here<\/a> for details). It’s even possible to store a blob in a CHAR(10) column.<\/p>\n

Lines 26 to 37: sqlite_exec() is tested with a few DML statements.<\/p>\n

Lines 40 to 51: The select into a gawk array feature is tested. A dummy 3rd parameter is inserted to force the select_callback_array() callback to be invoked. The result is output through 2 ways: the dumparray() function from the manual (its code is given at the end of the script), a function that uses the gawk isarray() introspection function to recursively display an array (and possibly, of array of … etc.). This test confirms that the receiving array has the right structure, an integer-indexed array of associative arrays indexed by column names.<\/p>\n

Lines 53 to 112: we test the different output formats from the other 3 callbacks select_callback_raw(), select_callback_draft() and select_callback_sized(). As said, these functions are selected based on the type and number of parameters of the overloaded function sqlite_select()<\/p>\n

Line 114: sqlite_exec() tests the DELETE DML statement. To be noted that SQLite performs a TRUNCATE TABLE optimization here when no condition is present (i.e. there is no WHERE clause).<\/p>\n

Lines 126 to 181: we test the blob operations through the SQL extension functions readfile() and writefile(). Files of different sizes, up to 990 million bytes are stuffed into a blob with no problem, except the ingestion time is quite perceptible for big files. As said before, the implementation of the readfile() function that reads data from a disk file int a blob allocated a buffer in memory to entirely held the file. If it fails, incremental blob I\/O functions are available, read on.<\/p>\n

Lines 183 to 200: They test the incremental blob I\/O functions. These allow to work around any memory size problem as they use a fixed-sized 10 MiB buffer insted of allocating one the size of the file to read in or one for the blob to dump out. As sqlite_exec() needs here the blob’s rowid, it must first be read through a SELECT statement. The received value is passed into a gawk array a_test in a_test[0][“rowid”], ie. the result has one row only (stored in a_test[0]) and this row has only one column, named “rowid”. The currently opened database has the alias “main”. On line 191, note how writefile(filename<\/em>) is quoted so the function is not evaluated by the gawk interpreter but passed through to do_sqlite_exec(). Note also how filename<\/em> is not quoted, it does not need to be; it may look strange though and if this is insufferable just edit the REs on lines 501 and 502 of the extension to add them. Beware that they’ll be enclosed between an already quoted string so some escaping might be necessary to placate gawk’s parsing.<\/p>\n

Lines 201 to 214: We are testing the on-screen formatting of the columns when a large chunk of text from a blob is displayed. We noticed that if the text contains line feeds, it corrupts the display; this why the replace() SQL function is used on line 210 to change it to the literal string “\\n”, which won’t be interpreted by the terminal.<\/p>\n

Line 216: The database is closed.<\/p>\n

A stress test<\/h3>\n

How about stressing SQLite and it gawk interface a little bit ? Here is a very simple script that recursively scans a given file directory up to a predefined depth and inserts the file entries, a few metadata and content, into a table.<\/p>\n

\n# stress test program for the sqlite_gawk, interface to sqlite3;\n# Cesare Cervini\n# dbi-services.com\n# 8\/2018\n\n# the test consists in scanning a disk directory for specifed files and loading into a sqlite db table all the files's metadata and content;\n# the database stress-test.db must have been created beforehand;\n# the used table will be created by the test;\n# Usage:\n#   AWKLIBPATH=gawk-4.2.1\/extension\/.libs find ~\/ -type f -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk-4.2.1\/gawk -f stress_sqlite.awk\n# or (if if AWKLIBPATH is defined appropriately or the SQLite extension has been deployed on system-wide):\n#   find ~\/ -type f -L -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk -f stress_sqlite.awk\n# for testing:\n#    max_depth=5; limit=10; AWKLIBPATH=gawk-4.2.1\/extension\/.libs find ~\/ -maxdepth $max_depth -type f -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk -v limit=$limit -f stress_sqlite.awk\n#\n\n@load \"sqlite_gawk\"\n\nBEGIN {\n   my_db = sqlite_open(\"\/home\/dmadmin\/dmgawk\/stress-test.db\")\n   print \"my_db =\", my_db, \"after db opened\"\n\n   rc = sqlite_select(my_db, \"SELECT sqlite_version()\", 20)\n   printf \"n\"\n\n   rc = sqlite_exec(my_db, \"DROP TABLE IF EXISTS stress\")\n   rc = sqlite_exec(my_db, \"vacuum\")\n\n   rc = sqlite_exec(my_db, \"CREATE TABLE stress(\" \n                                                \"file_type CHAR,\"     \n                                                \"permissions TEXT,\"   \n                                                \"owner_name TEXT,\"    \n                                                \"group_name TEXT,\"    \n                                                \"file_size NUMBER,\"   \n                                                \"file_date DATE,\"     \n                                                \"file_name TEXT,\"     \n                                                \"content_type TEXT,\"  \n                                                \"content BLOB)\")\n   print \"return code=\", rc, \"after table creation\"\n   printf \"n\"\n}\n{\n   file_type = substr($1, 1, 1)\n   permissions = substr($1, 2)\n   owner_name = $2\n   group_name = $3\n   file_size = $4\n   file_date = $5 \" \" $6\n   file_name = $7\n   cmd = \"file -b \" $7; cmd | getline content_type; close(cmd)\n  \n   stmt = sprintf(\"INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", %s)\",\n                                      file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, \"readfile('\" file_name \"')\")\n   print stmt\n   rc = sqlite_exec(my_db, stmt)\n   printf(\"return code=%d after insertionnn\", rc)\n\n   if (NR >= limit)\n      exit\n}\nEND {\n   printf \"n\"\n   rc = sqlite_select(my_db, \"SELECT file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, CASE WHEN instr(content_type, 'ASCII text') > 0 THEN \" \n                             \"CASE WHEN length(content) > 200 THEN replace(replace(replace(substr(content, 1, 200) || '...', 'n', '\\n'), 't', '\\t'), 'r', '\\r') ELSE replace(replace(replace(content, 'n', '\\n'), 't', '\\t'), 'r', '\\r') END ELSE substr(hex(content), 1, 200) || '...' END as text FROM stress\", 0, my_array)\n   print \"return code = \", rc, \"after select into array\"\n   dumparray(\"my_array\", my_array)\n\n   printf \"n\"\n   rc = sqlite_select(my_db, \"SELECT file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, CASE WHEN instr(content_type, 'ASCII text') > 0 THEN \" \n                             \"CASE WHEN length(content) > 200 THEN replace(replace(replace(substr(content, 1, 200) || '...', 'n', '\\n'), 't', '\\t'), 'r', '\\r') ELSE replace(replace(replace(content, 'n', '\\n'), 't', '\\t'), 'r', '\\r') END ELSE substr(hex(content), 1, 200) || '...' END as text FROM stress\", \"9 11 10 10 9 16 30w 12w 50w\")\n   print \"return code = \", rc, \"after select\"\n\n   printf \"n\"\n   rc = sqlite_close(my_db)\n   print \"return code=\", rc, \"after closing database\"\n}\n\nfunction dumparray(name, array, i) {\n   for (i in array)\n      if (isarray(array[i]))\n         dumparray(name \"[\"\" i \"\"]\", array[i])\n      else\n         printf(\"%s[\"%s\"] = %sn\", name, i, array[i])\n}\n<\/pre>\n
One line 23, the version of SQLite is printed; it should be 3.24.0.
\nOn line 28, the stress table is created with a suitable structure to accept the files’ metadata of interest as output by the “ls -l” command, e.g.:
\n
\n-r-xr-xr-x 1 dmadmin dmadmin 1641005 2017-01-26 05:14 \/home\/dmadmin\/oracle\/instantclient_12_2\/libsqlplusic.so
\n<\/code>
\nLines 43 to 50 extract into variables the metadata from each line of input to gawk from the find command. This intermediary step has been introduced for clarity as $* variables could directly be used on line 52.
\nLine 52 builds the INSERT SQL statement that gets passed to line 55 for execution.
\nLine 58 checks whether the file count limit has been reached and aborts the loop is so.
\nFinally, line 63 extracts the content of the stress table into an array which is dumped on line 66 and line 69 displays it in such a way that the output is not too messy.<\/p>\n
Here is an example of the result:
\n
\nmax_depth=5; limit=20; find ~\/ -maxdepth $max_depth -type f -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk -v limit=$limit -f stress_sqlite.awk
\nmy_db = 0 after db opened
\nsqlite_version()
\n--------------------
\n3.24.0
\n1 rows selected<\/p>\n
return code= 0 after table creation<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"2009\", \"2017-11-17 18:16\", \"\/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.err\", \"ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.err'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"1309\", \"2017-11-17 19:25\", \"\/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.out\", \"ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.out'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"2973490\", \"2017-11-17 19:29\", \"\/home\/dmadmin\/oraInventory\/logs\/installActions2017-11-17_06-11-23PM.log\", \"ASCII text, with very long lines\", readfile('\/home\/dmadmin\/oraInventory\/logs\/installActions2017-11-17_06-11-23PM.log'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"292\", \"2017-11-17 19:26\", \"\/home\/dmadmin\/oraInventory\/ContentsXML\/libs.xml\", \"XML 1.0 document, ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/ContentsXML\/libs.xml'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"468\", \"2017-11-17 19:25\", \"\/home\/dmadmin\/oraInventory\/ContentsXML\/inventory.xml\", \"XML 1.0 document, ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/ContentsXML\/inventory.xml'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"329\", \"2017-11-17 19:26\", \"\/home\/dmadmin\/oraInventory\/ContentsXML\/comps.xml\", \"XML 1.0 document, ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/ContentsXML\/comps.xml'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"60\", \"2017-11-17 19:26\", \"\/home\/dmadmin\/oraInventory\/oraInst.loc\", \"ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/oraInst.loc'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwx---\", \"dmadmin\", \"dmadmin\", \"1661\", \"2017-11-17 19:26\", \"\/home\/dmadmin\/oraInventory\/orainstRoot.sh\", \"POSIX shell script, ASCII text executable\", readfile('\/home\/dmadmin\/oraInventory\/orainstRoot.sh'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw----\", \"dmadmin\", \"dmadmin\", \"362\", \"2017-11-17 18:16\", \"\/home\/dmadmin\/oraInventory\/oui\/srcs.lst\", \"XML 1.0 document, ASCII text\", readfile('\/home\/dmadmin\/oraInventory\/oui\/srcs.lst'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-------\", \"dmadmin\", \"dmadmin\", \"4747\", \"2018-09-01 13:59\", \"\/home\/dmadmin\/.sqlite_history\", \"assembler source, ASCII text\", readfile('\/home\/dmadmin\/.sqlite_history'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw-r--\", \"dmadmin\", \"dmadmin\", \"176\", \"2018-08-08 22:49\", \"\/home\/dmadmin\/mp-fact.awk\", \"ASCII text\", readfile('\/home\/dmadmin\/mp-fact.awk'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"24951775\", \"2016-11-04 12:13\", \"\/home\/dmadmin\/setup_files\/dfcUnix.zip\", \"Zip archive data, at least v1.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/dfcUnix.zip'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"2179169\", \"2016-11-04 12:24\", \"\/home\/dmadmin\/setup_files\/serviceWrapperManager.jar\", \"Java archive data (JAR)\", readfile('\/home\/dmadmin\/setup_files\/serviceWrapperManager.jar'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"53170976\", \"2005-03-23 15:29\", \"\/home\/dmadmin\/setup_files\/53\/dfcSetup.jar\", \"Zip archive data, at least v2.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/53\/dfcSetup.jar'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"129883\", \"2005-03-20 08:29\", \"\/home\/dmadmin\/setup_files\/53\/consistency_checker.ebs\", \"ASCII text, with CRLF line terminators\", readfile('\/home\/dmadmin\/setup_files\/53\/consistency_checker.ebs'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rw-rw-r--\", \"dmadmin\", \"dmadmin\", \"803\", \"2017-11-28 09:44\", \"\/home\/dmadmin\/setup_files\/53\/init53\", \"ASCII text\", readfile('\/home\/dmadmin\/setup_files\/53\/init53'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"174586519\", \"2005-03-23 20:16\", \"\/home\/dmadmin\/setup_files\/53\/server.jar\", \"Zip archive data, at least v2.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/53\/server.jar'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"9843412\", \"2004-12-03 01:25\", \"\/home\/dmadmin\/setup_files\/53\/tomcat4127Setup.jar\", \"Zip archive data, at least v2.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/53\/tomcat4127Setup.jar'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"5587942\", \"2005-03-23 15:27\", \"\/home\/dmadmin\/setup_files\/53\/bofcollaborationSetup.jar\", \"Zip archive data, at least v2.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/53\/bofcollaborationSetup.jar'))
\nreturn code=0 after insertion<\/p>\n
INSERT INTO stress(file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, content) VALUES(\"-\", \"rwxrwxr-x\", \"dmadmin\", \"dmadmin\", \"5900841\", \"2005-03-23 15:27\", \"\/home\/dmadmin\/setup_files\/53\/bofworkflowSetup.jar\", \"Zip archive data, at least v2.0 to extract\", readfile('\/home\/dmadmin\/setup_files\/53\/bofworkflowSetup.jar'))
\nreturn code=0 after insertion<\/p>\n
20 rows selected
\nreturn code =  0 after select into array
\nmy_array[\"0\"][\"owner_name\"] = dmadmin
\nmy_array[\"0\"][\"file_type\"] = -
\nmy_array[\"0\"][\"group_name\"] = dmadmin
\nmy_array[\"0\"][\"permissions\"] = rw-rw----
\nmy_array[\"0\"][\"text\"] = java.lang.NullPointerExceptionntat oracle.sysman.oii.oiin.OiinNetOps.addNICInfo(OiinNetOps.java:144)ntat oracle.sysman.oii.oiin.OiinNetOps.computeNICList(OiinNetOps.java:109)ntat oracle.sysman.oii.oii...
\nmy_array[\"0\"][\"file_name\"] = \/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.err
\nmy_array[\"0\"][\"file_size\"] = 2009
\nmy_array[\"0\"][\"file_date\"] = 2017-11-17 18:16
\nmy_array[\"0\"][\"content_type\"] = ASCII text
\nmy_array[\"1\"][\"owner_name\"] = dmadmin
\nmy_array[\"1\"][\"file_type\"] = -
\nmy_array[\"1\"][\"group_name\"] = dmadmin
\nmy_array[\"1\"][\"permissions\"] = rw-rw----
\nmy_array[\"1\"][\"text\"] = You can find the log of this install session at:n \/home\/dmadmin\/oraInventory\/logs\/installActions2017-11-17_06-11-23PM.lognError in invoking target 'install' of makefile '\/home\/dmadmin\/oracle\/database\/...
\nmy_array[\"1\"][\"file_name\"] = \/home\/dmadmin\/oraInventory\/logs\/oraInstall2017-11-17_06-11-23PM.out
\nmy_array[\"1\"][\"file_size\"] = 1309
\nmy_array[\"1\"][\"file_date\"] = 2017-11-17 19:25
\nmy_array[\"1\"][\"content_type\"] = ASCII text
\nmy_array[\"2\"][\"owner_name\"] = dmadmin
\nmy_array[\"2\"][\"file_type\"] = -
\nmy_array[\"2\"][\"group_name\"] = dmadmin
\nmy_array[\"2\"][\"permissions\"] = rw-rw----
\nmy_array[\"2\"][\"text\"] = INFO: Using paramFile: \/home\/dmadmin\/Downloads\/database\/install\/oraparam.ininINFO: nINFO: nINFO: Checking Temp space: must be greater than 500 MB.   Actual 75674 MB    PassednINFO: Checking swap space...
\nmy_array[\"2\"][\"file_name\"] = \/home\/dmadmin\/oraInventory\/logs\/installActions2017-11-17_06-11-23PM.log
\nmy_array[\"2\"][\"file_size\"] = 2973490
\nmy_array[\"2\"][\"file_date\"] = 2017-11-17 19:29
\nmy_array[\"2\"][\"content_type\"] = ASCII text, with very long lines
\nmy_array[\"3\"][\"owner_name\"] = dmadmin
\nmy_array[\"3\"][\"file_type\"] = -
\nmy_array[\"3\"][\"group_name\"] = dmadmin
\nmy_array[\"3\"][\"permissions\"] = rw-rw----
\nmy_array[\"3\"][\"text\"] = nnnn<QUER...
\nmy_array["3"]["file_name"] = \/home\/dmadmin\/oraInventory\/ContentsXML\/libs.xml
\nmy_array["3"]["file_size"] = 292
\nmy_array["3"]["file_date"] = 2017-11-17 19:26
\nmy_array["3"]["content_type"] = XML 1.0 document, ASCII text
\nmy_array["4"]["owner_name"] = dmadmin
\nmy_array["4"]["file_type"] = -
\nmy_array["4"]["group_name"] = dmadmin
\nmy_array["4"]["permissions"] = rw-rw----
\nmy_array["4"]["text"] = nnnn<VER...
\nmy_array["4"]["file_name"] = \/home\/dmadmin\/oraInventory\/ContentsXML\/inventory.xml
\nmy_array["4"]["file_size"] = 468
\nmy_array["4"]["file_date"] = 2017-11-17 19:25
\nmy_array["4"]["content_type"] = XML 1.0 document, ASCII text
\nmy_array["5"]["owner_name"] = dmadmin
\nmy_array["5"]["file_type"] = -
\nmy_array["5"]["group_name"] = dmadmin
\nmy_array["5"]["permissions"] = rw-rw----
\nmy_array["5"]["text"] = nnnn<TL_L...
\nmy_array["5"]["file_name"] = \/home\/dmadmin\/oraInventory\/ContentsXML\/comps.xml
\nmy_array["5"]["file_size"] = 329
\nmy_array["5"]["file_date"] = 2017-11-17 19:26
\nmy_array["5"]["content_type"] = XML 1.0 document, ASCII text
\nmy_array["6"]["owner_name"] = dmadmin
\nmy_array["6"]["file_type"] = -
\nmy_array["6"]["group_name"] = dmadmin
\nmy_array["6"]["permissions"] = rw-rw----
\nmy_array["6"]["text"] = inventory_loc=\/home\/dmadmin\/oraInventoryninst_group=dmadminn
\nmy_array["6"]["file_name"] = \/home\/dmadmin\/oraInventory\/oraInst.loc
\nmy_array["6"]["file_size"] = 60
\nmy_array["6"]["file_date"] = 2017-11-17 19:26
\nmy_array["6"]["content_type"] = ASCII text
\nmy_array["7"]["owner_name"] = dmadmin
\nmy_array["7"]["file_type"] = -
\nmy_array["7"]["group_name"] = dmadmin
\nmy_array["7"]["permissions"] = rwxrwx---
\nmy_array["7"]["text"] = #!\/bin\/shnAWK=\/bin\/awknCHMOD=\/bin\/chmodnCHGRP=\/bin\/chgrpnCP=\/bin\/cpnECHO=\/bin\/echonMKDIR=\/bin\/mkdirnRUID=`\/usr\/bin\/id|$AWK -F( '{print $1}'|$AWK -F= '{print $2}'`nif [ ${RUID} != "0" ];thenn   $ECHO...
\nmy_array["7"]["file_name"] = \/home\/dmadmin\/oraInventory\/orainstRoot.sh
\nmy_array["7"]["file_size"] = 1661
\nmy_array["7"]["file_date"] = 2017-11-17 19:26
\nmy_array["7"]["content_type"] = POSIX shell script, ASCII text executable
\nmy_array["8"]["owner_name"] = dmadmin
\nmy_array["8"]["file_type"] = -
\nmy_array["8"]["group_name"] = dmadmin
\nmy_array["8"]["permissions"] = rw-rw----
\nmy_array["8"]["text"] = nnnn...
\nmy_array[\"8\"][\"file_name\"] = \/home\/dmadmin\/oraInventory\/oui\/srcs.lst
\nmy_array[\"8\"][\"file_size\"] = 362
\nmy_array[\"8\"][\"file_date\"] = 2017-11-17 18:16
\nmy_array[\"8\"][\"content_type\"] = XML 1.0 document, ASCII text
\nmy_array[\"9\"][\"owner_name\"] = dmadmin
\nmy_array[\"9\"][\"file_type\"] = -
\nmy_array[\"9\"][\"group_name\"] = dmadmin
\nmy_array[\"9\"][\"permissions\"] = rw-------
\nmy_array[\"9\"][\"text\"] = .helpn.helpn.exitn.help createn.tablesncreate table test(a1 number)ngon.tablesnselect * from testn\/nselect * from testngon.save test.dbn.exitn.open stress-test.dbn.hn.healpn.helpn.scheman.schema %n.sc...
\nmy_array[\"9\"][\"file_name\"] = \/home\/dmadmin\/.sqlite_history
\nmy_array[\"9\"][\"file_size\"] = 4747
\nmy_array[\"9\"][\"file_date\"] = 2018-09-01 13:59
\nmy_array[\"9\"][\"content_type\"] = assembler source, ASCII text
\nmy_array[\"10\"][\"owner_name\"] = dmadmin
\nmy_array[\"10\"][\"file_type\"] = -
\nmy_array[\"10\"][\"group_name\"] = dmadmin
\nmy_array[\"10\"][\"permissions\"] = rw-rw-r--
\nmy_array[\"10\"][\"text\"] = echo 10000 | gawk -M '{facto = factorial($0); printf(\"%dn%d digitsn\", facto, length(facto))} function factorial(n) {r = 1; for (i = 1; i <= n; i++) r *= i; return r}' | lessn
\nmy_array["10"]["file_name"] = \/home\/dmadmin\/mp-fact.awk
\nmy_array["10"]["file_size"] = 176
\nmy_array["10"]["file_date"] = 2018-08-08 22:49
\nmy_array["10"]["content_type"] = ASCII text
\nmy_array["11"]["owner_name"] = dmadmin
\nmy_array["11"]["file_type"] = -
\nmy_array["11"]["group_name"] = dmadmin
\nmy_array["11"]["permissions"] = rwxrwxr-x
\nmy_array["11"]["text"] = 504B03040A0000000000A9596449000000000000000000000000040000006466632F504B03040A000000000071863D490000000000000000000000000D0000006466632F6C6963656E7365732F504B03040A000000000071863D49000000000000000000...
\nmy_array["11"]["file_name"] = \/home\/dmadmin\/setup_files\/dfcUnix.zip
\nmy_array["11"]["file_size"] = 24951775
\nmy_array["11"]["file_date"] = 2016-11-04 12:13
\nmy_array["11"]["content_type"] = Zip archive data, at least v1.0 to extract
\nmy_array["12"]["owner_name"] = dmadmin
\nmy_array["12"]["file_type"] = -
\nmy_array["12"]["group_name"] = dmadmin
\nmy_array["12"]["permissions"] = rwxrwxr-x
\nmy_array["12"]["text"] = 504B03040A0000000000785BD842000000000000000000000000090004004D4554412D494E462FFECA0000504B03040A0000000800775BD8428241A6B65C00000066000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D...
\nmy_array["12"]["file_name"] = \/home\/dmadmin\/setup_files\/serviceWrapperManager.jar
\nmy_array["12"]["file_size"] = 2179169
\nmy_array["12"]["file_date"] = 2016-11-04 12:24
\nmy_array["12"]["content_type"] = Java archive data (JAR)
\nmy_array["13"]["owner_name"] = dmadmin
\nmy_array["13"]["file_type"] = -
\nmy_array["13"]["group_name"] = dmadmin
\nmy_array["13"]["permissions"] = rwxrwxr-x
\nmy_array["13"]["text"] = 504B030414000800080036337732000000000000000000000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5...
\nmy_array["13"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/dfcSetup.jar
\nmy_array["13"]["file_size"] = 53170976
\nmy_array["13"]["file_date"] = 2005-03-23 15:29
\nmy_array["13"]["content_type"] = Zip archive data, at least v2.0 to extract
\nmy_array["14"]["owner_name"] = dmadmin
\nmy_array["14"]["file_type"] = -
\nmy_array["14"]["group_name"] = dmadmin
\nmy_array["14"]["permissions"] = rwxrwxr-x
\nmy_array["14"]["text"] = '####################################################################rn'rn' Name:rn'rn'   consistency_checker.ebsrn'rn' Description:rn'rn'   Docbase Consistency Checker Job and Utilitiesrn'rn'   NOTE:...
\nmy_array["14"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/consistency_checker.ebs
\nmy_array["14"]["file_size"] = 129883
\nmy_array["14"]["file_date"] = 2005-03-20 08:29
\nmy_array["14"]["content_type"] = ASCII text, with CRLF line terminators
\nmy_array["15"]["owner_name"] = dmadmin
\nmy_array["15"]["file_type"] = -
\nmy_array["15"]["group_name"] = dmadmin
\nmy_array["15"]["permissions"] = rw-rw-r--
\nmy_array["15"]["text"] = export DOCUMENTUM=\/home\/dmadmin\/documentum53nexport DM_HOME=$DOCUMENTUM\/product\/5.3nexport DOCUMENTUM_SHARED=$DOCUMENTUM\/sharednexport dfcpath=$DOCUMENTUM_SHARED\/dfcnn#export JAVA_HOME=$DOCUMENTUM_SHA...
\nmy_array["15"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/init53
\nmy_array["15"]["file_size"] = 803
\nmy_array["15"]["file_date"] = 2017-11-28 09:44
\nmy_array["15"]["content_type"] = ASCII text
\nmy_array["16"]["owner_name"] = dmadmin
\nmy_array["16"]["file_type"] = -
\nmy_array["16"]["group_name"] = dmadmin
\nmy_array["16"]["permissions"] = rwxrwxr-x
\nmy_array["16"]["text"] = 504B0304140008000800BB597732000000000000000000000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5...
\nmy_array["16"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/server.jar
\nmy_array["16"]["file_size"] = 174586519
\nmy_array["16"]["file_date"] = 2005-03-23 20:16
\nmy_array["16"]["content_type"] = Zip archive data, at least v2.0 to extract
\nmy_array["17"]["owner_name"] = dmadmin
\nmy_array["17"]["file_type"] = -
\nmy_array["17"]["group_name"] = dmadmin
\nmy_array["17"]["permissions"] = rwxrwxr-x
\nmy_array["17"]["text"] = 504B030414000800080031838231000000000000000000000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5...
\nmy_array["17"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/tomcat4127Setup.jar
\nmy_array["17"]["file_size"] = 9843412
\nmy_array["17"]["file_date"] = 2004-12-03 01:25
\nmy_array["17"]["content_type"] = Zip archive data, at least v2.0 to extract
\nmy_array["18"]["owner_name"] = dmadmin
\nmy_array["18"]["file_type"] = -
\nmy_array["18"]["group_name"] = dmadmin
\nmy_array["18"]["permissions"] = rwxrwxr-x
\nmy_array["18"]["text"] = 504B0304140008000800E3317732000000000000000000000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5...
\nmy_array["18"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/bofcollaborationSetup.jar
\nmy_array["18"]["file_size"] = 5587942
\nmy_array["18"]["file_date"] = 2005-03-23 15:27
\nmy_array["18"]["content_type"] = Zip archive data, at least v2.0 to extract
\nmy_array["19"]["owner_name"] = dmadmin
\nmy_array["19"]["file_type"] = -
\nmy_array["19"]["group_name"] = dmadmin
\nmy_array["19"]["permissions"] = rwxrwxr-x
\nmy_array["19"]["text"] = 504B0304140008000800F5317732000000000000000000000000140000004D4554412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5...
\nmy_array["19"]["file_name"] = \/home\/dmadmin\/setup_files\/53\/bofworkflowSetup.jar
\nmy_array["19"]["file_size"] = 5900841
\nmy_array["19"]["file_date"] = 2005-03-23 15:27
\nmy_array["19"]["content_type"] = Zip archive data, at least v2.0 to extract<\/p>\n
file_type  permissions  owner_name  group_name  file_size  file_date         file_name                       content_type  text
\n---------  -----------  ----------  ----------  ---------  ----------------  ------------------------------  ------------  --------------------------------------------------
\n-          rw-rw----    dmadmin     dmadmin     2009       2017-11-17 18:16  \/home\/dmadmin\/oraInventory\/log  ASCII text    java.lang.NullPointerExceptionntat oracle.sysman
\n                                                                             s\/oraInstall2017-11-17_06-11-2                .oii.oiin.OiinNetOps.addNICInfo(OiinNetOps.java:14
\n                                                                             3PM.err                                       4)ntat oracle.sysman.oii.oiin.OiinNetOps.compute
\n                                                                                                                           NICList(OiinNetOps.java:109)ntat oracle.sysman.o
\n                                                                                                                           ii.oii...
\n-          rw-rw----    dmadmin     dmadmin     1309       2017-11-17 19:25  \/home\/dmadmin\/oraInventory\/log  ASCII text    You can find the log of this install session at:n
\n                                                                             s\/oraInstall2017-11-17_06-11-2                 \/home\/dmadmin\/oraInventory\/logs\/installActions201
\n                                                                             3PM.out                                       7-11-17_06-11-23PM.lognError in invoking target '
\n                                                                                                                           install' of makefile '\/home\/dmadmin\/oracle\/databas
\n                                                                                                                           e\/...
\n-          rw-rw----    dmadmin     dmadmin     2973490    2017-11-17 19:29  \/home\/dmadmin\/oraInventory\/log  ASCII text,   INFO: Using paramFile: \/home\/dmadmin\/Downloads\/dat
\n                                                                             s\/installActions2017-11-17_06-  with very lo  abase\/install\/oraparam.ininINFO: nINFO: nINFO:
\n                                                                             11-23PM.log                     ng lines      Checking Temp space: must be greater than 500 MB.
\n                                                                                                                             Actual 75674 MB    PassednINFO: Checking swap s
\n                                                                                                                           pace...
\n-          rw-rw----    dmadmin     dmadmin     292        2017-11-17 19:26  \/home\/dmadmin\/oraInventory\/Con  XML 1.0 docu  nnnn
\n                                                                                                                           <QUER...
\n-          rw-rw----    dmadmin     dmadmin     468        2017-11-17 19:25  \/home\/dmadmin\/oraInventory\/Con  XML 1.0 docu  nnn
\n                                                                                                                           n<VER...
\n-          rw-rw----    dmadmin     dmadmin     329        2017-11-17 19:26  \/home\/dmadmin\/oraInventory\/Con  XML 1.0 docu  nnnn
\n                                                                                                                           <TL_L...
\n-          rw-rw----    dmadmin     dmadmin     60         2017-11-17 19:26  \/home\/dmadmin\/oraInventory\/ora  ASCII text    inventory_loc=\/home\/dmadmin\/oraInventoryninst_gro
\n                                                                             Inst.loc                                      up=dmadminn
\n-          rwxrwx---    dmadmin     dmadmin     1661       2017-11-17 19:26  \/home\/dmadmin\/oraInventory\/ora  POSIX shell   #!\/bin\/shnAWK=\/bin\/awknCHMOD=\/bin\/chmodnCHGRP=\/
\n                                                                             instRoot.sh                     script, ASCI  bin\/chgrpnCP=\/bin\/cpnECHO=\/bin\/echonMKDIR=\/bin\/
\n                                                                                                             I text execu  mkdirnRUID=`\/usr\/bin\/id|$AWK -F( '{print $1}'|$A
\n                                                                                                             table         WK -F= '{print $2}'`nif [ ${RUID} != "0" ];then
\n                                                                                                                           n   $ECHO...
\n-          rw-rw----    dmadmin     dmadmin     362        2017-11-17 18:16  \/home\/dmadmin\/oraInventory\/oui  XML 1.0 docu  nnnn...
\n-          rw-------    dmadmin     dmadmin     4747       2018-09-01 13:59  \/home\/dmadmin\/.sqlite_history   assembler so  .helpn.helpn.exitn.help createn.tablesncreate
\n                                                                                                             urce, ASCII    table test(a1 number)ngon.tablesnselect * from
\n                                                                                                             text           testn\/nselect * from testngon.save test.dbn.
\n                                                                                                                           exitn.open stress-test.dbn.hn.healpn.helpn.sc
\n                                                                                                                           heman.schema %n.sc...
\n-          rw-rw-r--    dmadmin     dmadmin     176        2018-08-08 22:49  \/home\/dmadmin\/mp-fact.awk       ASCII text    echo 10000 | gawk -M '{facto = factorial($0); prin
\n                                                                                                                           tf(\"%dn%d digitsn\", facto, length(facto))} funct
\n                                                                                                                           ion factorial(n) {r = 1; for (i = 1; i <= n; i++)
\n                                                                                                                           r *= i; return r}' | lessn
\n-          rwxrwxr-x    dmadmin     dmadmin     24951775   2016-11-04 12:13  \/home\/dmadmin\/setup_files\/dfcU  Zip archive   504B03040A0000000000A95964490000000000000000000000
\n                                                                             nix.zip                         data, at lea  00040000006466632F504B03040A000000000071863D490000
\n                                                                                                             st v1.0 to e  000000000000000000000D0000006466632F6C6963656E7365
\n                                                                                                             xtract        732F504B03040A000000000071863D49000000000000000000
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     2179169    2016-11-04 12:24  \/home\/dmadmin\/setup_files\/serv  Java archive  504B03040A0000000000785BD8420000000000000000000000
\n                                                                             iceWrapperManager.jar            data (JAR)   00090004004D4554412D494E462FFECA0000504B03040A0000
\n                                                                                                                           000800775BD8428241A6B65C00000066000000140000004D45
\n                                                                                                                           54412D494E462F4D414E49464553542E4D46F34DCCCB4C4B2D
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     53170976   2005-03-23 15:29  \/home\/dmadmin\/setup_files\/53\/d  Zip archive   504B0304140008000800363377320000000000000000000000
\n                                                                             fcSetup.jar                     data, at lea  00140000004D4554412D494E462F4D414E49464553542E4D46
\n                                                                                                             st v2.0 to e  F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E
\n                                                                                                             xtract        4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     129883     2005-03-20 08:29  \/home\/dmadmin\/setup_files\/53\/c  ASCII text,   '#################################################
\n                                                                             onsistency_checker.ebs          with CRLF li  ###################rn'rn' Name:rn'rn'   co
\n                                                                                                             ne terminato  nsistency_checker.ebsrn'rn' Description:rn'
\n                                                                                                             rs            rn'   Docbase Consistency Checker Job and Utiliti
\n                                                                                                                           esrn'rn'   NOTE:...
\n-          rw-rw-r--    dmadmin     dmadmin     803        2017-11-28 09:44  \/home\/dmadmin\/setup_files\/53\/i  ASCII text    export DOCUMENTUM=\/home\/dmadmin\/documentum53nexpo
\n                                                                             nit53                                         rt DM_HOME=$DOCUMENTUM\/product\/5.3nexport DOCUMEN
\n                                                                                                                           TUM_SHARED=$DOCUMENTUM\/sharednexport dfcpath=$DOC
\n                                                                                                                           UMENTUM_SHARED\/dfcnn#export JAVA_HOME=$DOCUMENTU
\n                                                                                                                           M_SHA...
\n-          rwxrwxr-x    dmadmin     dmadmin     174586519  2005-03-23 20:16  \/home\/dmadmin\/setup_files\/53\/s  Zip archive   504B0304140008000800BB5977320000000000000000000000
\n                                                                             erver.jar                       data, at lea  00140000004D4554412D494E462F4D414E49464553542E4D46
\n                                                                                                             st v2.0 to e  F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E
\n                                                                                                             xtract        4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     9843412    2004-12-03 01:25  \/home\/dmadmin\/setup_files\/53\/t  Zip archive   504B0304140008000800318382310000000000000000000000
\n                                                                             omcat4127Setup.jar              data, at lea  00140000004D4554412D494E462F4D414E49464553542E4D46
\n                                                                                                             st v2.0 to e  F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E
\n                                                                                                             xtract        4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     5587942    2005-03-23 15:27  \/home\/dmadmin\/setup_files\/53\/b  Zip archive   504B0304140008000800E33177320000000000000000000000
\n                                                                             ofcollaborationSetup.jar        data, at lea  00140000004D4554412D494E462F4D414E49464553542E4D46
\n                                                                                                             st v2.0 to e  F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E
\n                                                                                                             xtract        4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5
\n                                                                                                                           ...
\n-          rwxrwxr-x    dmadmin     dmadmin     5900841    2005-03-23 15:27  \/home\/dmadmin\/setup_files\/53\/b  Zip archive   504B0304140008000800F53177320000000000000000000000
\n                                                                             ofworkflowSetup.jar             data, at lea  00140000004D4554412D494E462F4D414E49464553542E4D46
\n                                                                                                             st v2.0 to e  F34DCCCB4C4B2D2ED10D4B2D2ACECCCFB35230D433E0E5722E
\n                                                                                                             xtract        4A4D2C494DD175AAB452F0CC2B2E49CCC909CEC84CCD49E1E5
\n                                                                                                                           ...
\n20 rows selected
\nreturn code =  0 after select<\/p>\n
return code= 0 after closing database\n<\/p>\n
<\/code>
\nIt can be used as follows:
\n
\nAWKLIBPATH=gawk-4.2.1\/extension\/.libs find root_dir<\/em> -maxdepth max_depth<\/em> -type f -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk -v limit=how_many_files<\/em> -f stress_sqlite.awk
\n<\/code>
\nExample:
\n
\nmax_depth=5; limit=50; AWKLIBPATH=gawk-4.2.1\/extension\/.libs find ~\/ -maxdepth $max_depth -type f -printf \"%M %u %g %s %TY-%Tm-%Td %TH:%TM %pn\" | gawk -v limit=$limit -f stress_sqlite.awk
\n<\/code>
\nNoticed the ugly nested replace() function calls in the SELECT statement ?:
\n
\n\"SELECT file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, CASE WHEN instr(content_type, 'ASCII text') > 0 THEN \"
\n                             \"CASE WHEN length(content) > 200 THEN replace(replace(replace(substr(content, 1, 200) || '...', 'n', '\\n'), 't', '\\t'), 'r', '\\r') ELSE replace(replace(replace(content, 'n', '\\n'), 't', '\\t'), 'r', '\\r') END ELSE substr(hex(content), 1, 200) || '...' END as text FROM stress\"
\n<\/code>
\nThis is because there no SQLite equivalent to the Unix command “tr set1 set2” or to Oracle’s translate() function, but such a function could easily be user-defined. This is left as an exercise for the reader.
\nThe column widths passed to the last sqlite_select() call came from prior a “draft” execution with following call:
\n
\n   rc = sqlite_select(my_db, \"SELECT file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, CASE content_type WHEN 'ASCII text' THEN \"
\n                             \"CASE WHEN length(content) > 200 THEN replace(replace(substr(content, 1, 200) || '...', 'n', '\\n'), 't', '\\t') ELSE replace(replace(content, 'n', '\\n'), 't', '\\t') END ELSE '' END as text FROM stress\")
\n<\/code>
\nAnd its the result was:
\n
\n...
\nOptimum column widths
\n=====================
\nfor query: SELECT file_type, permissions, owner_name, group_name, file_size, file_date, file_name, content_type, CASE content_type WHEN 'ASCII text' THEN CASE WHEN length(content) > 200 THEN replace(replace(substr(content, 1, 200) || '...', '
\n', 'n'), '\t', 't') ELSE replace(replace(content, '
\n', 'n'), '\t', 't') END ELSE '' END as text FROM stress
\nfile_type          9
\npermissions        11
\nowner_name         10
\ngroup_name         10
\nfile_size          9
\nfile_date          16
\nfile_name          71
\ncontent_type       42
\ntext               209
\n<\/code>
\nSo those values were injected back after some adjustments.
\nBeware that files can add up pretty quickly, hence the file limit parameter. Ditto for the database file. Here, the 50 files in ~\/dmadmin sum up to almost 2 Gb already so make sure there is enough free space for the database file.
\nIf the way sqlite_select() works does not appeal to you, despite all the different display formats it offers, you can give a try to sqlitebrowser available here<\/a>.<\/p>\n
Bulk updates from an array<\/h3>\n
With the sqlite_exec() primitive available, it is possibe to build up a bulk insert, update or delete function that takes its database parameters from a gawk array. Let’s name it bulk_exec(). Here is a possible implementation:<\/p>\n
\nfunction bulk_exec(db, op, table_name, larray     , rowid, stmt, columns, values, col) {\n   for (rowid in larray) {\n      if (\"delete\" == op) {\n         stmt = sprintf(\"DELETE FROM test1 WHERE ROWID = %s\", rowid)\n      }\n      else if (\"update\" == op) {\n         columns = \"\"\n         values = \"\"\n         for (col in larray[rowid]) {\n            columns = columns (\"\" == columns ? \"\" : \", \") col\n            values = values (\"\" == values ? \"\" : \", \") \"'\" larray[rowid][col] \"'\"\n         }\n         stmt = sprintf(\"UPDATE test1 SET (%s) = (%s) WHERE ROWID = %s\", columns, values, rowid)\n      }\n      else if (\"insert\" == op) {\n         columns = \"\"\n         values = \"\"\n         for (col in larray[rowid]) {\n            columns = columns (\"\" == columns ? \"\" : \", \") col\n            values = values (\"\" == values ? \"\" : \", \") \"'\" larray[rowid][col] \"'\"\n         }\n         stmt = sprintf(\"INSERT INTO test1 (%s) VALUES (%s)\", columns, values)\n      }\n      rc = sqlite_exec(my_db, stmt)\n      print \"return code = \", rc\n   }\n}\n<\/pre>\n
The op test is made here for each row, which is inefficient, but this is just an example.
\ndb is the database handle;
\nop is the operation to perform, e.g. one of “insert”, “update” or “delete”;
\ntable_name is the table to modify;
\nlarray is the array that contains the tabular data to apply to table_name.
\nThe structure of the array larray is important. For one thing, it is indexed by rowids so as to univoquely identify the rows to delete or update (obviously not used when inserting rows); this is a difference from the sequence number usually used as an index. The second dimension of the array must contain the column values for updating existing rows or inserting new rows (obviously not used when deleting rows). If the gawk array comes from a preceding call to sqlite_select(), it may be necessary to include the rowid column in the SELECT statement’s list of columns (see line 2 below) and remap the array to be indexed by that rowid (see lines 9 to 16 below). Here is a code snipped showing this for the 3 bulk operations:<\/p>\n
\n...\n   stmt = \"SELECT rowid, n1, s1, s2 FROM test1\";\n   rc = sqlite_select(my_db, stmt, 0, a_test)\n   delete del_test\n   delete mod_test\n   delete ins_test\n   for (i in a_test)\n      if (0 == i % 4)\n         del_test[a_test[i][\"rowid\"]] = 0\n      else if (1 == i % 4) {\n         mod_test[a_test[i][\"rowid\"]][\"n1\"] = a_test[i][\"n1\"] * 100\n         mod_test[a_test[i][\"rowid\"]][\"s1\"] = a_test[i][\"s1\"] \" - s1 modified\"\n         mod_test[a_test[i][\"rowid\"]][\"s2\"] = a_test[i][\"s2\"] \" - s2 modified\"\n      }\n      else if (2 == i % 4) {\n         ins_test[a_test[i][\"rowid\"]][\"n1\"] = int(1000 * rand()) + 1000\n         ins_test[a_test[i][\"rowid\"]][\"s1\"] = a_test[i][\"s1\"] \" - s1 inserted\"\n         ins_test[a_test[i][\"rowid\"]][\"s2\"] = a_test[i][\"s2\"] \" - s2 inserted\"\n      }\n   dumparray(\"a_test\", a_test)\n   dumparray(\"del_test\", del_test)\n   dumparray(\"mod_test\", mod_test)\n   dumparray(\"ins_test\", ins_test)\n   bulk_exec(my_db, \"update\", \"test1\", mod_test)\n   bulk_exec(my_db, \"delete\", \"test1\", del_test)\n   bulk_exec(my_db, \"insert\", \"test1\", ins_test)\n   dumparray(\"a_test\", a_test)\n...\n<\/pre>\n
An alternate implementation could still use the sequential integer index as returned by sqlite_select() and, if needed, extract the rowid column from the array. Here is an illustration for the bulk delete:<\/p>\n
\nfunction bulk_exec(db, op, table_name, larray     , rowid, stmt, columns, values, col) {\n   for (i in larray) {\n      if (\"delete\" == op) {\n         stmt = sprintf(\"DELETE FROM test1 WHERE ROWID = %s\", larray[i][\"rowid\"])\n      }\n...\n<\/pre>\n
bulk_exec() could have been implemented in the extension C code but the benefits would have been limited.<\/p>\n
Conclusion<\/h3>\n
One important remark is that although SQLite supports UTF-8 and UTF-16, no particular attention has been applied here when performing C string operations; C strings are still char * in the extension but it shouldn’t be too difficult to convert them to wchar_t * for multi-byte characters.
\nThe extension is quite heavy on blobs because I find them fascinating. However, they may be OK to store that 4 Mb Despacito MP3 song but not so much for that uncompressed 4 Gb Mamma Mia ! Editor’s Cuts Blu-ray Edition. The fact that it is possible to store anything in a database does not imply that it is a sensible solution to do so. Even Documentum proposes blob stores for faster content retrieval but the content sizes are limited to 64 Kb. The contents are still stored in filesystems because there is no gain to deal with huge (in the Tb or above range) database’s datafiles (although with data files on raw disks it may be a different story for repositories). It might be simpler to have everything in one place, metadata and contents, but performance, administration, and backup would be much more painful. A more reasonable use of blobs is to store small, frequently used files in-line and larger ones on disk with their full path name saved as metadata in the repository. That’s what Documentum, and the iPod, do. It is the best alternative given how slow it is to scan a file tree on disk. Scanning inside the database is way faster that in a filesystem, especially the Documentum filestores due to their particular structure (4-level deep with all the files in the last level). Anyway, the feature is here and can turn useful if used appropriately.
\nThis extension proves again how easy gawk lets itself customize for a broader, almost unexpected usage. So far, we can use it to work with Documentum repositories (dmgawk), work with databases (SQLite and PostgreSQL), process xml (awk\/xml), etc. The fact that all this is free and open-source helps greatly; no wonder this development model has gained such a tremendous momentum.<\/p>\n","protected":false},"excerpt":{"rendered":"
Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is here. In this final part, I’ll explain succinctly the code that was listed in part II. This part is best read while having Part II opened in another browser window. sqlite_gawk.c Line 48: […]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[525],"tags":[],"type_dbi":[],"class_list":["post-11630","post","type-post","status-publish","format-standard","hentry","category-enterprise-content-management"],"acf":[],"yoast_head":"\nA SQLite extension for gawk (part III) - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A SQLite extension for gawk (part III)\" \/>\n<meta property=\"og:description\" content=\"Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is here. In this final part, I’ll explain succinctly the code that was listed in part II. This part is best read while having Part II opened in another browser window. sqlite_gawk.c Line 48: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-07T08:38:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:26:21+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"42 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"A SQLite extension for gawk (part III)\",\"datePublished\":\"2018-09-07T08:38:44+00:00\",\"dateModified\":\"2025-10-24T07:26:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\"},\"wordCount\":3284,\"commentCount\":0,\"articleSection\":[\"Enterprise content management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\",\"name\":\"A SQLite extension for gawk (part III) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-09-07T08:38:44+00:00\",\"dateModified\":\"2025-10-24T07:26:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A SQLite extension for gawk (part III)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A SQLite extension for gawk (part III) - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/","og_locale":"en_US","og_type":"article","og_title":"A SQLite extension for gawk (part III)","og_description":"Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is here. In this final part, I’ll explain succinctly the code that was listed in part II. This part is best read while having Part II opened in another browser window. sqlite_gawk.c Line 48: […]","og_url":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/","og_site_name":"dbi Blog","article_published_time":"2018-09-07T08:38:44+00:00","article_modified_time":"2025-10-24T07:26:21+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"42 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"A SQLite extension for gawk (part III)","datePublished":"2018-09-07T08:38:44+00:00","dateModified":"2025-10-24T07:26:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/"},"wordCount":3284,"commentCount":0,"articleSection":["Enterprise content management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/","url":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/","name":"A SQLite extension for gawk (part III) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-09-07T08:38:44+00:00","dateModified":"2025-10-24T07:26:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/a-sqlite-extension-for-gawk-part-iii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A SQLite extension for gawk (part III)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11630"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11630\/revisions"}],"predecessor-version":[{"id":41173,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11630\/revisions\/41173"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11630"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}