ako

33 ms·

541.
by ako 3y ago
If I get in at 11 it usually means I’ve already done stuff at home, probably between 8 and 10. Getting in late doesn’t mean that they’re starting late.
542.
by ako 3y ago
There's plenty evidence that uncontrolled capitalism creates a few very wealthy individuals and lots of others barely scraping by, often holding multiple jobs. The US is not a great example that everyone benefits from capitalism, too m
543.
by ako 3y ago
Most polarizing for me are the dramatized history movies like Napoleon. Most of the public will not be aware of what parts are true, and what parts are fiction. History will be remember as portrayed by these movies. They're basically c
544.
by ako 3y ago
If china wants to deliver to the west they'll need to improve working conditions. Chinese companies will deliver at spec for lowest cost, if you up the spec, they'll adjust and increase cost adjustingly.
545.
by ako 3y ago
Rules on products sold in the west. Most manufacturing companies already need to trace the origin of their components, so you could specify what products are and aren't allowed to be sold in the west.
546.
by ako 3y ago
Western companies can't afford to care, as their consumers are buying based on price. Bad working conditions usually mean lower prices, and more success for the company using this. You can't expect companies to fix this, this need
547.
by ako 3y ago
And how many non-technical users do you know that write good javascript/java/.net/etc code?
548.
by ako 3y ago
Neither do good SQL developers: you can easily structure database logic in multiple stored functions, stored procedures, packages, and multiple files. Unit test frameworks are also available.
549.
by ako 3y ago
You're blaming the language for the bad coding practices of the developers. You can build maintainable database code, and modern SQL IDEs like Datagrip provide similar tools for SQL like you have for other languages, e.g., refactoring,
550.
by ako 3y ago
And then it becomes less available to the people who need it?
551.
by ako 3y ago
And in any other language this wouldn’t result in multi-thousand lines of code with historical business logic and edge cases?
552.
by ako 3y ago
Use views and stored procedures if you need composability.
553.
by ako 3y ago
Here's an example i have running on a pi with a temperature sensor. All data is received as json messages in mqtt, then stored as is in a postgres table. The view turns it into relational data. If i just need the messages between certa
554.
by ako 3y ago
Assume you're writing an editor for JSON files. Don't think many users of that editor would be very happy if you change the order of the attributes in their json files, even though technically it's the same...
555.
by ako 3y ago
Users are just different, I’ve been a happy Firefox (and pocket) user for many years, and wouldn’t be happy with these so called improvements. I don’t need customizability, just need it to work good enough out of the box. Definitely don’t f
556.
by ako 3y ago
What should Firefox do for you to select it as your default browser? (It’s my default browser, I’m pretty happy with it, also use the pocket functionality quite bit)
557.
by ako 3y ago
Don’t know, as a shareholder I would be very happy with a capable CEO that is able to extract profits from a doomed product. As long as she’s bringing in more than she costs the ROI is positive.
558.
by ako 3y ago
It’s simple math: how much revenue does she bring in, versus the costs. And how likely is it for the organization to find someone else that brings in equal or more, for reduced salary.
559.
by ako 3y ago
> When you want to create a set of data that crosses user boundaries, it gets complicated. So it sounds like this excludes most enterprise use cases?
560.
by ako 3y ago
Yes, a bit like machine learning models.
561.
by ako 3y ago
So? Just make sure you regularly refresh the statistics...
562.
by ako 3y ago
Most databases will allow you to collect statistics on every query run by users, e.g., pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.htm... A relational database really shines when y
563.
An automatic indexing system for Postgres(pganalyze.com)
243 points by ako 3y ago|45 comments
564.
by ako 3y ago
SQL server: https://learn.microsoft.com/en-us/sql/relational-databases/a... Interesting read on a project implementing this for Postgres: https://pganalyze.com/blog/automatic-indexing-sys
565.
by ako 3y ago
That is not a SQL mistake, but an implementation choice. Most modern databases can determine where indexes should be added, and add these automatically. E.g.: https://www.oracle.com/news/connect/oracle-database-aut
566.
by ako 3y ago
Agreed, just wanted to stress the point that it is often not even an option for a potential employee to try and compete on skills.
567.
by ako 3y ago
There are many situations where employers are not interested in skills, they’re just looking to fill a position with the cheapest (licensed) person. There’s very little ROI in upgrading your skills in this situation.
568.
by ako 3y ago
Serverless = not having to think of server size for running the database, it scales as needed.
569.
by ako 3y ago
Sized to fit in a car?
570.
by ako 3y ago
But it is irrational that religion brings people comfort and peace. Why do stories do this?

More ›