BeAccessible Download

Description:

About BeAccessible:

BeAccessible is an MS Access-like front end to the SQLite database.

Notes:

It would be best if you use the same version of SQLite that's provided in the download file. You may encounter problems if you're using a different version.

"SQLite is 'typeless'. This means that you can store any kind of data you want in any column of any table, regardless of the declared datatype of that column." The one exception is an AutoNumber field, which must be an integer. See http://www.sqlite.org/datatypes.html for more information.

Until I implement cursor-like behavior, you'll probably want to avoid using this program on large tables. Currently, the entire table is loaded into memory. So for large tables, BeAccessible will chug away until you run out of memory or patience, whichever comes first. (The current version provides decent performance on tables around 10,000 rows.)

BeAccessible isn't guaranteed to work on tables you've already created in an SQLite database. If you do come across a table that BeAccessible can't handle, feel free to send me the table structure and I'll see if I can fix the problem.

This is my first BeOS program, so use at your own risk.

Comments, suggestions, and bug reports are very much welcome.

Details about this version:

• SQLite v2.8.11 is included in the download file.
• Ability to copy rows. They can be pasted into another application (eg, Gobe, text file, etc), but pasting data into a table isn't implemented yet.
• Icons in the bottom left corner of the Data view for next/previous row, first/last row, and new row.
• Also in the bottom left corner is a current row number textbox. Typing a different row number and pressing Enter will go to that row.
• In Design view, the "Allow Null" property has been renamed to "Required".
• Copy/Paste tables.
• Improved performance on relatively large tables (performance is decent on tables around 10,000 rows).
• Delete key corresponds to deleting a table or row.
• Home/End/Page Up/Page Down keys work in Data view when a row is highlighted.
• Tools -> Compact (runs the SQLite VACUUM command).
• Edit -> Select All in Data view.
• File -> Open Recent submenu.
• Lots of misc. bug fixes.
• Tested on Zeta and R5.
• "Copy-Over" functionality. After clicking in a cell in Data View, hold Control and press one of the arrow keys. Text will be inserted from an adjacent cell in the direction of the arrow. For example, pressing Control-right arrow will insert the text from the cell immediately to the left (ie, text flows to the right). This works in all four directions. It grew out of trying to implement the Control-single quote shortcut in Access, which inserts the text from the cell directly above the current one. Let me know if you find this feature useful or not.
• New screenshot

Related Links:

• BeOS port of SQLite
• SQLite

Submitted On:

30 Nov 1999

Submitted By:

Karl vom Dorff (karl)

Submitted On:

03 Oct 2008

File Size:

613.71 Kb

Downloads:

120

License:

Freeware

File Version:

0.5

File Author:

randar

Rating:

Total Votes:0

Please register to post comments