Adding indexes to current columns in SQLite works fine: https://
sqlite.org/lang_createind
ex.html
…
SOFTWARE
-
SQLite Index Optimization for Database Performance
By
–
-
SQLite Views Triggers Distributed Cluster Architecture Limitations
By
–
SQLite has good support for views and triggers Distributed cluster is a whole lot harder though, it's meant to be used as a linked library on a single machine
-
Government Website Design Best Practices Digital Transformation
By
–
Thanks to Palantiri Megan Hack, Lily Berman, and Hadassah Damien! https://
palantir.net/blog/governmen
t-website-design-best-practices
… #digitaltransformation #govtech #drupal4gov -
Government Website Transformation Guide: Quality, Security, UX
By
–
We’ve compiled our decades of experience in transforming government websites into this freshly published guide! Learn how to improve quality, security, and user experience:
-
The Future of Digital Health: AI, Robotics, and Emerging Technologies
By
–
The Future of #Digital health
by @healthinovatio1 #ArtificialIntelligence #Healthcare #HealthTech #Technology #Innovation #AI #Robotics #AR #VR #Wearable cc: @pascal_bornet @yvesmulkers @kuriharan -
Building Custom AI Frameworks and Model Switching in Cursor
By
–
No, I built my own framework! But you could do this in Cursor quite easily since you can switch models mid-conversation.
-
Ruff Python Linter: Simplicity and Performance Benefits
By
–
I really like Ruff these days for both simplicity and performance, looks like it has a rule for this https://
docs.astral.sh/ruff/rules/mut
able-argument-default/
… -
Python Default Argument Trap: Correct Implementation Patterns
By
–
Yeah, it's a nasty trap that one. I think there are linters that can spot it these days. The correct pattern looks like this: def my_function(a, b=None): b = b or [] … Or this if you want to support false-y values being passed for b: b = [] if b is None else b
-
Vercel Uses AI Honeypots to Fight Bots and Reduce Costs
By
–
In response to bot traffic and scrapers, we (@vercel) have been using our AI apps, examples, and starter kits as security honeypots to develop new anti-bot + fingerprinting + rate limiting techniques. In tandem with our WAF product, we've since cut our daily OpenAI bill by 100x x.com/elonmusk/statu…
-
OpenAI removes login requirement for GPT 3.5 in some markets
By
–
No login required to use https://t.co/9K5QiU4tjM with GPT 3.5 now (in some markets)
— Simon Willison (@simonw) 1 avril 2024
I wonder how their scraping prevention works? I imagine the temptation for people to abuse this as a free 3.5 API will be pretty strong https://t.co/OKiRaUxHc3No login required to use https://
chat.openai.com with GPT 3.5 now (in some markets) I wonder how their scraping prevention works? I imagine the temptation for people to abuse this as a free 3.5 API will be pretty strong