news
Databases: ElephpantDB and YottaDB
-
The Deployer Times ☛ ElephpantDB: A Database in One PHP File
Today I’m releasing ElephpantDB, a small SQL database written entirely in PHP and shipped as a single file.
Why? Because sometimes you look at a normal application stack and think: “This has far too few opportunities for surprise.”
-
YottaDB ☛ Access VistA Lab Chemistry Data from Octo - YottaDB
We recently received a feature request for Octo to natively support “Piece of Piece”; e.g., to declare a column in Octo corresponding to a construct like $PIECE($PIECE(^A,"|",3),"^",2). Although Octo could previously represent such a use case with a computed column, a computed column cannot be indexed; so a query will be expensive. Octo now allows such a column to be defined and indexed.
As part of this work, I took the opportunity to implement the extraction of Lab Chemistry Data in VistA. What’s the connection? VistA data is almost always stored as ^ delimited pieces (e.g., A^B^C) or as Extract ranges (ABCXYZ range 1-3 = ABC). Only in the storage of Chemistry Data in the Lab Package do we get a sub-piece: A^B^C1!C2!C3. To make it concrete, here is some made-up Chemistry Data from VistA: [...]
0