News for hackers. Stuff that matters.
Re:ClickHouse, Inc. by akulkarni on Monday September 20, 2021 @02:29PM (#28597093)
[Timescale co-founder here]

Hi Eric, thanks for taking a close look at our license.

I'd like to dispel some misconceptions:

The core of TimescaleDB is Apache2. Advanced features are under the Timescale License.

Regarding this:

  the customer is prohibited, either contractually or technically, from defining, redefining, or modifying the database schema or other structural aspects of database objects, such as through use of the Timescale Data Definition Interfaces, in a Timescale Database utilized by such Value Added Products or Services.

  My read is that if you let a customer do anything that adds a custom field, or table, or database, or trigger, or anything that is "structural" (even in the regular relational stuff) anywhere in your database (metrics or not), you are in violation. There doesn't seem to be a distinction about whether this is "direct" control or not, or whether a setting indirectly adds a trigger. I don't want to be in a courtroom debating whether a new metric is a "structural change!"
That's not correct, and we took pains to clarify that in the license:

  3.5 "Timescale Data Definition Interfaces" means SQL commands and other interfaces of the Timescale Software that can be used to define or modify the database schema and other structural aspects of database objects in a Timescale Database, including Data Definition Language (DDL) commands such as CREATE, DROP, ALTER, TRUNCATE, COMMENT, and RENAME. [0]

Strictly speaking, if you provide Data Definition Interfaces (DDL) to customers via a SaaS service (ie you are running a TimescaleDBaaS - which applies to < 0.000001% of all possible users) you are in violation of the license. But otherwise you are fine.

If you are looking for more votes of confidence, today there are literally millions of active TimescaleDB instances, including by large companies like Walmart, Comcast, IBM, Cisco, Electronic Arts, Bosch, Samsung, and many many smaller ones. [2]

If you have any other questions, I'm happy to answer them here, or offline (ajay at timescale dot com).

[1] https://www.timescale.com/legal/licenses#section-3-5-timesca...

[2] https://www.timescale.com/

Re:ClickHouse, Inc. by ericb on Monday September 20, 2021 @02:35PM (#28597145)
Are you sure?

The phrasing "such as" in "such as through use of the Timescale Data Definition Interfaces" looks to me like it can be interpreted as saying "Including but not limited to"

Re:ClickHouse, Inc. by akulkarni on Monday September 20, 2021 @02:42PM (#28597239)
Yes :-)

It was a little cumbersome to list every DDL SQL command, which why it uses that language. But that is the intent.

If you have a specific question, happy to answer it here (or offline)

Also, we used this language deliberately to provide more clarity. DDL vs DML is a pretty clear line to most developers who use TimescaleDB (vs some other companies who use language like, "you can't compete with us" etc).

Re:ClickHouse, Inc. by mst on Monday September 20, 2021 @03:07PM (#28597498)
The issue isn't the DDL vs. DML.

The issue is the 'such as', which reads to me as indicating that providing an API endpoint that can add fields would also be a way of letting the customer modify the database schema and therefore covered.

Which means that building a SaaS app backed by timescale that has any level of customisation exposed to the user appears to be prohibited.

This seems a rather stronger level of prohibition than stopping people directly competing with you, and would suggest that if it's intended it would help to make it more explicit, and if it isn't then an explicit statement of that would be worth adding.

Re:ClickHouse, Inc. by akulkarni on Monday September 20, 2021 @03:53PM (#28598110)
Practically speaking, there are already 1000s+ SaaS apps built on TimescaleDB (and using the Timescale License features)

But I appreciate the feedback on how we could make our language clearer. Will share with the team!

Re:ClickHouse, Inc. by marcinzm on Monday September 20, 2021 @09:06PM (#28600973)
The issue is likely something like this:

a) Oracle buys TimescaleDB

b) Oracle sues any of 1000+ SaaS apps that have decent revenue and they can identify

c) The other 900 suddenly have massive due diligence issues even if not sued

Re:ClickHouse, Inc. by Aeolun on Monday September 20, 2021 @08:30PM (#28600735)
I mean, that’s cool, but maybe a bit problematic if the language of the license means they’re all in violation of it.

I understand from your perspective this whole discussion probably looks silly, because you know what’s in your mind.

There are just too many stories of this blowing up in someone’s face (mostly due to legal, not due to actual enforcement) :/

Re:ClickHouse, Inc. by ericb on Monday September 20, 2021 @09:25PM (#28601088)
Right, and we're subject to what's in his mind, which we can't know, and what's in his acquirer's mind, which even he can't know!
Re:ClickHouse, Inc. by ericb on Monday September 20, 2021 @03:04PM (#28597462)
Right, I'm onboard with your stated intent, and the lovely database, and even sympathetic on the cloud provider threat.

My interpretation doesn't hinge on the DDL/DML question. If what you said is your intent, the legal language used is wrong and you should fix it. Consider this a bug report. Here's a source!

https://www.law.cornell.edu/definitions/uscode.php?width=840...

In order for the license to be usable, you need to be limitative here.

Re:ClickHouse, Inc. by akulkarni on Monday September 20, 2021 @03:52PM (#28598097)
Thanks for the feedback, will pass along :-)
Re:ClickHouse, Inc. by shadowwolf007 on Monday September 20, 2021 @04:02PM (#28598233)
So this is a very relevant question and I have been trying to figure out if I need to migrate off timescaledb asap coincidentally over the last 2 weeks (We're pre-production anyway, so it's the time to do so!). Doing so has been super low priority, but since you're here .... :)

If I have a table that records timeseries data and then another table that has a customer-provided extensible set of metadata where a customer can define columns and other related tabular data, would that violate the license? The customer doesn't have a direct, like, psql level of access but the API intentionally provides a very similar level of interaction.

Does this qualify as providing Data Definition Interfaces? If none of those additional columns and such appear on tables set up as timescale tables does that make any difference?

Re:ClickHouse, Inc. by mfreed on Monday September 20, 2021 @05:08PM (#28599016)
One clarification to the above discussion -- about whether these restrictions also get applied to "even the regular relational stuff" -- which I think is relevant to you (and parent):

The Timescale License only covers the TimescaleDB code. Postgres code continues to be covered by the OSS PostgreSQL License [0].

So putting aside the question about API vs. psql level (again, the Timescale License was drafted to enabled this for "Value Added Services", e.g., where "such value-added products or services are not primarily database storage or operations products or services"), this license wouldn't apply for non-Timescale code.

[Timescale co-founder here]

[0] https://github.com/timescale/timescaledb/blob/master/NOTICE

Re:ClickHouse, Inc. by shadowwolf007 on Monday September 20, 2021 @06:49PM (#28600048)
Ok thank you!

I appreciate from your POV this probably is silly but for us it’s very helpful to have explicit clarity since investors are questioning and demand certainty. I once had to rewrite https handshakes because a lawyer thought export compliance laws would be violated, so hopefully you understand my trepidation :-)

Re:ClickHouse, Inc. by Aeolun on Monday September 20, 2021 @08:25PM (#28600701)
Just keep these comments handy in case you ever need them in court :P
Re:ClickHouse, Inc. by ericb on Monday September 20, 2021 @05:33PM (#28599283)
Not the parent, but great to hear that clarification! By the way, doubt I would complain if Prometheus didn't look impressive. :-)

One other bug report on the license language front, this language could be construed to prohibit uses like Prometheus--unless there's a definition of operations products I missed (possible).

> are not primarily database storage or operations products

Suggested edit:

> are not primarily database storage or *database operations products*

Re:ClickHouse, Inc. by mfreed on Monday September 20, 2021 @07:40PM (#28600424)
Oh, English parsing =)

Yes, database is a modifier to both storage and operations: database (storage or operations) products.

It's a good edit; will keep in mind.

(For good reason, we generally just don't like to "update" the text of the license too much, even for minor nits.)

Thanks!

Re:ClickHouse, Inc. by ericb on Monday September 20, 2021 @09:07PM (#28600983)
Oh sorry, said Prometheus above, meant TimeScale is impressive!

Understood. If you see the other thread regarding the "such as" language, there is a serious edit that you can batch-up and repair to reflect your intentions with this one.

The "such as" language, retains your right to sue anyone for license violations if their API allows any customer action that causes structure changes indirectly, via the DDL, even under the hood (materialized views, too, presumably). That's way way more use cases than just repackaging TSDB as a service. That's a landmine, which when people compare and choose databases, they'd just assume avoid, even if otherwise comfortable with a cloud-protective license. Making this clearer and less onerous probably will probably pay for itself with a wider top-of-funnel for the product with more people more confident in the license.

The "We Clarified It In a Thread on Hacker News Public License" is probably not as ideal as updating the places that need clarification. :-P