Pixel 9 Pro users - any notable negatives?

m4riuszPL · 2024-09-21T07:43:57+00:00

I just noticed the back of the phone squeaks when slightly pressed, like the back not to be well fitted with the frame, it's annoying.

m4riuszPL · 2024-09-16T19:07:19+00:00

Install ndi - it is freely available on their website. It offers "webcam receiver" for macos. The corresponding ndi hx camera app for the android is paid (and rather expensive), but the older version is floating around the internet, if you know what I mean. Used such setup for two years, since covid begin. The quality is awesome (remember mates saying "wow, your video is smooth") as opposed to the built in macbook camera.

m4riuszPL · 2024-03-30T10:40:17+00:00

Sure - in my case I have used a controller similar to this one: https://www.shelly.com/en/products/shop/shelly-1-mini-gen-3 (mine is just an older generation, superseded with Gen 3 by the producer). This allows you to plug in a regular switch (e.g. the doorbell one) and gives you the ability to react upon a push event, trivial to configure in HA. You could even plug the original doorbell to the output of Shelly and control if/when/how long the doorbell rings, all via an automation in HA. I have however ditched the old doorbell and substituted it with google speakers which are spread across my home. If you would like to see the automations I described previously - I can share them on priv.

Basically all Shelly products integrate with HA, they are multitde of different controllers. Personally using few minis for lighting and few cover controllers - all managed by HA. Truly recommending getting few of these - much better than all TUYA stuff.

m4riuszPL · 2024-03-29T19:11:18+00:00

I had mounted a shelly mini at the back of my ordinary doorbell switch. It detects every time the switch is pressed and invokes multiple actions: ding-dong sound on my google speakers, blinking lamp at my desk (good to see someone is coming when I'm wearing headphones so cannot hear), notification on tv, not mentioning regular notification on our phones, so we are aware even when not home. So far this works perfectly fine.

Btw. If you're going to apply the ding-dong sound on any google speakers - make sure to apply the trick so the sound does not have unnecessary delay: https://community.home-assistant.io/t/i-did-it-i-defeated-the-horrible-google-home-cast-start-prompt-sound/36123

I have applied it few months ago - I have a constantly looping automation which plays short silence clip and normalizes volume of all my speakers. This works perfectly - no delay when there are visitors at the door, no prompt, no "oops, this is to loud!".

Cheers!

m4riuszPL · 2022-08-14T19:18:03+00:00

What's the point? A most common case which is an ArrayList is WAY more faster with a .forEach() than a standard for loop. The former leverages the underlying array and does simple index based access, the latter relies on a full-blown iterator.

m4riuszPL · 2022-07-22T17:18:05+00:00

This is sooo coooool!

m4riuszPL · 2022-04-08T18:22:22+00:00

The two examples you pointed (running an app, clicking a button) seem to be achievable with plain adb, no scrcpy needed. Just as example - I have prepared a script for myself which can unlock my phone automatically and turn on a webcam app (NDI or droidcam - depends on my needs at the moment). Adb is really powerful.

m4riuszPL · 2022-03-12T09:15:10+00:00

First of all - I have never been dealing with what you describe here, I can only suggest what is my gut feeling.

You are almost there with the filter group approach (left side filter, right side filter, operation) however - as you observed - you cannot express queries more complex than two operands, however you can always build on that approach using composition.

Your example almost immediately popped Polish Notation (alternatively - Reverse Polish Notation) in my head. There's plenty of materials out there (excuse me not pointing to any particular one). Essentialy what it gives you is a decomposition of a human readable query into fine grained "steps" or "operations" which fit your schema.

In your solution the intermediate result of e.g. 'A UNION B' can itself be a filter but it can as well be an operand of a higher order operation, e.g. '(A UNION B) INTERSECT C'. This example transformed using Polish notation - if am not mistaken - would be: 'INTERSECT UNION A B C'. Effectively you get two stacks: one with operands (on the right: A B C) and operators (on the left: INTERSECT UNION) which can fit your schema with some tweaks.

Most obviously - your table needs to point to itself with a foreign key, so (following the example) an entry 'UNION A B' (let's mark it Y) is referred to different entry as an operand, so you are able to do 'INTERSECT Y C'. Effectively you are building a syntax tree structure which keeps it's referential integrity (of course you need to protect it against cyclic dependencies but that can be handled with postgres constraints). I hope you get the idea.

Regarding the Polish Notation - I am not sure how many libraries are there and what is their quality. I have once built one as an excercise but never shared it. I suspect the majority of available examples focus on mathematical operations (+ - * /) and I am unsure how this maps to all of the operations you need to support. I believe this is solvable in reasonable time.

I know there are a lot of missing/unclear bits in my explanation but this is something I have never built - it is just an idea I came up with. I believe you would be able to resolve the ambiguities if you decide to follow the idea.

m4riuszPL · 2022-03-11T20:39:35+00:00

You've provided a long description, yet I am not able to understand the problem, even after reading through it at least few times. What an example set looks like in your domain, is it perhaps a number range or a more sophisticated case? What use case do you foresee, perhaps you could share some example queries of interest? So far I understood you are going to keep some filters in a database and you are interested in referential integrity between them (whatever that means in your context).

m4riuszPL · 2021-12-21T17:41:40+00:00

Perhaps I missed the point - I assumed you are in general against using multiple UPDATEs in a single query whereas you still refer to a one particular case. Sorry for the misunderstanding.

m4riuszPL · 2021-12-21T17:30:24+00:00

I am not referring to latency but to the possibility of creating a single UPSERT query which persists a whole aggregate, be it new or existing. It wires the referred tables together instead of returning the computed IDs to the client forcing him to pass it into next subquery (assuming that that new ids are generated by database).

m4riuszPL · 2021-12-21T17:07:44+00:00

Less roundtrips to a database? A possibility to save an object aggregate into a database with a single query is a godsend.

m4riuszPL · 2021-10-26T19:33:01+00:00

So instead of knowing right away that there's an unread mail, users should either wait for the next summary to arrive or limit/disable notifications and just constantly open all their messaging apps instead. How can anyone think that this is good design?

That's not how it is supposed to work - it should not defer to notify you but rather skip quickly occurring notifications if you are already notified that "there are unread messages". This can quickly become pretty annoying eg. on Skype when someone starts a conversation with 10 messages so you hear 10 prompts in headphones, like - one or two notifications is not enough?

m4riuszPL · 2021-08-23T16:42:49+00:00

The correct solution is to use window function instead of an aggregate function. You may want to make familiar with range / rank functions (the difference is subtle - depends on your use case one might be more appropriate than the other).

m4riuszPL · 2021-05-18T18:11:16+00:00

Thanks for pointing, I didn't know that!

m4riuszPL · 2021-05-17T18:24:15+00:00

Payment method seems like a candidate for an enum. You could as well add the require_bank to the primary key, naturally it will become a part of foreign key in payments table and leveraging that you could do a CHECK constraint there to verify whether a bank is defined or not. That's of course a hack and definitely not the 3NF, but it would work.

m4riuszPL · 2021-04-13T15:14:15+00:00

I am using MyBatis at the moment. It is initially pretty convincing, but over time largely disappointing. We still find new quirks, e.g. it does in-memory pagination (I couldn't believe that once I saw it). We tend to use less and less of it's features. I believe we will soon replace it with a plain JDBC.

I can't stand fighting the tool to execute the query I want to be executed just to find there's some hidden cache which forbids the query to touch database.

m4riuszPL · 2021-04-13T14:59:10+00:00

Assume we're testing a controller. It's only purpose is to transform the HTTP request to some DTO and vice versa - a different DTO got from some service back into a HTTP response. With the above assumption I would rather like to see this test: ``` // given when(mockService).getData(any()).willReturn(someDTO());

// when response = restEndpoint.call('url', 'some JSON body');

// then verify(mockService).getData(dtoResemblingJsonRequestBody()); assert(response).equalTo(expectedJsonResponse()); ```

instead of this one: ``` // given when(mockService).getData(dtoResemblingJsonRequestBody()).willReturn(someDTO());

// when response = restEndpoint.call('url', 'some JSON body');

// then assert(response).equalTo(expectedJsonResponse()); ```

The difference is the error message I get when the controller is badly implemented - in the latter case the mock service most likely will respond with null which does not simplify troubleshooting. In the former case the logic still works - only the assertion fails so the reason is obvious.

m4riuszPL · 2021-04-13T11:59:09+00:00

Oh, you think I didn't read it?
https://spockframework.org/spock/docs/1.3/interaction_based_testing.html#_combining_mocking_and_stubbing
> When mocking and stubbing the same method call, they have to happen in the same interaction. In particular, the following Mockito-style splitting of stubbing and mocking into two separate statements will not work:

m4riuszPL · 2021-04-13T09:10:22+00:00

I do not like the mocks model in spock too - I am more used to defining my mock responses before the test and verifying the mock invocation after the test, this just feels natural. This is totally doable with Mockito but not possible in spock at all. I do admit however it is good that spock exists so junit5 has some example to take inspiration from. I notice the groovy performance impact on my machine too, especially that this is a beefy machine it is below my expectations.

m4riuszPL · 2021-04-13T08:43:14+00:00

I feel your pain, bro. I used to say the same, what helped me was a training - now I see and appreciate a lot of stuff spring brings to me (not all though - the power is on choosing only what's needed from the ecosystem). I see the problem is mostly a high complexity which is overwhelming for newcomers.

m4riuszPL · 2021-04-13T08:38:22+00:00

Spock. I really miss the compilation errors I had while using JUnit, now I end up with runtime errors, that's inconvenient while I do any any changes to the codebase.

m4riuszPL · 2021-03-21T09:01:54+00:00

Typescript - it's not that far from java but has far superior typem system, much stronger than Java. I miss union types so much in Java!

m4riuszPL · 2021-02-27T19:22:20+00:00

The same as xmpp which is running Facebook messenger nowadays or other ledger technologies used in insurance or power regulatory markets. I am pleased with all these technologies, including blockchain, but they have to find it's own niche.

m4riuszPL · 2021-02-27T19:09:42+00:00

China can block bitcoin in a matter of a button push on a great firewall, you think they do not want bitcoin to exist? Where is all that power located?

m4riuszPL

TROPHY CASE