I used clout back in the eighties, coupled with 2.11 from memory. Once clout understood the schema of your data base you could type in a basic sentence and it would respond with your requested data. Simple but very clever at the time. So AI not really because imagination is the key. That's the tool we have to expand the mind and thinking. Not limited to existing information at hand and predictable outcomes. To me AI is lazy thinkers. Anyway I am still here and working on some unique stuff in my retirement. All the best thinkers
On Thu, 3 Apr 2025, 5:55鈥痯m , <[email protected]> wrote: > R:Base had a primitive AI application in the late 80s (?) called Clout. I > guess there was not much interest on it since its development stopped. > > It did basic things but nothing that you could not easily do from the R> > prompt using simple language. Perhaps it was aimed at non-tech users , but > non-tech users did not use databases much back then. > > In many ways, R:Base was ahead of its time. 馃槉 > > > > Javier, > > > > Javier Valencia, PE > > 14315 S Twilight Ln > <https://www.google.com/maps/search/14315+S+Twilight+Ln+Olathe,+KS+66062?entry=gmail&source=g> > > Olathe, KS 66062 > <https://www.google.com/maps/search/14315+S+Twilight+Ln+Olathe,+KS+66062?entry=gmail&source=g> > > 913-915-3137 > > > > > > > > *From:* [email protected] <[email protected]> *On Behalf Of > *rdiaz kcnyenterprises.com > *Sent:* Tuesday, April 1, 2025 11:24 AM > *To:* RBASE-L <[email protected]> > *Subject:* [RBASE-L] - Re: Grok 3 AI generated R:Base code from a simple > prompt: Can you write code for R:Base version 11 database? > > > > I need to start to learn about this. Would love to be able to make an Ad > Hoc Query for a client to be able to ask AI questions about his data. At > first it would only be for owners and users that can have access to all the > data. Eventually train the AI to have different levels for different users. > > > > Maybe its a product for Rbase to create, an AI Plug-in for USERS of the > databases we create as developers. > > > ------------------------------ > > *From:* [email protected] <[email protected]> on behalf of > Peter Ryan <[email protected]> > *Sent:* Tuesday, April 1, 2025 9:56 AM > *To:* RBASE-L <[email protected]> > *Subject:* [RBASE-L] - Re: Grok 3 AI generated R:Base code from a simple > prompt: Can you write code for R:Base version 11 database? > > > > For fun , wrote and started training a R-GPT for private use with Open AI > AIPRM prompt. When asked "to improve" the code I am impressed with the > > results and the added documentation COMMENTS to add to the snip of code. > > > > Training to specify RBase and ignore R or other code options can narrow or > refine the results. > > > > Dreaming more about RBase:AI solutions someday ... > > > > > > > ------------------------------ > > *From:* [email protected] on behalf of randyp ctags.com > *Sent:* Tuesday, April 1, 2025 9:25 AM > *To:* RBASE-L > *Subject:* [RBASE-L] - Grok 3 AI generated R:Base code from a simple > prompt: Can you write code for R:Base version 11 database? > > > > Grok 3. > > Can you write code for R:Base version 11 database? > > Yes, I can help you write code for R:BASE Version 11, a relational database > > management system (RDBMS) that uses its own command syntax for managing > > and querying databases. R:BASE has a unique programming environment with > > commands like CREATE, INSERT, SELECT, and RUN, often executed via its > > command-line interface or stored in script files (e.g., .RMD files). > > Below, I鈥檒l provide an example of R:BASE code tailored to a simple use case, > > followed by explanations. Since you haven鈥檛 specified a particular task, > > I鈥檒l assume you鈥檇 like a basic example鈥攕uch as creating a table for tracking > Holy > > week events (tying into your earlier question), inserting data, and querying > it. > > If you have a specific requirement, feel free to clarify! > > Example R:BASE Code > > This code creates a table for Holy Week events, inserts data based on John P. > Pratt鈥檚 33 AD timeline, and retrieves it. > > [A previous question I asked, but did not specify for Grok's example. > > What are the dates and days of events during Holy Week according to John > Pratt? ] > > rbase > > /* Clear the screen and set up environment */ > > CLS > > SET ECHO ON > > /* Create a database if it doesn鈥檛 exist */ > > CREATE DATABASE HolyWeekDB > > /* Connect to the database */ > > CONNECT HolyWeekDB > > /* Create a table for Holy Week events */ > > CREATE TABLE HolyWeekEvents ( > > EventID INTEGER PRIMARY KEY, > > EventName VARCHAR(50), > > EventDate DATE, EventDay VARCHAR(20), > > Description VARCHAR(255) ) > > /* Insert data for Holy Week 33 AD per John Pratt */ > > INSERT INTO HolyWeekEvents VALUES ( > > 1, > > 'Triumphal Entry', > > '03/27/0033', > > 'Sunday', > > 'Jesus enters Jerusalem on a donkey, greeted with palms.' > > ) > > > > INSERT INTO HolyWeekEvents VALUES ( > > 2, > > 'Cleansing of Temple', > > '03/28/0033', > > 'Monday', > > 'Jesus overturns tables in the Temple.' > > ) > > INSERT INTO HolyWeekEvents VALUES ( > > 3, > > 'Last Supper', > > '03/31/0033', > > 'Thursday', > > 'Jesus shares Passover meal and institutes Eucharist.' > > ) > > INSERT INTO HolyWeekEvents VALUES ( > > 4, > > 'Crucifixion', > > '04/01/0033', > > 'Friday', > > 'Jesus is crucified and dies at 3 PM.' > > ) > > INSERT INTO HolyWeekEvents VALUES ( > > 5, > > 'Resurrection', > > '04/03/0033', > > 'Sunday', > > 'Jesus rises from the dead early morning.' > > ) > > /* Query the table to display all events */ > > SELECT EventName, EventDate, EventDay, Description > > FROM HolyWeekEvents > > ORDER BY EventDate > > /* Save the output to a file */ > > OUTPUT HolyWeekReport.txt > > LIST ALL > > OUTPUT SCREEN > > /* Disconnect and clean up */ > > DISCONNECT > > SET ECHO OFF > > [NOTE: I would put this in the R:Base Editor and check it. But it seems > quite > > complete for a simple request, and 3 minute wait. Lists need a "+" after > each comma." > > Explanation of the Code > > 1. Environment Setup: > > o CLS: Clears the screen for a clean display. > > o SET ECHO ON: Shows commands as they execute (useful for debugging). > > 2. Database Management: > > o CREATE DATABASE HolyWeekDB: Creates a new database. If it already exists, > you鈥檇 use CONNECT directly. > > o CONNECT HolyWeekDB: Opens the database for operations. > > 3. Table Creation: > > o CREATE TABLE HolyWeekEvents: Defines a table with columns: > > 搂 EventID (INTEGER PRIMARY KEY): Unique identifier. > > 搂 EventName (VARCHAR(50)): Name of the event. > > 搂 EventDate (DATE): Date in MM/DD/YYYY format. > > 搂 EventDay (VARCHAR(20)): Day of the week. > > 搂 Description (VARCHAR(255)): Brief description. > > 4. Data Insertion: > > o INSERT INTO HolyWeekEvents VALUES: Adds rows with Pratt鈥檚 33 AD dates. > Note that R:BASE expects dates as strings in MM/DD/YYYY format (e.g., > '03/27/0033'). > > 5. Querying: > > o SELECT ... FROM HolyWeekEvents: Retrieves and sorts events by date. > R:BASE鈥檚 SQL-like syntax is straightforward here. > > 6. Output: > > o OUTPUT HolyWeekReport.txt: Redirects query results to a text file. > > o LIST ALL: Displays all table contents (an alternative to SELECT *). > > o OUTPUT SCREEN: Returns output to the screen. > > 7. Cleanup: > > o DISCONNECT: Closes the database connection. > > o SET ECHO OFF: Stops echoing commands. > > Running the Code > > 路 Interactive Mode: Type this into the R:BASE 11 command prompt line > by line. > > 路 Script File: Save it as HolyWeek.rbd (or similar), then run it with: > > RUN HolyWeek.rbd > > from the R:BASE prompt. > > Notes for R:BASE 11 > > 路 Version Compatibility: This syntax aligns with R:BASE 11鈥檚 > capabilities (released circa 2019), which supports enhanced SQL features and > GUI tools, but the example uses classic command-line style for simplicity. > > 路 Date Handling: R:BASE stores dates internally but accepts them as > MM/DD/YYYY strings in commands. > > 路 Error Handling: Add IF ERROR THEN ... blocks for robustness in > production code (e.g., IF ERROR THEN PRINT 'Table creation failed'). > > If you need a more complex example鈥攍ike joins, stored procedures (DEFINE > PROCEDURE), or integration with forms鈥攍et me know what you鈥檙e aiming for! > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51122C660E0BC53E2A38C129C7AC2%40PH0PR11MB5112.namprd11.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51122C660E0BC53E2A38C129C7AC2%40PH0PR11MB5112.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/rbase-l/SJ2PR17MB713831CEEAC8DB603B29C057C9AC2%40SJ2PR17MB7138.namprd17.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/SJ2PR17MB713831CEEAC8DB603B29C057C9AC2%40SJ2PR17MB7138.namprd17.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51820FB5232D1143401D4C45A8AC2%40SA1PR19MB5182.namprd19.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51820FB5232D1143401D4C45A8AC2%40SA1PR19MB5182.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/rbase-l/000001dba46d%24bc08de90%24341a9bb0%24%40vtgonline.com > <https://groups.google.com/d/msgid/rbase-l/000001dba46d%24bc08de90%24341a9bb0%24%40vtgonline.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/CABnhDASsax7_eGHnDVGjgfJyHxW9rNYuF0C-bvHXhDv8gFtAWQ%40mail.gmail.com.
