Applied Gen AI for Analytics, Data Science & Business

Two models added to Database AI Suite this week: GPT-5.1 and KIMI 2 Thinking. KIMI 2 Thinking is close to Gemini 2.5 Flash in quality. Costs are higher and more volatile. GPT-5.1 is 20% cheaper than GPT-5 for database execution. Token bloat is down. Default reasoning set to none instead of medium. For advanced analysis planning (single API call, reasoning step): → Gemini 2.5 Flash: strong quality, predictable costs → KIMI 2: similar quality, cost are higher and more volatile

Bundle your AI app or React dashboard into a single file. No AWS. No Vercel. No IT approvals. The entire app - all code, visualizations, database engine - in one file. Download it. Email it. Share it on a drive. Double-click to open. It works. Practical applications - Build and share AI & automation apps in small teams. - Send a prospect a working prototype instead of PowerPoint. They load their data, click around, experience it. - Quarterly dashboards for leadership withou

Three perspectives. All pointing to the same shift. An investor, a strategist, and a hands-on analyst. Vibing? Get this straight - there is no vibe magic going on here. Prompt hot air into a chat box and out pops a production level model / app - doesn't work that way. The Investor's View Francois Arbour (founder, sold to Shutterstock): The 10x lie. Developers are building solutions in search of problems. Now doing it 10x faster. The real multiplier isn't in your IDE. It's u

A month ago, I posted that Google was back in the AI race. Earlier in the year, I wrote about the shift in their LLM quality. Sanya Ojha's analysis this week confirms it from the strategy side. I'm seeing it from the execution side. Google is shipping at a rate I haven't seen in years. Around 20% of my workflow now runs on Gemini. In January 2025, that was 0%. Here's what I am using for my client projects ▸ gemini-2.5-flash-lite - my workhorse. first choice for automations. F

You're building an AI app. A user hits 'create'. Your app needs to spin up a database. How long do they wait? Regular cloud databases take 3-5 minutes or longer to setup, need manual configuration, charge 24/7 even when idle. Doesn't work when you need databases created on-demand, within an API call. I use neon.com for this. Neon setups up a full Postgres instance in under 1 second via API. Not a sandbox. A real database with connection string, credentials, everything. I u

Coding by hand is a business liability. AI Coders give you the edge. The 6 Rules I Follow When Working with AI Coders. This post builds on my earlier one - 'Coding by hand is obsolete' Post | LinkedIn Over two decades coding by hand in SAS, Python, SQL, VBA - across enterprises and SMBs - and the last two with AI, I’ve reached one conclusion: 𝗖𝗼𝗱𝗶𝗻𝗴 𝗯𝘆 𝗵𝗮𝗻𝗱 𝘁𝗼𝗱𝗮𝘆 𝗶𝘀 𝗮 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗹𝗶𝗮𝗯𝗶𝗹𝗶𝘁𝘆. It’s slower, costlier, and less scalable. The P&L

It already is. Andrew is just being polite. (Post link below) After 25 years of writing code line by line, I now execute everything with AI Coders. Claude Code, Cursor, and Gemini CLI are my day-to-day tools. AI does the coding, but I still review, explain, and learn from it. The buck stops with me. ▪ The speed of execution is huge. But's that's just one part of it. It’s about what can now be done. My pre-AI world was limited to SAS, Python, Excel, SQL and ML models. Projects

Tell it what to extract - fields, filters, rules - all in plain English. Live Tool. Paste a URL list. The app extracts the fields you asked for, applies your transforms, filters and any data cleaning instructions. And updates structured data in Excel, URL status, error logs, and a 30-KPI scraping dashboard. ▪ What Intelligence does You can share instructions in conversational English. Filter: 'Don't include any records from Mumbai, Chennai and Delhi' Select: 'If there are mul

Download PDF Report here Database AI, built for day-to-day work. Five categories, ten micro apps. Live, open source, free. ▪ What they do - Chat with Postgres, MySQL, and DuckDB in natural language - Convert plain English to SQL and run it - Analyze data, create and transform tables - Visualize with charts - Connect on the fly or use pre-configured connections ▪ 5 Categories of Database AI apps Custom builds, Rapid Deploy, ChatGPT, Realtime Voice & xlwings Lite ▪ What ar

Few days back I shared a custom implementation powered by SQL Rooms (sqlrooms.org) to chat, query multi-GB files in conversational language. With DuckDB database running right in browser. Live here app.tigzig.com/sql-rooms Now, you can download the full thing - one HTML file that works right off your laptop. The entire React application is now compiled into a single, portable 3.5MB HTML file. Double-click it, and you’re running a full AI app. No installs. No backend. No ser

Analyzed a 1.6 GB, 11-million-row CSV file on a custom build of SQL Rooms + DuckDB. The entire analysis- querying and charts ran 100% in the local browser. No backend. No remote DB. And fast. Built on the open-source SQL Rooms (sqlrooms.org) framework from Foursquare, customized for my analytics workflows 📌 What you can do ▸ Process hundreds of MBs, millions of rows - fully local ▸ Merge, append, transform, analyze, and visualize with AI ▸ Chat with your data in natural la

Professionally formatted PDF & HTML reports with AI analysis, charts and tables. The xlwings Lite app generates AI-based technical...