tpetry

21 ms·

241.
by tpetry 5y ago
Every cloud makes this mistake easy! You have to manually activate billing alerts for everyone because they want you to spend more snd more each month. I am still waiting for a cloud without these dark patterns. But that will never happen b
242.
by tpetry 5y ago
That would be really usefull! And when the parser does not understand a language construct (e.g. a new swl fwature) let it fall back to some dumb parsing for that part. If it does not under „LIMIT 5 WITH TIES“ let it parse „LIMIT 5“ in it‘s
243.
by tpetry 5y ago
Diaspora and Mastodon. These are the prime example what the web 3 generation wants: no central company, everyone runs it‘s own server, user is in control of all it‘s data And they are a total empty space. Because it‘s complex to use ans is
244.
by tpetry 5y ago
What if this new generation is just repeating the mistakes of former generations? They talk about decentralization which has been done so often before and only worked for niche use-cases. What if crypto is just a big money pump and dump sch
245.
by tpetry 5y ago
A nice way i have seen is grandfather your old users to the old price. But only users paying the new price are getting the new and shiny features. The product is not worsened for the old users. If they are really interested in the new featu
246.
by tpetry 5y ago
The book „The Mom Test“ describes the behaviour very good. Most often these people are not totally honest in evaluating your idea because multiple reasons e.g. you asking the wrong way (happened to me too!) or they are not really thinking a
247.
by tpetry 5y ago
I have not read the specification of matter (which is a joint standard). But Apple‘s custom HomeKit protocol was designed to work without any cloud service by design. I use it without any cloud control, i won‘t be able to control my heater
248.
by tpetry 5y ago
AWS is basically never sharing any details, only when it‘s benefical in terms of marketing. The changes they made had not been possible with an extension in the past, and they are most probably still not fully possible without forking. But
249.
by tpetry 5y ago
They changed the storage layer and the query planner in some parts to work correctly with their new storage layer. So it‘s a fork and not behaving exactly identical. I have seen some different execution plans for the same model and data bec
250.
by tpetry 5y ago
It is built-in. The autovacuum process is doing this. When you have a large database you may need to tune some config parameters, as the default conservative setting for low/mid databases are naturally different. Running these manual c
251.
by tpetry 5y ago
Is there any documentation which statements are doing this. Had watched this in the past too, but can‘t remember which one was responsible for it and whether it changed in the last versions.
252.
by tpetry 5y ago
Aurora forked PostgreSQL very early on (before 9.6) and has been improved independent and a lot has been changed. They are effectively different databases now.
253.
by tpetry 5y ago
Raid-1 is doing exactly what you recommend without any effort. A perfect replica of the disk. And if the other one dies, who cares, the beauty of raid-1 is you don‘t need the other one to have a full copy.
254.
by tpetry 5y ago
In PostgreSQL you can GROUP BY on the primary key so you can omit specifying all other columns
255.
by tpetry 5y ago
Can you share some information about SAP HANA? Why is it insane? Insanely good or bad? I have no experience with it.
256.
by tpetry 5y ago
The author is talking about a different classes of rdbms. I believe his intention was not to compare PostgreSQL to ElasticSearch or ClickHouse which will solve a completely different problem. But for small to medium datasets his advice to j
257.
by tpetry 5y ago
They are really easy to mimic in PostgreSQL with range types (tstzrange) and an exclusion constraint, so now overlapping values are allowed. I guess they will not add it to the core if a developer can add support to them so easy.
258.
by tpetry 5y ago
Really? For months the twitter trending tab has only bern corona topics from each side of the spectrum, almost nothing else.
259.
by tpetry 5y ago
You can just start 10 more instances of your monolith. It‘s not a problem.
260.
by tpetry 5y ago
The extension is simply removing the results from the search results. But if the first few pages are results i don't want to see thats not kind of making my life much easier as i just get empty results for the first x ones. Is there an
261.
by tpetry 5y ago
It‘s not planned. They are shipping new features in patch releases, yes, you heard correct. They had the genius idea to stay at 8.0.x and still add new features with every release.
262.
by tpetry 5y ago
Lawyers, an army of lawyers. You don't want to get letters from Oracle, IBM, Intel and Co. because you infringed some of their EULAs. They may be invalid, but it will be a very costly decade long court case. And the other part will pum
263.
by tpetry 5y ago
You should try pg_hint_plan ;)
264.
by tpetry 5y ago
The postgres team is advocating that compression should be applied the file system, and they are correct. But this won‘t solve the problem if filesystem compression is not widely available. ZFS and BTRFS are not widely used, the first one b
265.
by tpetry 5y ago
Many years ago when learning SQL i was looking at these state diagrams despite using another database. So yes, they should be added! They may not be usefull for anyone SQL who is able to read the Postgresql grammar definition but for someon
266.
by tpetry 5y ago
That"your app gets initialized and torn down for every request" is _the_ best feature of PHP. This may sound strange first, but it's true. With web applications written in any other language you have a stateful server running
267.
by tpetry 5y ago
> In general, the difference for a large application is non-negligible and one should carefully consider the impact before enabling this feature by default. And because of that they enabled it for all binaries on Fedora. The fedora users
268.
New Benchmarks Show Postgres Dominating MongoDB in Varied Workloads (2019)(enterprisedb.com)
3 points by tpetry 5y ago|1 comments
269.
by tpetry 5y ago
Who is saying the soldered ram is never overclocked? You cant overclock changeable ram by default because you don‘t know what the customer will use. But by soldering the ram you know you will use very specific parts, so you could (maybe the
270.
by tpetry 5y ago
You should read the „Mom Test“. Very often people say they like the idea, but still won‘t buy it.

More ›