Let me start by wishing you and yours a Merry Christmas, Happy Hannukah, Joyous Kwanzaa, Bright Karthigai – whatever you choose to celebrate this holiday season – and a Happy New Year. I hope all is well with you and yours, and that 2021 brings more
sanity than 2020 did.
YottaDB moved to 100% telecommuting in mid-March, and we have been working remotely since then. We anticipate returning to the office after the pandemic; meanwhile, the office is for computers and the occasional cobweb.
Nevertheless, we have been busy this year. Our major milestone was the release of Octo 1.0, for querying YottaDB databases using SQL-92 and JDBC. Our next major target for Octo is read-write capability using SQL. Although the following is very much code
that is under development, this demonstration of INSERT INTO will give you a taste of what we plan to release in 2021:
$ echo "create table usstates(state varchar primary key, capital varchar);" | octo
OCTO> create table usstates(state varchar primary key, capital varchar);
OCTO>
$ echo "create table uspresidents (id integer primary key, firstname varchar, middlename varchar, lastname varchar)" | octo
OCTO> create table uspresidents (id integer primary key, firstname varchar, middlename varchar, lastname varchar)
OCTO>
$ head -3 ~/.yottadb/usstates.sql
INSERT into USSTATES values
("Alabama", "Montgomery"),
("Alaska", "Juneau"),
$ head -3 ~/.yottadb/uspresidents.sql
INSERT into USPRESIDENTS values
(1, "George", "", "Washington"),
(2, "John", "", "Adams"),
$ octo -f ~/.yottadb/usstates.sql
$ octo -f ~/.yottadb/uspresidents.sql
$ echo "select state, capital, id, firstname, middlename, lastname from uspresidents, usstates where lastname = state or lastname = capital;" | octo
OCTO> select state, capital, id, firstname, middlename, lastname from uspresidents, usstates where lastname = state or lastname = capital;
Washington|Olympia|1|George||Washington
Wisconsin|Madison|4|James||Madison
Mississippi|Jackson|7|Andrew||Jackson
Nebraska|Lincoln|16|Abraham||Lincoln
OCTO>
$
Along with a number of other enhancements and fixes, in our mission to make YottaDB a language-agnostic database, we added support for Rust this year, adding to our support for C, Go and M. From our community, we have support for access to the database
from Perl, and wrappers for access from node.js and Python are being worked on by community members. We continue to merge upstream code releases into the YottaDB code base, while ensuring that the merged code meets the standards for robustness,
performance, and security that you have come to expect from us.
Since all our software is developed as a 100% free / open source project, you can follow our work at
https://gitlab.com/YottaDB. You can see what our development plans are, and you can even see our review comments on our developers' code Merge Requests.
Please do feel free to add your comments to any Issue or Merge Request.
YottaDB continues to grow. We have grown organically from the original three founders to a team of ten. In 2020, we had a table at an international event, FOSDEM, in Brussels. We had more visitors there than all our events in the US in 2019 combined, but
after that the pandemic shut down our in-person events. We hope to resume them in due course of time. In 2020, we also refreshed our web site, and we had additional users who permitted us to feature them on our web site.
Many of you know Sam Habiel. He recently joined YottaDB. Although his primary role is as a developer, based on his background and expertise, we intend to make a limited amount of his time available for consulting, should you need it.
We send you our hopes and best wishes for good health, happiness and every success in 2021, and hope that we have an opportunity to meet in person in the not too distant future.
Regards
– Bhaskar
K.S. Bhaskar
President, YottaDB LLC
40 Lloyd Avenue, Suite 104
Malvern, PA 19355, USA
bhaskar@yottadb.com
https://yottadb.com
--
YottaDB - Rock solid. Lightning fast. Secure. Pick any three.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)