To four years of bully bullshit and handmaid agenda.
To four years of bully bullshit and handmaid agenda.
To four years of bully bullshit and handmaid agenda.
This is the relationship i have:
Portfolio.shares.coin.latest_value_snapshot.value_snapshot
I searched for a way when viewing a single portfolio to order shares by their latest value snapshot’s usdt value. This is the query i eventually came up with:
Portfolio
.includes(
{shares: {coin: {latest_value_snapshot: :value_snapshot}}},
{latest_value_snapshot: :value_snapshot},
{shares: {latest_value_snapshot: :value_snapshot}}
)
.joins(shares: {latest_value_snapshot: :value_snapshot})
.where(value_snapshots: {valueable_type: "Share"})
.order("value_snapshots.usdt_satoshis")
.find(params[:id])
For the polymorphic part, the key ingredient is .where(value_snapshots: {snapshotable_type: 'Share'})
. This ensures that only the value_snapshots
that are associated with Share
are considered, filtering out those related to Portfolio
or Coin
. These have their own value snapshots.
The includes
is related to eager loading, preventing N+1 query issues.
The explicit joins
method helps creating the SQL join which help focusing the where
condition and order
method onto the value_snapshots
table correctly.
The order
method then applies to the usdt_satoshis
table. Note that I am using the money
gem to handle currencies, with USDT / Satoshis being a custom currency, hence the table name including the _satoshis
prefix.
So it’ll be BalticRuby in June and RailsWorld (if i get a ticket) on fall some time :)
Posted on July 13, 2024
//Tags:
“A rapidly changing society failed to recognize the structural and systemic causes of poverty and decline. It was as if the victim was entirely to blame for his or her situation.”
“This allowed us, in Annist’s view, to paint a picture of the opposite of dysfunctional: the individualistic and successful achiever. People held up this imaginary figure as a standard for others, disregarding the fortunate circumstances and supportive environment that typically led these individuals to success.”
“The demonstration attempted to change the situation in which farmers were continually spilling milk. Usually, they only did it on their farms. The demonstration attempted to bring this painful requirement to the public’s attention, but it became bogged down in reflection and interpretation of the action.”
“comparing the success of the 1980s protest to the 2017 action against tree felling for a road repair project in a Tallinn suburb. On the one hand, the wider public debate did not address whether such a road widening was even essential. On the other hand, the demonstrators were mocked for concentrating on the protection of reed. ”The protest was described as a waste of time, for example, because a hard-working citizen cannot be involved in such ‘nonsense,’” Annist explained.”
“Since the 1990s, instead of showing solidarity, Estonians have been comparing themselves with others on the basis of material indicators, she suggested. “It’s as if everyone’s future is being sacrificed for the sake of material success and the approval of the richest. Such blinders did not limit our thinking in the 1980s; today, very few of us are free of them. Unfortunately, it is difficult for us and for those in power to step back and reflect on whether the goals set in the 1990s are all sustainable,” she said.”
The irony that people whose only tools in a debate are deceit, sowing hatred, spreading misinformation and bashing their political opponents are using exactly the same methods when it helps them inside their own party… the irony seems lost on Helme.
This is a good reminder for other parties when planning to go into coalition with whatever comes out of this power struggle.
Conservative People's Party of Estonia (EKRE) Chair Martin Helme has referred to MP Henn Põlluaas' claims that Mart Helme, EKRE's founder, had praised Russia's so-called "holy war" in Ukraine.
news.err.eePosted on May 22, 2024
//Tags:
It’s unfortunate how the article doesn’t try to get a critical view to the comments made by the producer or user side. The directive doesn’t state as its purpose to reduce plastic, but to lower its impact on the environment.
Leaving the producer’s strawman of “more plastic used” and the users anecdotal “i’m inconvenienced in my car” or sheer gutwrenching “I don’t believe the scientifical result of the impact of plastic in the environment” is just another example of EU-bashing and bad journalism.
It’s always a bit sad to see how complex issues (impact of single use products on garbage piles in the sea, complexity of maritime and fishing objectives as a main driver of EU policy, effect of consumer behavior in one part of the EU and their outcome and impact of other parts of the Union) are trivialized instead of explained.
A recent switch towards plastic bottle caps which remain attached has had almost the reverse effect from that intended – ie. to cut down on the use of plastics – "Aktuaalne kaamera" (AK) reported Sunday.
news.err.eeAs an inhabitant of Uus Maailm, a father, walker, biker, driver, and someone with an interest in urban issues, I have been eagerly anticipating the results of this competition with high expectations and hopes. The redesign of Koidu Street on this side of the Endla / Suur-Ameerika “maantee” will have a major impact on how we, as citizens, will be able to live in and utilize our neighbourhood, Uus Maailm, far more than any other recent projects or street renovations, and likely for the next couple of decades.
When I look at the street, I see three major centers that require special consideration: the Suur Ameerika Entrance, the Koidu 80 plats, and the Humanitaargümnaasium / Koidu Park complex.
These three areas require a fundamental rethinking of how we consider public space. For me, this mainly means pushing further towards a car-free city (car-free not in the often misunderstood sense of forbidding cars, but in the sense of not depending on them).
As I understand, the brief asks for an urban space that prioritizes pedestrians/people above all modes of transport. For this reason, these three areas should go even further and fundamentally alter the traffic pattern by reducing through traffic to pedestrians and small vehicles, particularly in the school/park complex.
But also, to a degree, at the Koidu 80 plats, and (considering the proposed tram stop and the overall atmosphere setting character of an area entry) the Suur Ameerika Entrance. All the necessary functions of the street can be relocated elsewhere in the vicinity (parking, drop-off/pick-up around the school, utility vehicles).
The opportunity to combine school space and park space into one unit, uninterrupted unit by car traffic, is an amazing chance to create a truly free room for people to enjoy, reducing stress and noise.
Videviku can easily be restricted to pedestrian and small vehicle traffic at both ends, ending in Koidu, leaving access for residents, utilities, and emergency vehicles. This will create a real plats around Koidu 80 that can be traversed with vehicles along Koidu but does not become a transit thoroughfare between Luha and Tehnika. This should also be considered for Planeedi, Virmalise, Kiire, Videviku, Saturni, and Komeedi. None of the streets need to be traversable over Koidu.
Regarding the Suur Ameerika Entrance, the proposal from the Liikuvusagentuur T-Model 2022 should form the basis for any long-term considerations of how Koidu gets connected. It reasonably demands the reduction of the crossroads to a city- and human-sized dimension without losing any access opportunities. There is also a long-term vision to establish a good public space with facilities for the residents on the plot of the current gas station, another foundational entrance lighthouse project to mark the urban space as Uus Maailm. One could even dream of a proper connection between Kassisaba and Uus Maailm following this current project, and a further reduction of the Endla/Luise Autobahn.
These three outstanding areas will provide ample opportunity for the residents and the city to give purpose to the newly created urban space. Over time, given a certain flexibility and adaptability of people and administration, the newly emerging use patterns will offer “branding” opportunities for the area. And as we are looking at a decade-long development of urban character, we should reject any kind of preconceived branding that the proposals provide. Uus Maailm does not need marketing decoration or glossed-over historicized lamp posts, etc. Sensible preservation of historical details is, of course, preferable.
We need to be given the opportunity to properly use our urban space, and have an open ear and a long-term participatory vision following the much-welcomed redesign of Koidu Street.
Just testing static cms with jekyll
For example, we have TV “seasons” somewhere from about January 10 to Midsummer, or 22 weeks, followed by 11 weeks of summer, then 16 weeks for the fall season, and three weeks of Christmas and New Year.
We are governed by the sun, not by the government. How this is so can be particularly evident when you look at your TV viewing habits, and there is a whole science behind what we choose to watch and why, Raul Rebane reported in Vikerraadio's daily commentary earlier this week.
news.err.eeHere are some ideas on things you can do (now) that will create opportunities for yourself in the future:
Podcast
Give a talk
Write a blog
Go to meetups
Take a course
Learn new skills
Get a remote job
Join a community
Grow your network
Promote your work
Go to a conference
Start a newsletter
Publish on YouTube
Apply for a new job
Create a side-project
Explore a new industry
Collaborate with a friend
Build something in public
Become an expert on a topic
Ship a free project on the internet
Sell a small product on the internet
First comment:
You need to edit proxy settings for uptime kuma, under Custom Locations add a new location with location as / and then enter your scheme/hostname/port for uptime kuma. Then go to the gear icon besides location and enter
add_header 'Access-Control-Allow-Origin' *;
and then save.
Made static cms work with gitea/forgejo.
today in Tallinn a woman got killed by a reversing van on a sidewalk while waiting for the bus… and it’s not even front page news.
this city is so utterly fucked up with normalizing traffic violence, it’s beyond believe.
Täna toimus traagiline liiklusõnnetus Tallinnas Lasnamäel Punasel tänaval, kus hukkus 76-aastane naine.
PostimeesBefore thinking the app from top to bottom (fancy well-designed ui and ux) or bottom to top (thought out database model with all attributes and interactions), focus on figuring out if the app can do the most important thing it should do, try that out in some place, like the console and then move on from there.
All apps are essentially ETL bodies. We take data from somewhere (api, forms, imported files), do something with it and push it on (api or webhook, html site, etc). The transformation is the thing that is the business logic, the service, the work. That can really start living in a lib module, namespaced. Starting with self.function
model functions.
Have the maximum possibility space by waiting with a decision until the last moment when you have to take it.
I started a screencast series last week, and I can call it a series now because there's a second one.
justin․searls․coPosted on January 27, 2023
//Tags:
Die erste Frage ist Siebträger oder Vollautomat.
Ich ignoriere die Vollautomaten, weil:
Hier gibt es auch eine große Auswahl. Die wichtigen Kriterien:
Vollmetall ist selbsterklährend. Hier sind einfach alle Teile, Rohre, Ventile, etc aus Metall, und dementsprechend langlebiger, aber auch teurer.
Ob Einkreiser, Zweikreise, Dualboiler hängt dann vom Betrieb ab, aber für die ein paar Kaffees am morgen und über den Tag gehen die ersten beiden Versionen. Dualboiler sind da zu teuer. Schlussendlich ist das auch eine Komfortfrage: mit Einkreiser macht man halt erst den Kaffee, und muss dann auf Dampf umschalten und warten, bis Dampfdruck aufgebaut ist. Das macht das Kaffeemachen ein bisschen länger. Bei einem Zweikreiser kann man beides paralell bzw. gleich hintereinander machen.
Um immer gleiche Kaffeequalität zu haben ist eine Kaffemühle daneben schon wichtig. Die kleinen Mühlen mit Messer die viele Leute in der Küche haben sind schwierig, weil das Mahlgut immer anders grob wird. das hängt halt vom Halten und der Dauer ab, ist also eher zufällig.
Wir haben diese Kombi:
Ich hatte die vor 5 Jahren als Bundle bei www.stoll-espresso.de gekauft, Mühle für 290, Machine für 530. Dazu kam dann noch ein bisschen optionales Zubehör (Milchkann, Reinigungsbürste und Pulver, Edelstahltamper), und eine 5-Jahre extra Garantie. Also mit dem Setup bist du pi mal daumen bei rund 1000 Euro.
Das gute an der Maschiene ist die Wartungsmöglichkeit. Wenn man ein bisschen Geschick und Erfahrung mit Elektrik hat, kann man das Gerät einfach aufschrauben und drinnen ist alles reparier- und ersetztbar, mit nur wenigen Spezialteilen die man einzeln nachbestellen kann. Ich habe von Leuten gelesen, die ihre Silva Jahrzehnte in betrieb hatten.
Ein Problem was ich mit dem Garantieschutz jetzt mal mit Stoll besprechen muss ist der Metallfuss. Im Gegensatz zum Rest der Maschine ist der nicht aus Edelstahl und rostet. Und ich hoffe den ersetzt zu bekommen.
Wenn ich nochmal neu kaufen würde, dann würde ich die gleichen wieder nehmen, aber in der nächsten Version:
Dualboiler, nur um den Kaffee, Schaum, aber auch Kakao oder heißen Saft schneller machen zu können. Aber ist da der doppelte Preis gerechtfertigt? Ist also eher Luxus.
Der hat einen Dosierhebel. Jetzt wieg ich das Mahlgut, damit immer gleich viel in den Kaffee kommt. Das ist weichtig, weil ein paar Gramm mehr oder weniger schon darüber entscheiden ob entweder braunes Kaffeewasser kommt, oder gar kein Kaffee, weil zu viel Mahlgut im Siebträger ist… Mit so einem Dosierhebel kommt halt immer gleich viel raus.
Sollte das mit dem Budget oder Erwartungen alles überhaupt nicht hinhauen, dann kann ich aus eigener Erfahrung Kapselmaschienen mit wiederverwendbaren Kapseln empfehlen, da aber keine konkrete. Ich hatte mal eine Weile eine Nespresso. Aber da muss dann halt noch ein Milchschäumer dazu, wenn man irgendwelche Milchkaffeeversionen bevorzugt. Aber ich glaube mittlerweile gibt es Maschinen mit Milchschäumer. Das Handling mit den Kapselnachfüllen brauch ein bisschen Übung. Dafür ist die Zubereitung natürlich massiv vereinfacht und viel schneller. Einwegkapseln lehne ich aus Müllgründen jedoch grundsätzlich ab, auch wenn deren Kaffeegeschmack ganz ordentlich ist.
Ich bin irgendwann auf die Zuriga gestoßen. Das Produkt ist noch mal eine Preisklasse drüber, und es gibt es noch nicht so lange, aber es ist so schön anzusehen.
Some ideas here for social change, however, based on US analysis.
raise the minimum wage and tie it to inflation
roll back anti-union laws to give workers more leverage against companies that treat them as if they’re disposable
tilt the tax code away from the wealthy
attach benefits to work instead of jobs: For every hour you work, your boss chips in to a fund that pays out when you get sick, pregnant, old or fired. The fund follows you from job to job, and companies have to contribute to it whether you work there a day, a month or a year.
construction workers have an “hour bank” that fills up when they’re working and provides benefits even when they’re between jobs
Hollywood actors and technical staff have health and pension plans that follow them from movie to movie
in low employment / mid to high human resource areas launch a program that simply reimbursed employers for the wages they paid to eligible new hire
improve existing poverty fighting programs and handouts over basic income
Curious about structures and process, how to rethink ownership of companies. This is one example from the US.
Architects Marshall Blecher and Magnus Maarbjerg are on a mission to breathe new life into Copenhagen’s old harbour. They’re working on a floating archipelago that will introduce a new type of public space.
Would be interesting to see something like this in Tallinn.
Vivahouse co-living is a global platform that provides lifestyle focused, affordable, flexible shared accommodation.
Why does the Institute for Advanced Architecture of Catalonia (IAAC), a world-leading university in the field of architecture, continue its research deep in the woods outside Barcelona?
sure, we should do studies, and get more data, and have a full view of the …ah, there goes my dad, who is 74 with heart condition… data. we should also make sure that the we really only shut down the areas of the economy that are actually …ah, now my mom’s dead, cause she has worse chances than the new born with its mum who is 24 and also needs a respirator in a hospital with 15 places…affected by the pandemie. after all, we shouldn’t sacrifice the economy on the altar of public health …and now my grandmum is also dead, along with the 20 others in the nursery home where they still had ‘social visits’ to keep up the spirits.
you know what? who cares. some people (loose couple of scientists/doctors, a handful who have come out in the last couple of days, in a profession of what, maybe 10.000, 15.000 professionals, that just do the actual work?) just think they have eaten it with spoons, the wisdom of how to run a massively complex society of tens of millions of people.
but sure, i’m happy that they come out now and speak up, and ask the “really important questions, that yeah, actually, it makes so much sense when you think about it”. truly. it’s a right to spread your opinion, and i cherish that, really. it also helps me to figure out who i don’t care about when i need to focus on keeping my babies healthy, hope the best for my pensioner parents, and watch the images of stashed away coffins with actual dead people.
we are not trapped in here with the coronavirus, the virus is trapped in here with us.
Look at it in this way maybe.
Robot delivery company Starship Technologies made a large number of redundancies last week after feeling the economic effects of the coronavirus pandemic, website DigiPRO reported.
A company uses an external crisis to restructure their business to the expense of its workers. That is nothing new. That is why other countries have made laws against that kind of behavior towards employees. How is this surprising?
Cutwork’s furniture designs are based on their signature metallic tubes that are being laser-cut to allow them to be bendable. This simple solution brings the production close to the end-users and the furniture can be manufactured on demand eradicating additional costs of storage. If production locally is not an option, emissions from shipping are still kept low by flat-packing all pieces and assembling them on site. As the main material — steel — can be also easily recycled, Cutwork is about to become certified as offering all circular products.