https://learn.microsoft.com/en-us/sql/relational-databases/n...
90 karma · joined March 24, 2009
https://learn.microsoft.com/en-us/sql/relational-databases/n...
CREATE TYPE school_type AS ENUM ('college', 'high_school');
CREATE TABLE schools (
id SERIAL PRIMARY KEY,
type school_type,
unique (id, type)
);
CREATE TABLE colleges (
id INTEGER NOT NULL,
type school_type default 'college',
check (type='college'),
foreign key (id, type) references school(id, type)
);
Ya, the syntax is annoying and repetitive. It would be nice if foreign key could be a literal to remove the extra column altogether. e.g.: foreign key (id, 'college') references school(id, type)It's a hard to tell where marelle ends and the config begins, since it's all just prolog.
The gnu target seems to be fully static and run everywhere with no dependencies.
[1]: https://www.mercurylang.org/about/backends.html
[2]: https://mercurylang.org/information/doc-release/mercury_ref/...
Some other bloom related links:
- Anna KVS[2] showed up recently on hacker news[3] and morning paper[4]
- Lasp lang is in the same space[5], Christopher Meiklejohn has a comparison with bloom[6]
[1]: https://disorderlylabs.github.io/#
[2]: https://databeta.wordpress.com/2018/03/09/anna-kvs/
[3]: https://news.ycombinator.com/item?id=16551072
[4]: https://blog.acolyer.org/2018/03/27/anna-a-kvs-for-any-scale...
[5]: https://lasp-lang.readme.io/
[6]: http://christophermeiklejohn.com/lasp/2018/03/02/lasp-vs-blo...
Ah, that's a good explanation as to why zserge/webview recommends serving using ephemeral ports.
Also, wanted to pull in from the readme: webview supports interacting with the javascript environment directly, so a web server isn't strictly required.
[1]: https://github.com/mintty/wsltty [2]: https://github.com/rprichard/wslbridge
test.csv: UTF-8 Unicode (with BOM) text, with CR line terminators
Apparently, even recent software is not up to date on what the line separator should be.
Because table partitioning is less general than table inheritance, it
is hoped that it will be easier to reason about properties of
partitions, and therefore that this will serve as a better foundation
for a variety of possible optimizations, including query planner
optimizations.https://www.youtube.com/watch?v=R2Aa4PivG0g
---
Edit: Actually Chris Granger gave an Eve talk at the same conference. It's interesting to see how Eve has evolved since.
[1]: http://ringojs.org/
[2]: http://helma.org/
[3]: https://www.sitepen.com/blog/2010/01/19/commonjsjsgi-the-eme...
An example would be changing log level settings. Normally Elixir log blocks can be compiled entirely out when running in production mode. But it should be possible to fairly safely recompile with debug logs enabled and reload without missing a beat.
{ "mrow": [
{ "mi": "x" },
{ "mo": "=" },
{ "mfrac": [
{ "mrow": [
{ "mo": "-" },
{ "mi": "b" },
{ "mo": "±" },
{ "sqrt": {
{ "mrow": [
{"mi": "b"},
{"msup": { "mi": 2 }},
{"mo": "-"},
{"mi", "4ac"}
]}
}}
},
{ "mrow": [
{"mi": "2a"}
]}
]}
}
It's not as general, but works if you know your syntax is similarly bounded. I don't know how certain static languages would handle serial/deserializing, but makes construction via javascript literals much more pleasant.[0]: http://nixos.org/nix/ [1]: http://nixos.org/nix/manual/#chap-writing-nix-expressions
It details how to use the PyMC library via iPython notebooks. I'm not sure if iPython qualifies as an easy to use app though.
I guess as is, a make could include a grep -v </?script> step.
I love less's command line interface for some of this stuff.
The command line switch to chop long lines: -S The in-app command to toggle chop lines: -S
The reverse is almost true for things like /search, F (follow) or G (go to end). They can be used from the command line with +/search, +F or +G
http://www.postgresql.org/docs/9.3/interactive/auto-explain....