Hacker News: roller

New comment by roller in "Postgres rewritten in Rust, now passing 100% of the Postgres regression tests"

roller — Fri, 10 Jul 2026 00:33:08 +0000

Microsoft SQL Server has had a similar feature for a while -- Multiple Active Result Sets aka MARS. I don't have a good read on whether it actually helps any workloads. I've seen adapters that don't support it because of the extra complication.

https://learn.microsoft.com/en-us/sql/relational-databases/n...

New comment by roller in "Reactive Relational Algebra"

roller — Fri, 20 Sep 2024 17:06:15 +0000

Peter Alvaro gave a great presentation on Dedalus at Strange Loop 2015.

https://www.youtube.com/watch?v=R2Aa4PivG0g

New comment by roller in "Show HN: PRQL 0.2 – a better SQL"

roller — Mon, 27 Jun 2022 21:28:38 +0000

A combined approach works if want to encode the exclusive constraint:

    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)

New comment by roller in "The “No Code” Delusion"

roller — Mon, 13 Jan 2020 16:40:04 +0000

Here's an example of a config system using prolog: https://github.com/larsyencken/marelle

It's a hard to tell where marelle ends and the config begins, since it's all just prolog.

New comment by roller in "Broot – A new way to see and navigate directory trees"

roller — Thu, 09 Jan 2020 14:13:38 +0000

Rust on windows has targets for msvc or gnu. The MSVC integrates better with Visual Studio and other Microsoft libraries for development. One downside I've found is that it dynamically links against a msvcrt DLL. Which means you may need to download and install a Visual C++ Redistributable package to run.

The gnu target seems to be fully static and run everywhere with no dependencies.

New comment by roller in "The Mercury programming language"

roller — Thu, 08 Nov 2018 14:35:39 +0000

One interesting aspect of mercury is the number of available back-ends (grades) [1]. I'm curious if anyone has any experience using the FFI [2] for embedding mercury into a larger Java, C# or Erlang project.

[1]: https://www.mercurylang.org/about/backends.html

[2]: https://mercurylang.org/information/doc-release/mercury_ref/...

New comment by roller in "AT&T blacks out HBO, Cinemax for Dish, Sling TV users over carriage dispute"

roller — Thu, 01 Nov 2018 21:49:05 +0000

Last time I tried to watch something via the HBO Now website, it said I needed to install Flash. That's the definition of terrible for me.

New comment by roller in "Bloom Programming Language"

roller — Fri, 11 May 2018 19:11:54 +0000

I assume Lineage Driven Fault Injection stuff [1] has some overlap with Eve's ability to tell you "Why is this blank?": The datalog model allows you to find the logical dependencies of results.

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...

New comment by roller in "Making a Statically-Linked, Single-File Web App with React and Rust"

roller — Thu, 05 Apr 2018 17:47:40 +0000

> ... DNS rebinding attack. And if your use case can support it, a random port is nice too.

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.

New comment by roller in "RFC: Ubuntu 18.04 LTS Minimal Images"

roller — Fri, 02 Feb 2018 21:05:02 +0000

The gcc-7-base package (assuming that's what you're looking at) looks like it's just an empty directory to put various gcc things and some basic docs.

https://packages.debian.org/sid/gcc-7-base

https://packages.debian.org/sid/amd64/gcc-7-base/filelist

New comment by roller in "Son: A minimal subset of JSON for machine-to-machine communication"

roller — Sun, 10 Dec 2017 14:33:54 +0000

In the feature category, I'd also mention direct support for unbounded collections. CBOR can be its own container format for streaming data.

New comment by roller in "Windows for Linux Nerds"

roller — Thu, 14 Sep 2017 13:24:12 +0000

Cygwin still seems to be the go-to for any POSIX apps that need to interact with the actual Windows environment. For example, wslbridge[1] that connects wsltty[2] to WSL compiles the frontend component under cygwin.

[1]: https://github.com/mintty/wsltty [2]: https://github.com/rprichard/wslbridge

New comment by roller in "Tad, a tabular data viewer"

roller — Wed, 31 May 2017 18:19:29 +0000

fwiw, a Save As CSV from "Microsoft® Excel for Mac" 15.33 got me this:

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.

New comment by roller in "Implement table partitioning"

roller — Thu, 08 Dec 2016 14:00:37 +0000

The linked patch notes specifically mention the difference between this and table inheritance based partitioning.

  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.

New comment by roller in "Eve: Programming designed for humans"

roller — Sat, 29 Oct 2016 01:34:51 +0000

For an introduction to Dedalus with less reading, Peter Alvaro's 2015 Strange Loop talk was fantastic.

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.

https://www.youtube.com/watch?v=5V1ynVyud4M

New comment by roller in "PurpleJS – A JavaScript application framework running on the JVM"

roller — Mon, 24 Oct 2016 10:59:48 +0000

I normally turn to ringojs[1] for "off-browser javascript" with Java integration. It's been around nearly 20 years[2] now! Is this a new take on the same concept? The examples seem web application focused, but there's not even a mention of JSGI[3] or whether it was even considered.

[1]: http://ringojs.org/

[2]: http://helma.org/

[3]: https://www.sitepen.com/blog/2010/01/19/commonjsjsgi-the-eme...

New comment by roller in "Why Erlang Matters"

roller — Fri, 08 Apr 2016 20:36:20 +0000

I haven't seen it used directly, but it seems like Elixir macro based code could be altered and recompiled based on runtime configuration.

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.

New comment by roller in "MathML is a failed web standard"

roller — Thu, 07 Apr 2016 17:58:56 +0000

While this format is more generic, an abbreviated encoding can sometimes accomplish the same thing. For example, just moving the "type" to be the object key and removing the implied secondary name gets you this far:

    { "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.

New comment by roller in "A Government Error Just Revealed Snowden Was the Target in the Lavabit Case"

roller — Fri, 18 Mar 2016 00:08:21 +0000

EFF's Privacy Badger does the same for me. After looking at the list of 10 different blocked tracking sites, I just gave up. It's too bad, I'd be otherwise be happy to visit their fine website.

New comment by roller in "OpenSSH for Windows update"

roller — Tue, 20 Oct 2015 02:24:45 +0000

This is a key thing I'm curious about. How is drive mapping handled? If I "net use d: \\host\share" from one session, it won't nessarily translate and mount D: to all sessions (or will it)?