Base by ZawebaTables, forms and reports, then a website.
Build a database with forms and reports, then turn it into a website. Design tables, forms, queries and reports in a visual database builder, then export the lot as a working PHP and MySQL website.
This version isn't signed for Windows yet: if SmartScreen warns you, choose More info › Run anyway. Why?
Base by Zaweba is a visual database builder. Design tables, link them with lookups, type or import your records, then build queries, forms with sub-forms and grouped reports. Put a little logic behind a button with a simple action or a short script. Start from one of five templates or a blank file.
When it is ready, Base exports the whole database as a PHP 8.2 and MySQL website with logins, so others can use it in a browser. Every table gets list, view, add, edit and delete pages that follow the forms you designed. On your PC, each database is a single file.
Who it's for
- Small businesses tracking customers, stock and invoices
- Clubs and charities keeping membership records
- Anyone who wants a web database without writing PHP
- People who liked desktop databases and want one again
Good to know
- The exported website needs PHP 8.2 and MySQL or MariaDB, on a web host or in Server by Zaweba on your PC
- Exported sites have one kind of user: everyone who logs in can change everything
- Buttons and scripts stay in the desktop app; the website gets standard pages instead
Private by design
- Works offline, with no account and no adverts.
- Checks zaweba.com once a day for a newer version, sending only the app's name.
- Problem reports and feedback are sent only if you click Send.
Everything you need, nothing you don't.
Table designer
Text, numbers, currency, dates, yes/no, lookups, pictures and file attachments, with required, unique and default options.
Datasheet and import
Spreadsheet-style editing with sort, search and filter. Import CSV, .xlsx or .xls files, and export any table or query to CSV.
Visual query builder
Pick tables, add fields, totals, sorts and conditions. The SQL tab shows the query, and you can write your own.
Forms with sub-forms
Drag fields onto a form, or make one automatically. Invoice lines sit under their invoice, with a total.
Grouped reports
Group, subtotal and total any table or query, then print it or save it as a PDF.
Logic behind buttons
Buttons open forms, run queries or print reports, or run sandboxed JavaScript that can read and change records.
From desktop to website
File > Export to website writes a ready-to-upload PHP 8.2 site and the SQL to create your tables in MySQL or MariaDB. Lists are searchable, sortable and paged, lookups become dropdowns and sub-forms become child lists. Logins and protection against common attacks are built in, and a README walks you through installing it.
- List, view, add, edit and delete pages for every table
- Logins with a limit on failed attempts
- Open in Server by Zaweba or upload with FTP by Zaweba
Start from a template
Five templates give you a working database in four steps: Contacts, Inventory, Invoices and Customers, a Book and Collection catalogue, and a Simple CRM. Each comes with tables, relationships, forms, queries and reports, plus optional example records so you can try things out straight away.
- Five ready-made databases
- Example records if you want them
- Opens on its main form
Forms that feel familiar
Design forms by dragging fields from the list: the label and the right control arrive together. Form view shows one record at a time with record navigation, and moving to another record saves the one you were on. Sub-forms list and edit the related records, such as the lines of an invoice.
- Drag-and-drop form designer
- Auto form in one click
- Record navigation and sub-forms
The details
| Works on | Windows 10 and 11 (64-bit) |
|---|---|
| Files | .obase, one SQLite database per file |
| Imports | CSV, .xlsx and .xls |
| Exports | CSV, PDF reports, and a PHP 8.2 and MySQL website |
| Scripting | Sandboxed JavaScript behind buttons |
| Conventions | UK dates (dd/mm/yyyy) and pounds |
| Version | Version 1.2.2 |
| Download | ZawebaBase-1.2.2.zip (68 MB): unzip and run, no installer |
| Licence | Free for everyone, with every feature included. No warranty |
Base FAQ
Do I need to know SQL?
No. The visual query builder writes the SQL for you, and the SQL tab shows it if you are curious. You can also write your own.
What does the exported website need?
A web host with PHP 8.2 and MySQL or MariaDB. Import the SQL, fill in the database details, upload the site folder and run setup to create the first login. To try it on your own PC, use Server by Zaweba.
Are button scripts safe?
Yes. Scripts run in a sandbox with no access to files, the network or other programs, a 5-second time limit, and they can only add, change and delete records in your own tables.
Related apps
Server
Apache, MariaDB and PHP 5.6 to 8.3 side by side, with a friendly control panel, a new-site wizard, local HTTPS and one-click databases.
Explore Server
FTP
FTP, FTPS and SFTP with a proper code editor, a live preview, sync with a preview, Save for Web and a server-side trash.
Explore FTP
Write
A simple, offline word processor with real pages, styles, tables and spell check. It saves .docx, so your files open anywhere.
Explore Write
Publish
Lay out flyers, newsletters, posters, menus and cards with linked text and wrapping pictures, then export print-ready PDFs.
Explore Publish
Try Base today.
Download Base by Zaweba: no account, no adverts, every feature included.