Staff software engineer at Jack Henry, former submariner.
California
Joined May 2014
- Tweets1.2K
- Following2.5K
- Followers6K
- Likes7.4K
James Moore retweeted
Come join David Gleason and our CEO Michael Tanenbaum (@tbaums) for a @CloudNativeFdn webinar TOMORROW 10/31 12pm-1pm Eastern on #LLMs in the #Enterprise. No spoilers, but you will get to see a live demo of an LLM solving real business problems! community.cncf.io/e/mmxtc4/
James Moore retweeted
Find out how to use Roboflow, YOLOv8, and Google Colab to identify objects in real-time.
At Mycelial, we’re building the platform for data movement at the edge. If you’re working on data and AI at the edge, we’re here to advance your mission.
youtube.com/watch?v=lCYGwMkM…
James Moore retweeted
#SQLite's query planner uses statistics to decide how to satisfy SQL queries in a cost-effective way.
Are you properly updating your statistics?
Check out this video to learn more.
mycelial.com/blog/sqlite-sta…
James Moore retweeted
#SQLite doesn't have date and time datatypes, which begs the question, how do you deal with your date and time values?
mycelial.com/blog/dates-in-s…
James Moore retweeted
If you use #SQL and you aren't familiar with window functions, you should check out this video.
mycelial.com/blog/sql-window…
James Moore retweeted
Issue #15 of SQLite News is out
sqlitenews.net/issues/15
@drichardhipp @mycelial @kentcdodds @LogRocket @PreetamJinka
James Moore retweeted
#SQLite doesn't have as many features as the other popular databases but don't let that scare you away from using SQLite, because even though there aren't as many built-in features, there are excellent ways of extending SQLite.
mycelial.com/blog/sqlite-ext…
James Moore retweeted
Issue #13 of SQLite News is out
sqlitenews.net/issues/13
@mycelial @general_order24 @agarcia_me @markusrgw @simonw
James Moore retweeted
If you want to level up your #SQLite skills, the area you should probably focus on first is Indexes.
So, are you familiar with the various types of indexes you can create?
Check out this video to learn more.
mycelial.com/blog/sqlite-ind…
James Moore retweeted
#SQLite doesn't automatically free up disk space as it becomes available.
So how do you free up unused space in SQLite?
Watch this video to learn more.
mycelial.com/blog/sqlite-vac…
James Moore retweeted
Issue #11 of SQLite News is out
sqlitenews.net/issues/10
@mycelial @codewithanthony @davidmezzetti @directus
James Moore retweeted
#SQLite has an extension called FTS5, which provides full text search capabilities to your SQLite database.
So, how do you use the full text search features in SQLite?
Watch this short video to learn more.
mycelial.com/blog/sqlite-ful…
James Moore retweeted
i’m in a code review with elon musk. ive got the CSS for neopets.com on 3 monitors. my browser’s in dark mode so it looks cool. “this part?” he asks, pointing to code for the Giant Omelette. “caches tweets in the mainframe cyberhex,” i say. he nods. “as i suspected”
James Moore retweeted
Issue #10 of SQLite News is out
sqlitenews.net/issues/10
@drichardhipp @ploomber @mycelial @tantaman @amjithr
James Moore retweeted
Did you know that #SQLite offers profiling tools to help you identify the cause of slow queries? There's even a tool that suggests indexes you should add to improve a query's performance.
Checkout this video to learn more.
mycelial.com/blog/sqlite-fix…
James Moore retweeted
Datatypes in #SQLite are handled differently than pretty much every other popular relational database.
How is it different?
Watch this short video to learn more.
mycelial.com/blog/sqlite-dat…
James Moore retweeted
Are you familiar with #SQLite's journal_mode options?
journal_mode is one of the most important configuration settings, and if you don't know how it works, you should check out this video.
mycelial.com/blog/sqlite-jou…
James Moore retweeted
Local-first software and CRDTs feature prominently in the latest @thoughtworks Technology Radar 📡 thoughtworks.com/content/dam…