Databases, AI, & You

  Databases and Artificial Intelligence are a good pairing.  AI can take the sharp, rusty edges off the database skills many have and be a force multiplier for getting the data you want. What follows is a quick intro.  We will be using SQLite, DBeaver Community Edition , and some simple prompts.  The DBeaver Community Edition includes SQLite, so you get both with a single download. There will be a later blog post on setting up AI with DBeaver CE, but for now refer to  AI Preferences .  Step 1 - Open DBeaver and create a New Database Connection Step 2 -Use the wizard and select SQLite Step 3 -- Select 'Create' Step 4 - Enter a name for your new database in the 'File name' box. I chose 'davedemo'. Step 5 -  Select 'Finish' to create your new SQLite database. Step 6 - DBeaver has now created the database Step 7 - Open an SQL Console, and ask AI to create a table for you by prefacing your request with @ai. Here we want a table named 'demo01' with t...