Public service announcement: if you're seeing very slow Cloudflare D1 query latencies, you're not alone.I just burned hours trying to figure out why basic D1 SQL queries against a 100MB database are taking 20-30 seconds wall time. Turns out there's an ongoing D1 issue, but it's only being acknowledged in Cloudflare's D1 Discord channel, while cloudflarestatus.com says everything is a-ok.Posting...
After reading Healing Back Pain: The Mind-Body Connection by John E. Sarno ( https://www.goodreads.com/book/show/144873.Healing_Back_Pain ), I recognized that my body was trying distract me from my troubled relationship at that time. On my next painful episode, I mentally said "F*ck it, there is nothing wrong with me physically" and the next day the pain was gone, never to resurface again. The whole thing coincided with my relationship finally ending, so that might have had a positive impact as well.
It still blows my mind though, how much grief my brain gave me over the years.
Unfortunately, I have a similar experience with Firebase, where I wish I would have known that:
* Don't like the text of your Firebase Auth SMS verification message that we send on your behalf -> tough luck
* Your app name is longer than 15 characters? We are not going to include that hash in your Firebase Auth SMS message that is required by Android to perform an automatic login.
* Global Firebase Auth SMS pricing does not work you economically? Welcome to implement the whole thing yourself anyways.
* Dealing with development environments is flakey, as Firebase's emulators work 98% similar to production, but you will regularly hit things that are different.
* You can't completely automate environment creation/tear down, as not everything is covered by Terraform or Google's own APIs, so you will end up doing manual things in their admin interface.
* Real-time subscriptions in Firestore end up not being worth the tight schema coupling between client and server, as you can't control when the updates fire and you end up with a lot more unintended side effects than what this technology benefits you.
So after a year of workarounds you finally end up deeply understanding the trade-offs involved in Firebase and make the decision that its downsides exceed its out of the box benefits. :(
After Epic vs Apple's ruling in the U.S. and EU's recent statement of objections ( https://ec.europa.eu/commission/presscorner/detail/en/ip_23_1217 ), does that mean we can simply use external payment methods for in-app purchases? Has anyone tried submitting an app with alternative payment methods?
Looking for help with converting a small Android app (36 .java files) to Kotlin and add two smaller features.
Interested? -> [email protected]
--8<--
Existing Laravel/MySQL-based dashboard needs a successor. Looking for someone who has experience creating Nova dashboards with role-based access control.
Interested? -> [email protected]
--8<--
Looking for someone who has experience building scheduling/workflow systems to convert existing crontab that simply runs 30 scripts at different times pulling data from external sources (that sometimes fail and need to be retried) and also have dependencies between each other into a more robust & manageable system.
Interested? -> [email protected]
Google is a big bully and if you try to compete with them in an area they care about, they will use their market dominance to keep your product out. They have been deserving that fine for a long time.
IP addresses as Targets You can load balance any application hosted in AWS or on-premises using IP addresses of the application backends as targets. This allows load balancing to an application backend hosted on any IP address and any interface on an instance. You can also use IP addresses as targets to load balance applications hosted in on-premises locations (over a Direct Connect or VPN connection), peered VPCs and EC2-Classic (using ClassicLink). The ability to load balance across AWS and on-prem resources helps you migrate-to-cloud, burst-to-cloud or failover-to-cloud.
Looks like you need an active VPN connection to access external IPs.
- Route 53 failover record * primary record: Google global load balancer IP * secondary record: Route 53 Geolocation set (really need that latency) - Elastic Load balancer record per region * routes to mirror region GCP IP address (ELB's application load balancer seems to able to point to AWS external IPs) * optionally spin up mirror infrastructure in AWS
Seems brittle. Does Azure support global load balancing with external IPs?
Does anyone have such (or similar) setup actually in production? How did it work today?
What is going to be faster? Updating DNS records with TTL 3600 to point to a single data center or Google fixing their problem.
We host DNS at AWS, but servers in GCP. Should we use AWS's automatic DNS failover feature to cover for such a case?
Given that we are surrounded by an incredible amount of high-calorie food (100g of a Snicker's bar provide 488 calories), it is easy to forget how difficult it is to source calories in the wild.
Can somebody please explain to me why this can't be mitigated against? Is it because they offer DNS as a free add-on and can't be bothered to spend the bucks to make their service more DDOS-proof?
- After EC2 East was slow like molasses, I switched over to EC2 EU which was still speedy
- That caused their CLI tool to fall on its nose when trying to tunnel to the database (right now the bridge always gets installed in EC2 East). Fixed with a simple patch in the Ruby source
- Looks like the backend connector in nginx won't connect to your app if you have Basic-Auth on your root index
- Later MySQL became unavailable with "Host '10.0.47.186' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'". No connection limiter between different apps?
I think AppFog is offering a great value should they be able to iron out all the kinks. I'm crossing my fingers that this will happen quickly.
Interesting new Apple television play speculation: commit to a 2 year cable subscription, get a new Apple TV set at a subsidized price (instead of Set-top box).
e.g. Adele is on tour right now, but DDG won't return a SeatGeek listing for it
Is GitHub a great product because the founders optimized for happiness or where they only able to optimize for happiness because they had a home-run product on their hands?
After a few hours of cobbling together a decent config, I found http://bitbucket.org/Josh/oh-my-zsh/src/ to be a way better starting point. All the defaults make a bash user feel right at home (keyboard shortcuts etc), plus it organizes all the bazillion zsh options in a sane configuration layout.
So we will finally be moving into a dedicated office next week, so the question arose what PBX system to use.In a previous startup we used a traditional one from Nortel, with expensive everything and multiple lines from PacBell. Pros: reliable Cons: expensive everything.What about hosted PBXs via VOIP? Speakeasy offers solutions for $19-29 per employee. Are those any good?
What if you have exhausted your network (which admittedly wasn't that large)? How do keep those referrals coming?
Personally, if I'm absolutely stuck at how to approach a coding problem, I simply start coding the dumbest solution for it, violating every rule in the book just to move forward. Usually that is enough to get the ball rolling and with today's tools, refactoring the code afterwards does not take very long at all.
How can you get people excited without disclosing the whole thing that you are trying to build?
What I really need is a job advert copy writer to sprinkle some magic pixie dust on the thing that will cause talented people to send in their applications...
Bonus link: http://joblighted.com/statistics lists all job boards worth posting to.
2.) If you must do it yourself, Heritrix is the most sophisticated crawler out there (crawler.archive.org).
3.) Nutch is an option, but nowhere near as powerful as Heritrix.
Don't try to reinvent the wheel, writing a robust crawler is a lot of work as there are endless edge cases to take care of (if you are looking into a general purpose web crawler)