Re: [pgsql-www] Fwd: Introducing Aquameta 0.1

Done.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi Eric,
>
> I am one of the moderators of pgsql-announce.
>
> I think your messages falls into "Proprietary & External OSS Project News" of:
> https://wiki.postgresql.org/wiki/NewsEventsApproval
>
> and can be approved. Unless there's objection within a few hours, I am
> going to approve your message.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> From: Eric Hanson <eric@aquameta.com>
> Subject: [pgsql-www] Fwd: Introducing Aquameta 0.1
> Date: Mon, 4 Sep 2017 19:26:03 -0700
> Message-ID: <CACA6kxjfkUGqprvf7qCNMRwqbHyGSBk_sNRKiTv-R0X35Pjp8g@mail.gmail.com>
>
>> Hi,
>> Not sure who I should be asking about this but Mark Wong suggested these
>> two mailing lists.  I sent the announce of Aquameta 0.1 out a few days ago
>> to pgsql-announce, but it hasn't posted yet.  I got a notification back
>> that it was stalled pending approval.  A few other announcements have gone
>> out since then though.  Did I do something wrong or is there any policy I
>> should be consulting?  I'm forwarding the email I sent.
>> Thanks,
>> Eric
>> --
>> Eric Hanson
>> CEO, Aquameta Labs
>> 503-929-1073
>> www.aquameta.com
>>
>>
>> ---------- Forwarded message ----------
>> From: Eric Hanson <eric@aquameta.com>
>> Date: Thu, Aug 31, 2017 at 4:17 AM
>> Subject: Introducing Aquameta 0.1
>> To: pgsql-announce@postgresql.org
>>
>>
>> Hi all,
>>
>> I'm happy to announce the release of Aquameta, a peer-to-peer network for
>> exchanging "bundles", a new kind of complex data object that can be almost
>> anything.  They can include code, web apps, data, images and more, and
>> together create a kind of "smart object" that is very versatile and
>> open-ended.
>>
>> Today, users can exchange emails, publish web pages, exchange binaries via
>> p2p apps, and much more.   We'd like to see Aquameta become another kind of
>> network, one where users exchange these bundled complex data objects that
>> hopefully do fun, interesting and useful stuff.  Because bundles are made
>> up of data, we claim that it's a very wide pipe for creativity and
>> interactivity, one that opens up a whole new world of possibilities.
>>
>> Under the hood, Aquameta is a bunch of PostgreSQL schemas that handle
>> things like version control, web hosting, user interface, events, peer to
>> peer communication, etc.  A bundle is made up of rows in these tables and
>> any others that users might wish to create.
>>
>> Aquameta has a web interface that lets users build and exchange these
>> bundles.  They can be sent either server-to-server via http, or
>> browser-to-browser via WebRTC.  The networked-communication aspect of
>> Aquameta is still under development and experimentation.
>>
>> Aquameta can be installed on a desktop, a server, in the cloud or on a
>> small device such as a Raspberry Pi.
>>
>> Under the hood are a lot of PostgreSQL modules which hopefully can be
>> useful to the PostgreSQL community.  They include:
>>
>> 1) meta - a writable system catalog, that makes common DDL operations like
>> schema changes accessible via INSERT, UPDATE and DELETE
>>
>>
>>    - insert into meta.role(name, superuser, password) values ('joe', true,
>>    'mypass');
>>    - insert into meta.schema(name) values ('my_schema');
>>
>> 2) bundle - a version control system for data, similar to git, but for rows
>> in the database instead of files
>>
>>    - select bundle.stage_row_add(
>>        meta.row_id('public','countries','id','UK')
>>    );
>>    - select bundle.commit('org.aquameta.countries','add uk.');
>>    - select bundle.checkout('org.aquameta.games.snake');
>>
>> 3) event - a pub/sub event system for subscribing to data changes on a
>> particular column, row or table
>>
>>    - select session_create();
>>    - select subscribe_table(meta.relation_id('widget','machine'));
>>
>> 4) filesystem - a foreign data wrapper that lets you SELECT files and
>> directories from the filesystem, and a daemon called postgrefs, which lets
>> you navigate the database from the filesystem as if it were files and
>> directories
>>
>>    - aquameta=# select name, path, permissions, content, owner from
>>    filesystem.file where path='/etc/issue';
>>     name  |    path    | permissions |         content          | owner
>>    -------+------------+-------------+--------------------------+-------
>>     issue | /etc/issue | 0644        | Ubuntu 14.04.5 LTS \n \l+| root
>>           |            |             |                         +|
>>           |            |             |                          |
>>    (1 row)
>>    - $ ls /mnt/aquameta/public/countries
>>
>> 5) www - a web server that exposes the database over http, including a REST
>> interface for data manip and function calls, hosting of arbitrary
>> resources, and an authentication layer that uses PostgreSQL ROLEs and
>> PRIVILEGEs
>>
>>    - aquameta=# select path, m.mimetype, substring(content from 1 for 15)
>>    from endpoint.resource r
>>    join endpoint.mimetype m on r.mimetype_id = m.id limit 2;
>>     path  | mimetype  |    substring
>>    -------+-----------+-----------------
>>     /docs | text/html | <!DOCTYPE html>
>>     /dev  | text/html | <!DOCTYPE html>
>>    - select endpoint.request('0.1','GET','/docs')
>>
>> 6) widget - a user interface component framework, where web pages are
>> composed of "widgets", UI components made of html, css and javascript, that
>> accept arguments and support javascript dependencies
>>
>>    - select * from widget.widget;
>>    - select * from widget.widget_dependency_js;
>>
>> 7) semantics - a metadata layer for the database schema, where columns,
>> relations, foreign keys and more can be "decorated" with additional
>> semantic meaning
>>
>>    - insert into semantics.relation (relation_id, purpose_id, widget_id)
>>    values
>>    (
>>       meta.relation_id('ecomm','customer'),
>>       (select purpose_id from semantics.purpose where purpose='row_detail'),
>>       (select id from widget.widget where name='customer_list_view')
>>    );
>>
>>
>> Aquameta is in very early stages, despite being under development for
>> years.  It is finally at the point of being a marginally functional
>> prototype that hopefully is pointed in the right direction, but there is
>> still much to be done.  The user interface is just beginning to take shape,
>> the system is not secure, test coverage is sparse, and there are surely
>> many bugs and missing features.  We are releasing it at this early stage to
>> get feedback and invite contributors to help out.
>>
>> To give Aquameta a spin, head over to github and consult the README which
>> contains install instructions:
>>
>> http://github.com/aquametalabs/aquameta
>>
>> A demo video is available at
>> http://aquameta.org/
>>
>> To jump into development, check out the project's roadmap, and join our IRC
>> channel and mailing list:
>>
>> http://aquameta.org/roadmap
>> #aquameta on irc.freenode.net
>> https://groups.google.com/forum/#!aboutgroup/aquameta-discuss
>>
>> Thanks,
>> Eric
>> --
>> Eric Hanson
>> CEO, Aquameta Labs
>> 503-929-1073 <(503)%20929-1073>
>> www.aquameta.com