I unfortunately missed the Encirq webinar thanks to a project commitment
but have taken the time to download the Encirq demo and try to make good
the loss. It has some user examples in source code which give an idea
of how it functions, but the information on the product is sparse so it
was not possible to get an idea of the mechanics of indices, paging etc.
What I saw was a well conceived product to build embedded software. It
seems to be a compiler which transforms Encirq's version of PL/SQL into
C statements which are then compiled into a library of data manipulation
functions for use in the application. The demo uses gcc. Encirq has a
means of including "storage modules" to handle different forms of
persistent storage. DeviceSQL appears to handle transactions and
rollbacks. There is no information I could find about ACID functionality.
I shall prepare some benchmarks against Sqlite once I figure out a
suitable method. Since DeviceSQl has no SQL compiler the Sqlite will
need to have prepared statements and binding to provide an apples to
apples comparison. The Encirq introductory application example is by
necessity trivial and small and not suited to a benchmark.
DeviceSQL is not suitable for general purpose SQL processing, unlike
Sqlite, and should only be compared as an alternative in deeply embedded
applications so the only useful comparison is one which looks like a
cell phone, microwave oven or a TV set top box.
I can imagine that a version of Sqlite which does not include its SQL
compiler and which uses precompiled VDBE code would provide similar
functionality to DeviceSQL, particularly if the Sqlite compiler were
extended to generate VDBE from PL/SQl. I can imagine that the higher
information density of the VDBE code could deliver the advantage =of a
smaller memory footprint.
For Steve Weick - I note your very strong resume and would imagine that
your comprehensive experience would lead you to introduce a less
secretive policy as to revealing the capabilities of your product.
steveweick wrote:
Good idea... I'll pass it along to the right folks. Meanwhile, if anyone has
further questions or comments, please feel free to write me here (if they
think the group would be interested) or at [EMAIL PROTECTED]
Steve
I would like to recommend that Encriq create a forum or mailing list of
their own for those who are interesting in learning more. For me, what
might be an interesting product is quickly being overshadowed by this
thread.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
