4LightData Base
4LightData Base 4.20131031
Your rating: Now say why...

(3) 3.1666666666666665

Utility database with integrated office suite (beta).   Free
Add to my Watch List
Email me when discounted
4LightData Base is a utility database with integrated word processor, spreadsheet, and drawing. The program can handle large amounts of data using the 4D database engine. It gives access to the engine's Import, Export, Quick Report, Graph, Query, and Formula editors which allow manipulation and reporting of the records.

A very good introduction to the editors can be found in the 4D QuickStart Guide. Additionally, word processor, SVG drawing, and spreadsheet features have been added to the database. It is now possible to merge form letters, drawings, and spreadsheets with the
What's New
Version 4.20131031:
  • Draw: Improved Undo, scaling and automatic sizing.
Requirements
Intel, OS X 10.6.8 or later



MacUpdate - 4LightData Base



4LightData Base User Discussion (Write a Review)
ver. 4.x:
(3)
Your rating: Now say why...
Overall:
(3)

sort: smiles | time
burypromote
+2

+46
Sampler commented on 08 Mar 2013
The problems I reported with the previous version are gone. One minor annoyance is that one must push a button to do just about everything. There's no keyboard shortcut, for example, to add or delete a record. But this is minor. But I look forward to the evolution of this program. I had a lot of experience with 4D in the past, and I appreciate the effort that is going into this app. Somewhat strangely, one of the -help- links take one right to 4D documentation of doubtful relevance (the "CVG" pages.
[Version 4.20130307]


burypromote

+46
Sampler commented on 29 Dec 2012
It's "beta", but as someone else stated, really "alpha". Simple things don't work. I tried to create a table. Wrote down fields in order, but each new one went to the top of the list and re-order appears impossible. Saving the table with 3 simple fields failed for no good reason that I could see. For a free Mac relational database program with form entry, the Base program in one of the *-Office suites is the only real choice.
[Version 4.20121228]

1 Reply

burypromote
Computer Dimensions, Inc. (developer) replied on 01 Jan 2013
New fields now appear at the end of the list and a field's type is chosen from a pop-up when the Type column is clicked. If the table creation failed with an error message, it would be great to have that information.

The entry form style is new and was created to handle the picture type. The previous style only handled text. This required the ability to resize and move the form objects. Nudging and resizing fields with the keyboard and alignment still need to be implemented. Printing the form is not currently an option, but can be accomplished by merging one or more records with the word processor or draw module. 4D has a nice label editor that could be really useful, but it's unavailable to this program at present.
burypromote

+216

Jimw reviewed on 15 Dec 2012
This looks like the start of something that could be useful. Right now it seems to have limited functionality and the documentation is weak. Right now this does not seem to be a product that will be useful to the typical user, as it requires knowledge and experience with other databases to figure out how to use it. While not immediately obvious, it is a relational db, something I did not discover until the very end of my 15 minutes of playing with it. While there is a help menu it takes you to a website that only seems to have a vague relationship to this product which it sort of treats as a front end to a full 4d database. For those unfamiliar with 4d, 4d is a high end, really expensive, complicated database for the Mac. It is the same class as Oracle. Previous comments are somewhat correct. An example is that switching out of Design Mode quits the program. While this product has promise, right now it does not seem ready for prime time. However it is a development in progress, given its beta status, which could actually be considered to be alpha by many.
[Version 4.20121212]


burypromote

+139
Ean commented on 11 Dec 2012
Super clunky and super buggy.
[Version 4.20121206]


burypromote

+216
Jimw commented on 09 Dec 2012
I am sort of confused here. Does this require a 4D database, a quite expensive app? Is only the beta free? If so what does the stable version cost? Why doesn't the link to the developer work so that I can find out more information?
[Version 4.20121129]

4 Replies

burypromote
KeithCulotta replied on 10 Dec 2012
Hope this helps, 4LightData Base is a stand alone app. The first thing it will ask you to do is to create a datafile on your disk. It's primary focus is creating and reporting on tables within the datafile. A table is created using the Utilities button. After that, data can be entered either a record at at time or by importing text files.

When started from the buttons in a table's list form (Work with a Table), drawing, word processing (Write) and spreadsheet (View) modules can merge with a selection of records. Write and View are 4D plugins. The drawing module is fairly limited, but was written around satisfying the specific needs of a customer who had been depending on 4D's now extinct Draw plugin.

Notes:
"Picture" is a valid field type, but there is not a way to access pictures in the user interface at this point.
Data can be exported in several standard formats. It can also be exported in a 4D format that allows the data to be imported into a programmable 4D structure.

Looking into the link to the developer problem...
burypromote

+216
Jimw replied on 10 Dec 2012
Thank you for the information. It should help MacUpdate users understand its specifications quite a bit better. The only critical information missing is if the app will remain free after beta and if not, what will it cost.
burypromote
KeithCulotta replied on 10 Dec 2012
The app will remain free. That's not to say it won't get a "Donation" button one day.
burypromote

+216
Jimw replied on 10 Dec 2012
Thank you for this information. One of the long term weaknesses of the Mac has been the lack of an individual, affordable, general purpose relational database, that was not too constrictive, yet did not require the user to be a programmer. The closest one I know of was Bento, but it has always been too constrictive. Windows had Access, abet not very friendly, but affordable with a GUI interface that did not require a programming degree to use. Filemaker and 4D are just too expensive for the occasional individual user. That left SQL products that again required programming knowledge to use. Hopefully your product, when complete, will fill this gap.
There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


nickeb rated on 16 Feb 2014

[Version 4.20131031]



Guardsix rated on 25 Jun 2013

[Version 4.20130624]



Guardsix rated on 21 Jun 2013

[Version 4.20130621]


Downloads:6,778
Version Downloads:151
Type:Productivity
License:Free
Date:31 Oct 2013
Platform:Intel 32 / OS X
Price:Free0.00
Overall (Version 4.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-5 of 5
Displaying 1-3 of 3
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
4LightData Base is a utility database with integrated word processor, spreadsheet, and drawing. The program can handle large amounts of data using the 4D database engine. It gives access to the engine's Import, Export, Quick Report, Graph, Query, and Formula editors which allow manipulation and reporting of the records.

A very good introduction to the editors can be found in the 4D QuickStart Guide. Additionally, word processor, SVG drawing, and spreadsheet features have been added to the database. It is now possible to merge form letters, drawings, and spreadsheets with the database records.

If you're creating forms with 4LightData Base, you may want to look at 4LightStarter, which allows forms to be created for 4LightData Base tables and activates the 4LDB Label Editor.


- -