jeff-davis

14 ms·

91.
by jeff-davis 5y ago
How does something like Ada help you measure and control stack usage?
92.
by jeff-davis 5y ago
Right, hints can only tell the database to use features it already has, they don't add new features on the fly. I think the hints discussion is interesting, but not relevant to this particular article.
93.
by jeff-davis 5y ago
Does SQL qualify as Low-Code? A lot of technical non-programmers are very successful using SQL.
94.
by jeff-davis 5y ago
That's a good observation. The only meaningful distinction between a natural key and a surrogate key is whether the number ever escapes the original system. For instance, a driver's license number is printed on the card itself, so
95.
by jeff-davis 5y ago
I should have been more clear. Here are the details: If you read the linked doc, you'll see an EXCEPT clause. That can be used for a retry loop inserting into a table with a UNIQUE constraint. No read locks are necessary, because the U
96.
by jeff-davis 5y ago
I'm just answering the poster's question directly; but in the general case, I agree with you. The cognitive overhead of dealing with the various "what ifs" usually aren't worth the couple bytes or cycles that you co
97.
by jeff-davis 5y ago
The post qualified as <= 10,000,000 total records. For that number of records, there's about a chance of about 0.00001 that you get a collision, assuming good randomness.
98.
by jeff-davis 5y ago
You can also do the loop on the server side using PL/pgSQL: https://www.postgresql.org/docs/current/plpgsql-control-stru...
99.
by jeff-davis 5y ago
The diffs are non-trivial (EDIT: only included changes in directories where conflicts are most likely to occur): $ git log --oneline REL_11_2..REL_11_12 -- src/backend src/include ':!src/backend/po' | wc
100.
by jeff-davis 5y ago
Citus Data enables scale out, while also being a pure extension. That means you can upgrade Postgres like normal to the latest point release using whatever normal upgrade process you want (e.g. OS packages). It has worked for a long time wi
101.
by jeff-davis 5y ago
"Conventions are implementation defined and would require patches to the compiler to add new ones." Is the implementation of a Convention isolated enough that it would make sense to be extensible? One thing I had in mind is someth
102.
by jeff-davis 5y ago
There's some nuance here and I don't think this is correct. However, the uncertainty around Ada licensing causes a lot of people to be hesitant to start with Ada.
103.
by jeff-davis 5y ago
I'm half-obsessed with C interoperability in a variety of languages. I know Ada (or GNAT) has a C FFI, and I've done a little investigation/experimentation but not much. Here are a few questions, which probably don't hav
104.
by jeff-davis 5y ago
I interpreted (misinterpreted?) your comment to be suggesting ES for wider use cases.
105.
by jeff-davis 5y ago
I don't know about elasticsearch specifically, but I'm skeptical of special-purpose systems for databases. They are great in some cases and terrible in others, and over time, use cases push database systems into their worst cases.
106.
by jeff-davis 5y ago
I like to say that "Postgres is a great default". It's generally very good, and also very adaptable to special purposes, so it covers a wide range of use cases. But saying "so much better" is too strong.
107.
by jeff-davis 5y ago
"PL/Rust could be fun, too. I like the idea of using macros to generate lots of code, especially type definitions across multiple languages." Can you explain what you mean here?
108.
by jeff-davis 5y ago
Does "/" have a concrete meaning? I vaguely think it means "with" or "and" or "or", but it seems more ambiguous.
109.
by jeff-davis 5y ago
"Whenever you port a big program to another language it is important to be conservative, in my view." Either be very conservative or just tear things up. I think the middle ground is the worst, where you can't decide whether
110.
by jeff-davis 5y ago
There aren't many pairs of mainstream languages that really interoperate well together. C and C++ do, which can blur the lines a bit. Not sure if this is what the author meant. With rust growing in popularity and good interoperability,
111.
by jeff-davis 5y ago
From one of the linked pages: "Lack of garbage collection was a problem but runtimes are more troublesome...Linux signal handling becomes very complicated...Runtimes also often force layout of data structures be tuned to the needs of t
112.
by jeff-davis 5y ago
Is the goal to replace rr or coexist somehow?
113.
by jeff-davis 5y ago
Great! Do you have some links? I found this: https://doc.rust-lang.org/std/alloc/trait.Allocator.html but it doesn't look like it allows inspecting the size. I'd also like to know how it works to "m
114.
by jeff-davis 5y ago
It would be nice if rust could support multiple heaps and tracking their memory usage. If you are working with a lot of data, you need to use some kind of hybrid cache-friendly memory/disk algorithm. For instance, to find the exact num
115.
by jeff-davis 5y ago
Yeah, I mean, I know I'm asking for a lot. No other language comes close to rust as far as C interop, except C++. And rust is actually better at C interop than C++ in some important ways! * Rust doesn't mess with struct definiti
116.
by jeff-davis 5y ago
That's not very practical for what I'm trying to do. A Postgres extension can access a very wide range of internal functions (hundreds), and most of them have the potential to ERROR (longjmp). These functions are of all different
117.
by jeff-davis 5y ago
I have been hoping for a while that rust would make some progress toward better supporting setjmp/longjump from C: https://github.com/rust-lang/rfcs/issues/2625 It's asking a lot, but it's one
118.
by jeff-davis 5y ago
"What if a programming language would provide us with a structure that would act like an array of structs, but internally it would really behave like a struct of arrays?" What about SQL when using a columnar data store?
119.
by jeff-davis 5y ago
Wouldn't the branch predictor be overwhelmed at some point?
120.
by jeff-davis 6y ago
"many times I as a human just knew better than the DB about how many rows would be accessed/why/how/when/etc..." Would you say the primary problem that you have with the planner is a misestimate of the number o

More ›