James' Audiolog: Indie.am Indie.am

So I've been playing with sql.jSHTtPvfs for a few months now. Basically, what this is is it's a sequel light worker compiled in web ASM and it runs against the remote database now the interesting that is the implements, implements a virtual file system and arrange requests. So say you have a gigabyte SQL database somewhere in the cloud. As long as you have a FASTSIGNS support range requests, then this is just grabbing data, one kilobyte at a time. Similarly, to how a sequel, I would read a local database from the file system if it was configured to page with file, reads of 1024 bias anyway, that's the interesting part. So what makes it interesting is, if you indexed an organize your data, in a way that a request would be fast from a local SQL database, then in theory, you could perform the same requests remotely from the browser to that SQL database on a CDN, but you're Back in the server would not be running a database senses and in theory, if you optimize those they would be, they have some overhead for every request. But in theory it's not horrible, but maybe your hundred millisecond request becomes her 900 and the second request, something like that. So I was thinking about it and in August I wrote a possible analytics clone in a couple weekends that used sequel to JSHTTPVFS end. It was interesting, but it was not interesting to me as I just very Leslie implemented it. It cleared a lot of data, it might as well just download the entire database because it didn't really taste the idea out too thoroughly, but give me a chance to play around with it. And it was a nice proof of concept fast forward to December, and I rewrote this at to start off with in injects walk parser, so that I will have a pretty large status at minded up with a 300 MB log file, which I parsed turns into a Roughly 300 MB equal a database, and that gave me a large enough database to play around with him. It was large enough that I had to optimize long, parsing and inserts so that it didn't take an incredibly long mountain time to parse over. I think 1.3 million rose. I got it down to about 57 seconds and then includes a bunch of like I Peed, a country, look at parsing, URLs person, user agents, things like that, nothing that requires a web request, just things that can be done locally and I know it's all stored in Sql light which brought me to actually querying the database running it locally or indexed that size Deezer about 13. Second, queries to just group by pathname to do like top 25 requested pages and then count of requests for that page, not ideal and for the server that I was looking at. I actually only loaded like eight hours of data, so it would be a much larger data set in production. So obviously that's not gon na work, even if it run locally. So I would never have a whole of adding a few indexes and immediately you know that clears up the problem that becomes like 100 and 300 millisecond. Where is than when you get to the end of all this and get it working, and you know I'm just about to implement the web assembly module and do it all remotely when it occurs to me, why why? What does it get you to get you like? A little bit of scaling, you know say that there's no overhead, it just means you can scale. The number of reads infinitely doesn't really make a lot of sense. It'S like now that I reduce this to like the eight or so columns that I want to index. I'Ve basically written out the only eight SQL queries in a run against this. I might as well pre-computer or from the sky surfer, because it's it's kind of pointless to do this over 80 TTPVFS unless you're talking about sticking it on a CDN and then, like millions of people, view those charts and you just can't be bothered to pre-compute the Data, this is like the most interesting little thing I've played around with in a while. I got to the end of it, and it's just like wait as fun as this is like. This is not a compelling use case for the virtual file system that works over HTTPit's like

Airpods max day, one review so a little bit of that ground. I don't the AirPods pro pretty much since they came out. It'S probably my favorite pair of headphones. Ever I've tried it starts higher quality headphones as soon as there make some nice open backs. I can appreciate it for like short sessions of listening an hour or less. I try not a couple times and if, like headphone jacks and wired headphones were still a realistic option, I would consider just trying to max out absolutely best audio quality possible. Investing in a nice set of headphones but AirPods Pro have a great next features: fast: wireless pairing, decent battery life, durability, portability, wireless charging, really great noise cancellation and perfect ergonomics around the touch controls. It'S like, I said the my favorite pair of headphones. I'Ve ever owned. Even though I'd say there's a little bit to be desired in audio quality and if I'm being honest you you compare it to any of that over your headphones back to back you're gon na notice, the difference. So I tested the AirPods Max a few times. A short like 10 minute sessions - I wasn't as impressed as I hoped I would be either time like, maybe after this four times up, but they do deliver a better range and then the pro special overtime I like low and high that's pretty much nonexistent on the Pros the trouble is after using these for a day, the economics are just trash, comparing to the pros like the overall experience of using the pros is 10 out of 10, but the max is like: let's eat cow 30 %, higher quality audio, but you're gon na Lose a lot. This is gutless like OK, so stupid. He probably heard that before and the buttons are in a weird place, the headphones don't really fit had. It will stay on as I'm perfectly still sitting down and even if I'm perfectly still sitting down like working on the move, my glasses around the current I saw they move around the point where, like I have to remove the headphones, adjust my glasses, replace them, adjust Them again, oh that's kind of annoying. My ears get hot and sweaty after an hour, so last night I have to take them off. For some reason, noise cancellation is turned back on every time. I start listening session and I can't really find an option and fix that. I guess that's a minor issue, though I am I don't know thing is like you. I definitely feel like a dinosaur charge in the sense of the lightning cable and like just sitting them down like you, turn the headphones to lay flat. They like that and the metal bits bang up against each other or you have to kind of like sit them down askew and we are away it's it's kind of odd feeling, but you know maybe that can be solved with a stand or something like that trouble Is the sound quality is way better and I could appreciate that and stay like a nice set of wired open boxer, maybe 20 % better than us. I'D still rather sacrifice that 20 % for serve wireless headphones, but the entire experience of owning and using these headphones. Just doesn't feel as polished as the AirPods Pro I'm gon na give it a few more days, but I don't think this is going to work out.

I broke my Amazon account by having a separate address that I live in versus one that I received packages at. Let me explain our apartment building uses a service called fetch which receives our packages on our behalf and hand, delivers them toward door. It alleviates the needed for package lockers a mail room or dedicated staff. It works pretty well, but we have to use an alternative dress downtown for packages. They basically get shipped to the fetch warehouse and then re-ship 34 times a day to our apartment building, and then somebody comes through and hand delivers them, usually from a van or something like that anyway, that usually works pretty well. However, what it creates is the need for some of my packages to be delivered to my actual address and some of them to be routed to this fetch address and this broke. My Amazon account. I had to get on customer support for about 45 minutes to get it resolved, but basically Amazon behind the scenes stores a separate default shipping address for each of the services you use fresh prime subscribe and save probably more. I just don't use other ones. However, when you go to the addresses tab, it only gives you the ability to change your default address for Amazon. Prime now it'll show you that your addresses are being used for subscribe and save or fresh, but it won't actually let you change the default. So when is it having to do something kind of funky where we created some duplicate, addresses and Gullum all three on the separate addresses that were all the same address and then edited the addresses to be the ones we wanted to be, which is kind of funny. But I am wind up fixing it after about 45 minutes or so, but for a while, my Amazon fresh on my Amazon account was completely broken and Amazon fresh delivery's were going to the wrong address.

Myocart live home circuit, it's easily one of the most delightful and creative products, creating the last two years. What it is it's a real life, Marioc cart with the camera stuck to it, so it does AR on the Nintendo switch it's a little bit overpriced. I think it MRRP peas about $ 130, something like that. So half the price of the Nintendo console bundled with Marioccart eight, the latest version of Mario kart, but it's such a delightful concept and play around with the flash few days I and I'm getting a super slick Black Friday deal. I got it down to like $ 20 after buying a bunch of Apple gift cards for something else. I was gon na purchase anyway, but it is just polished every last detail. This is polished. It works very well, there really limited shelflife. Are you know it drives around in circles around the kitchen island and their living room? We don't really have enough space to create very many creative circuits, although it's super quick and easy to get started with the light cardboard cut out gates that come included with the game and if you're very realistic like it is, the exact same experience is playing Mario Kart, the video game, it's a lot! It'S it's such a unique and awesome product, even though it's something that you only get to experience a couple times before you come down with it um yeah. This is really interesting to think about. It'S really interesting to think about companies, green lighting products, which will probably not be profitable. I suppose you can do a limited run, but you know this is not a project that you greenlight, because it's going to become a cash cow. That'S like a project. You greenlight, because it's probably the most innovative, interesting thing Nintendo is done as a company since the launch of the switch him. You know they basically replicate the Mario kart experience on 1/25 scale on like a little car, you can race around your house um, it's crazy! You get two players and two switches and you can remote control. Two of these I mean it's just it's a really polished product. It'S the one I think of now, when I think of a delightful user experience or first experience, it just blows my mind that a game company created today, that's it

Should Reddit clone clubhouse? That'S the question: what's a bad question: they are, they will it's gon na ship inside the Reddit Mall app they're, hoping it will increase retention usage of the mobile app and who knows maybe well maybe it won't. Here is the pro argument why they should clone it. It'S a new format. They should get ahead of it, get ahead of it before red user is jump for alternatives, since there are so many alternatives out their own competing platforms. The format works really well with large audiences, most umbrellas have a large audience and you could introduce a new type of interaction. Behavior in those audiences were already organized. Around topic. Theory have a discovery mechanism, there's a ton of value you can get in by launching that app. Now here's the counter argument, there's no real indication that Reddit users actually want to use clubhouse. Here'S why Reddit users are probably the quickest to adopt new contact new forms? A contact, and typically they beat read it by month, three years at addressing those short comings and the Reddit platform, when Reddit users wanted images, they created Imgur, probably five years for Reddit images to come out same with video contact, same of chat, counter and discord. It just the list goes on and on and on - and here is, the big issue is that almost all Reddit contact is asynchronous is consumed in a feed at your own pace and whatever time zone you're in and it doesn't matter whether you login at the same Time as a contact creator or not, however, clubhouse counter is very, very synchronous, or at least the creation aspect involves a community creating's contact synchronously in the same time zone in a way that just doesn't happen on Reddit organically. The other side of the same coin is Reddit. Moderators are incredibly resourceful if they wanted to host clubhouse meet ups for their communities. They already be doing it they've, never taken more than a few weeks to figure out the tools in the process to introducing new Contin typed their community if they're not already adopting another tool. That means there's no organic desire in any sub Reddit for clubhouse, like interaction and really, if you think about the way the clubhouse room operates, really there's only one sub. The operates like that, it's AMA is the same as that is the only sub Reddit, where users create contact in the clubhouse format. Today now granted ANA is on Reddit and Reddit mobile app with clubhouse style content creation. It be in the really fun to play with it's a great idea, but it's really hard to ignore the contrarian viewpoint that Reddit users and Reddit moderators always find their own tools. Very quickly to fill to fulfill their desire to create contact in a specific format, and it really seems like if Reddit users wanted to share contact with other Redditors in the clubhouse format. They would B posting all across popular sub Reddit's, with links to upcoming clubhouse rooms. R upcoming quick tour spaces, and that's just not something you say today -

So Pokémon, brilliant diamond shining pearl, it's pretty well ported, it isn't super buggy. It'S pretty smooth to play. I'D say the biggest problems are that it feels like too faithful of a port from a handheld console to the TV. What is the biggest problems or any Pokémon game? It'S too easy, but realistically this one specifically there was just way too many times. You have to press the confirmation button. It'S it's pretty pretty slow, like the Oregon helmet for this game are pretty poor. I would say over everything else like gym, design is kind of boring stories, boring it's not super exciting of a game, but as far as just like a call you a poor like the biggest thing, that's really probably bugging me is that it's not super smooth. Just going through like menus and dialogue in the battle, there's like it is a AAA AAA, you're spamming, a and B as quickly as you can to try to get through this slow menus and loading screens and battle intros, and all that it's just super time consuming. It feels really like I said it feels really lacking in the economics department.