XL Base 1.0

The database
your Atari never had.

Tables, forms and SQL queries on any Atari XL or XE with 64 KB. Keep your customers, your stock or your game collection, and ask it questions.

Download free

A separate product. XL Base comes on its own disk and works by itself: you do not need XL Office to use it.

See it running for real.

Every frame comes from XL Base running on an Atari 800XL: a table designed, filled in and asked with SQL. Turn the sound on.

Tables

Design it your way.

Name each field, pick its type and size, and mark the ones that cannot be left empty. XL Base checks every value as you type it.

Designing a new table

Four types of field. Text, number, date and yes/no.

Up to 16 fields. And records of up to 255 bytes.

The disk is the database. Each table is a file, listed in the database window.

Your data

Rows, columns and forms.

Work in the datasheet, or switch to a form that shows one record per screen. Find any text, sort by any field and add records in the last row.

The datasheet, with the sample table of Atari games

Find and sort. By text, number or date, in either order.

Opens on your PC. Export CSV for Excel, LibreOffice or Google Sheets.

Ready to print. A clean listing in columns on your printer.

SQL

Ask your data anything.

Write a query and press RETURN. The answer opens as a new table, ready to sort, export or print.

Writing an SQL query
SELECT TITLE, YEAR FROM GAMES WHERE RATING >= 9 ORDER BY YEAR
SELECT GENRE, COUNT(*), AVG(RATING) FROM GAMES GROUP BY GENRE
SELECT * FROM GAMES WHERE PUBLISHER = 'Epyx' AND OWNED = 'Y'

Filters that read well. = <> < > LIKE, with AND, OR and NOT.

Totals by group. COUNT, SUM, AVG, MIN and MAX with GROUP BY.

Remembers your query. The last one comes back next time.

What it takes.

Computer
Any Atari XL or XE with 64 KB: 800XL, 1200XL, 65XE, 130XE, 800XE, XEGS and the 600XL expanded to 64 KB. NTSC or PAL.
Disk
One disk with DOS 2.5, XL Base, the SQL module and two sample tables. About 35 KB stay free for your own tables.
Tables
Up to 16 fields and 255 bytes per record. The open table lives in memory: 7,936 bytes of records, for example 130 records of 60 bytes.
SQL
SELECT, FROM, WHERE (AND, OR, NOT, LIKE), GROUP BY with COUNT, SUM, AVG, MIN and MAX, and ORDER BY.
Languages
English and Spanish, chosen from the Help menu.

Take it home.

One small download: the bootable disk with two sample tables, the manual in English and Spanish, and the license.

XL Base 1.0

588 KB zip file with the disk image, the manual and the keyboard shortcuts

Download free

Freeware. Free to use and to share with anyone, as long as the files go unchanged.

All files
  • XLBase-1.0.zipEverything in one package: the disk, the guide, the license and the manual
    588 KB8337f856af1e75f9d62be2576a9bb2c175c4d1acc80caee8b89f1f3018311211
  • XLBase-1.0.atrThe disk on its own, ready for FujiNet, SDrive or an emulator
    90 KBbf38341c8e2c8bb1e3f874e713c0402db1f91f06c877fe471c27af97b9bdce2d
  • XLBase-Keys-EN.pdfKeyboard shortcuts on one page, for printing
    317 KBd6ae5df6cfbf085cfaa55bc41da54d5117213ef40b084378009fd70c4c27bb20

Check your copy against the SHA-256 sums, also in SHA256SUMS.txt. On a Mac or Linux run shasum -a 256 -c SHA256SUMS.txt.

In Altirra

Set the machine to an 800XL or a 130XE, open Boot Image from the File menu and choose XLBase-1.0.atr.

In atari800

Run atari800 -xl XLBase-1.0.atr. The numeric keypad works as the joystick.

On a real Atari

Copy the disk image to a FujiNet, SIO2PC or SDrive, or write it to a floppy, and switch the computer on.

Questions, answered.

Do I need XL Office?

No. XL Base is a separate product with its own disk. It shares the look and the keys of XL Office, so if you know one you know the other, but each one works on its own.

How big can a table be?

The open table lives in the Atari's memory: 7,936 bytes of records, for example 130 records of 60 bytes. A disk holds as many tables as fit on it.

Can I use my data on a PC?

Yes. Press CTRL and X to export any table, or the result of a query, as a CSV file that opens in Excel, LibreOffice or Google Sheets.

How much SQL does it understand?

The part people use every day: SELECT, WHERE with AND, OR, NOT and LIKE, GROUP BY with COUNT, SUM, AVG, MIN and MAX, and ORDER BY. The manual has examples for the sample tables.

Back to XL Office