-
6 votes
-
Denser housing is gaining traction on America’s east coast
9 votes -
Fitness Weekly Discussion
What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started...
What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?
5 votes -
Uptime 15,364 days - The Computers of Voyager
6 votes -
What have you done in the last ten years?
Asked in the spirit of the new decade. I am 14, so mostly growing up and realizing that the world is probably going to enter a recession when I reach adulthood which will suck for reaching...
Asked in the spirit of the new decade.
I am 14, so mostly growing up and realizing that the world is probably going to enter a recession when I reach adulthood which will suck for reaching financial independence.
Going through puberty, even if it's just the beginning of it and seeing one of my cats die from kidney failure and hearing that my grandma died from cancer, which is very sad :(
27 votes -
Which emoji scissors close
38 votes -
L.I.E.S Records: Various Artists - Eminent Domain
5 votes -
The Beatles - by Peter Sellers
A Hard Day's Night She Loves You (there's four different versions) Can't Buy Me Love Help Background info
6 votes -
Australian navy begins evacuation of beach where thousands had sought refuge from fire
17 votes -
Don Larsen, New York Yankee who pitched only perfect game in World Series history, dies at 90
6 votes -
How do you explain tech topics when your audience doesn't understand the details?
Hive mind: What advice would you give to someone who has to give a presentation to a non-technical person, and it's important that the listener actually understand the details? How do you go about...
Hive mind: What advice would you give to someone who has to give a presentation to a non-technical person, and it's important that the listener actually understand the details?
How do you go about it? Specific tips appreciated. Pretend it's for a friend you care about.
(This is for an article. Ideally we could refer to you by reference for context and credibility, eg "an IT security pro at a midwest insurance company" or "aerospace engineer" so please give some kind of identification to use).
12 votes -
On privacy versus freedom
9 votes -
Ask Tildes: Design practices for retrieving dozens (or hundreds) of related records over a RESTful API
I'm looking for some feedback on a feasible mechanism for structuring a few API endpoints where a purely RFC-spec compliant REST API wouldn't suffice. I have an endpoint which returns $child...
I'm looking for some feedback on a feasible mechanism for structuring a few API endpoints where a purely RFC-spec compliant REST API wouldn't suffice.
I have an endpoint which returns $child entries for a $parent resource, let's call it:
/api/parent/:parentId/children
. There could be anywhere from a dozen to several hundred children returned from this call. From here, achild
entity is related to a singleuserOrganization
, which itself is a pivoting entity on a singleuser
. The relationship between achild
anduser
is not strictly transitive, but can eachchild
only has oneuserOrganization
which only has oneuser
, so it is trivial to reach auser
from achild
resource.Given this, the data I need for the particular request involves retrieving all
user
's for aparent
. The obvious, and incorrect solution to the problem is to make the request mentioned above, and then iterate through and make an API request to retrieve eachuser
. This is less than very good as this would obviously be up to several hundred API calls.There's a few more scalable solutions that could solve this problem, so any input on these ideas is great; but if you have a better proposal that also works, I'm keen to explore that!
Include
user
relationships in the call by default.This certainly does solve the problem, but it's also pumping down a load of data I don't necessarily need. This would probably 2x the amount of bytes travelling along the wire, and in 8 out of 10 calls, that extra data isn't needed.
Have a separate
/api/parent/:parentId/users
call.Another option that partially solves the issue: I need data from both the
child
and theuser
to format this view, so I'd still need to make the initial call I documented earlier. Semantically, it feels a bit odd to have this as a resource because I don't consider auser
to be nested under aparent
in terms of database topology.Keep the original call, but add a query parameter to fetch the extra data
This comes across as the 'least worst' idea objectively, in terms of flexibility and design. Through the addition of the query parameter, you could optionally retrieve the relationship's data. This seems brittle and doesn't scale well to other endpoints where it could be useful though.
Utilize a Stripe
expands
-style query parameter.Stripe implements the ability to retrieve all related records from an API endpoint by specifying the relations as strings. This is essentially the same as the above answer, but is scaled to all available API endpoints. I love this idea, but implementing it in a secure way seems fraught with disaster. For example, this is a multi-tenancied application, and it would be trivial to request
userOrganization.user.organizations.users
. This would retrieve all other organisations for the user, and their users! This is because my implementation ofexpands
simply utilises the ORM of my choice to perform a database join, and of course the database has no knowledge about application tenancy!
Now, I do realise this problem could easily be solved by implementing a GraphQL API server, which I have done in the past, but unfortunately time and workload constraints dictate implementing a GraphQL-based solution is infeasible. As much as I like GraphQL, I'm not as proficient in that area as compared to implementing high quality traditional APIs, and the applications I'm working on at the moment are focusing on choosing boring technology, and not using excessive innovation tokens.
Furthermore, I do consider the conceptuals around REST APIs to be more of an aspirational sliding scale, rather than a well defined physical entity, because let's face it, the majority of popular APIs today aren't REST-compliant, even Stripe's isn't, and it's usually both financially healthier and feature-rich to choose a development path that results in a rough product that can be refined later, than aiming for a perfect initial release. All this said, I don't mind proposals or solutions to my problem that are "good enough". As long as they aren't too hacky! :)
10 votes -
How to best utilise 5k GBP
Hey everyone, as a goal for this coming year I’d like to better put to use the small amount of savings I have. My first idea is: 3k emergency fund in a NS&I Government insured account. 2k in a...
Hey everyone, as a goal for this coming year I’d like to better put to use the small amount of savings I have.
My first idea is:
- 3k emergency fund in a NS&I Government insured account.
- 2k in a Vanguard index fund.
A few questions:
-
Is this sort of setup the best use for such a sum?
-
If so, with the impending brexit, does it makes sense to move the money out of the U.K?
-
Is there much maintenance with an index fund or is it sufficient to let the money sit? I’m aware anything of this nature is essentially a gamble.
-
How do you calculate a worthwhile amount to invest considering the on-running service costs?
-
Does anyone have experience with ethical index funds? If so which? And how have they performed for you?
Any help is most appreciated.
11 votes -
Sweden dodged a bullet by not building this nuclear submarine – the reactor had an insufficient amount of nuclear shielding
5 votes -
We regret these errors: Mistakes were made at The Stranger in 2019
7 votes -
Earth is missing a huge part of its crust. Now we may know why.
15 votes -
Flammekueche
11 votes -
California's new employment law is starting to crush freelancers
5 votes -
Top Movies of the 2010s
The end of the year has me in a movie-watching mood and I want to add the best of the best into my queue for the next few weeks. Similar to games of the decades, what are your movies of the...
The end of the year has me in a movie-watching mood and I want to add the best of the best into my queue for the next few weeks. Similar to games of the decades, what are your movies of the decades and why?
22 votes -
How a Chase Bank chairman helped the deposed shah of Iran enter the US
5 votes -
I'm not feeling the async pressure
5 votes -
Common gas market for Finland, Estonia and Latvia launches following the completion of the Balticonnector pipeline last month
3 votes -
Pagal Records: Awara Sound - Disco Erc (2020)
3 votes -
Don't trust online reviews (personal anecdote)
I recently bought a product online. I wasn't able to find it in a bricks-and-mortar shop, so I had to buy it online to even see it, let alone try it. I received it, and it wasn't right for me. I...
I recently bought a product online. I wasn't able to find it in a bricks-and-mortar shop, so I had to buy it online to even see it, let alone try it. I received it, and it wasn't right for me. I was able to exchange it for a different version, but even the different version wasn't right. So I returned the product and got a refund. All along, the customer service was excellent, but the product itself turned out not to be what I wanted.
The way the product failed for me was connected to the "headline" description of the product. It wasn't a minor failure. It did something that they explicitly said it wouldn't do, which was one of the main selling features of the product.
After the dust settled, I wrote a review of the product. I don't normally do this: I neither write nor read reviews. However, I know that other people do rely on reviews and, seeing as this product is only available online, and its failure was linked to a major selling feature of the product, I felt duty-bound to inform other prospective buyers that it might not suit some people. I gave it a 2-star (out of 5) rating, as well as writing up why it didn't suit me (while allowing that it might still suit other people).
Since I submitted the review, I have checked the website (I'm an egotist: I wanted to see my words being published!). Other reviews with more recent timestamps have appeared, but my review has not appeared. I've now noticed that the lowest rating in their reviews is a single 3-star rating, with some 4-star reviews and lots of 5-star reviews. There are no 2-star or 1-star reviews. My only conclusion is that the company selects which reviews to publish - and which ones not to publish.
I've always wondered if companies would post negative reviews of their own products. Now I know for sure that at least one company does not.
18 votes -
Project-Specific Programming Suggestions for Newbie
8 votes -
Residents in 24 states and Washington, D.C. will see a minimum wage increase in 2020. The increases range from $0.10 per hour—in Florida—to $1.50 per hour.
7 votes -
Mansplaining convention coming to Orlando promises to 'Make Women Great Again'
16 votes -
What are lost continents, and why are we discovering so many?
8 votes -
Zlatan Ibrahimovic has arrived in Italy for a medical ahead of rejoining AC Milan
6 votes -
New South Wales and Victoria just jumped 1.8 metres north
10 votes -
Denmark sources record 47% of power from wind in 2019 – boosted by steep cost reductions and improved offshore technology
5 votes -
The case of Leopold and Loeb
4 votes -
Happy 2020 everyone!
I’m a bit tipsy, but I sincerely mean this to you all: I wish you a prosperous year and decade. This site has been an encouraging sign the last year - May it last ever on! I wish a peaceful and...
I’m a bit tipsy, but I sincerely mean this to you all:
I wish you a prosperous year and decade. This site has been an encouraging sign the last year - May it last ever on!
I wish a peaceful and prosperous new year on all :)
44 votes -
In 2020, skip your resolutions—Embrace a vice
11 votes -
What are some games like VA-11 HALL-A and Read Only Memories : 2064?
I played VA-11 HALL-A quite a while ago and recently played ROM 2064. Both have similar aesthetics, sound, themes although they have different mechanics. I really liked how ROM had voice acting...
I played VA-11 HALL-A quite a while ago and recently played ROM 2064. Both have similar aesthetics, sound, themes although they have different mechanics. I really liked how ROM had voice acting too which is a shame to say is not the case of VA-11 HALL-A but I still quite enjoyed both. 2064 perhaps more since it felt more engaged but perhaps that's just memory tricking me.
I know there's N1RV Ann-A and ROM Neurodriver coming in 2020 but well, after that, I'll still have nothing so, what games have you played which are similar?
PS : Have a happy new year and hope I've not posted in the wrong place, I'm not sure if it would've fit in the recurring topic.
9 votes -
Nothing defines the 2010s
3 votes -
Ability to hide posts that link to specific websites
I'd be interested in a feature where I can have a list of top-level domains that I want to ignore content from. For example, I'm never in a position to watch a video when I'm browsing tildes. So...
I'd be interested in a feature where I can have a list of top-level domains that I want to ignore content from. For example, I'm never in a position to watch a video when I'm browsing tildes. So I'd like the option to just not see any link to youtube.com or vimeo.com. Maybe I think all content posted to example.com is inflammatory click-bait, so I just want to ignore those links, too.
Would that be possible?
11 votes -
The man who made Wolfenstein
9 votes -
Opera introduces web browser designed for gamers
21 votes -
When was the first time you felt different?
All of us know the feeling; some of us have felt it more intensely than others; some of us have to continue to live with it daily. When was the first time you really became aware of it? What did...
All of us know the feeling; some of us have felt it more intensely than others; some of us have to continue to live with it daily.
When was the first time you really became aware of it? What did it feel like? How did it play out?
30 votes -
Thousands of Google’s cafeteria workers have unionized
24 votes -
Zupiter - web based modular synthesis
5 votes -
Explanatory narratives - tell your stories!
I've commented on explanatory frameworks before. These are the unifying narratives that we use to make sense of ourselves, political concerns, economics, and even science and mathematics....
I've commented on explanatory frameworks before. These are the unifying narratives that we use to make sense of ourselves, political concerns, economics, and even science and mathematics. Narratives are accounts of connected events or phenomena that attempt to express the connections in an explanatory story.
We're often afflicted with "just-so" narratives that attempt to reconcile or explain the way the world works with little or no evidence, like claiming inequality of inborn capacities, innate racial differences, or the intervention of supernatural entities and forces.
So this is everyone's chance to tell a story, at whatever length they find convenient, which explains something that concerns them. Possible examples of story topics:
"Why finding work is a struggle for me"
"Bayes' Theorem accounts for everything"
"Political parties can't handle reality"These examples aren't about me or my beliefs - I'm just flinging things out there. This also isn't a college narrative essay exercise. So just tell a good story about something you care about, that's likely to engage others' interests and concerns.
Conspiracy theories are probably not a good idea here; the tendency towards them is a dysfunction of humans' ability to create, and desire for, narratives.
I ask that participants in the thread refrain from attempting to argue with or disprove others' stories here, but they can become jumping-off points for new Tildes topics.
If this exercise is well-received, it could become a monthly recurring thread. Feel free to advise on better structure.
17 votes -
The making of Outer Wilds
9 votes -
Pitchers and catchers report in forty-one days!
3 votes -
What games have you been playing, and what's your opinion on them?
What have you been playing lately? Discussion about video games and board games are both welcome. Please don't just make a list of titles, give some thoughts about the game(s) as well.
16 votes -
Fitness Weekly Discussion
What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started...
What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?
7 votes -
The Duke and Duchess of Cambridge unveil a global prize to tackle climate issues in the next decade
8 votes -
A California church raised money to pay off the medical debts of 5,555 struggling Los Angeles–area residents, wiping out more than $5 million in bills.
16 votes