General DB is great for recording information quickly and flexibly into a modern, full-fledged database. General DB lets you edit data in your database as if it were a spreadsheet, and you can open multiple databases at once and copy-and-paste data or drag-and-drop tables between them. Some valuable features: Open Multiple Database Windows: For dragging and dropping tables, or copying and pasting rows Spreadsheet-Like: Lets you edit individual cells, or copy and paste selected cells to another app Easily Create SQL Views: For displaying only some of the fields of a table, or reordering the fields, or filtering out some of its rows Print Labels: Good for postcards, stickers, envelopes, and forms Copy and Paste Rows: Copy and paste selected rows or cells to another database or app. Drag and drop tables between databases. Import and Export Rows: From CSV, tab-delimited, or pipe-delimited files SQL Console: Execute SQL and make favorites Designed for both casual users and power users, General DB can be used as a replacement for some spreadsheet tasks, or as a staging system for larger database systems, or for publishing data sets to iOS devices using the Private DB app, or for many other tasks. Some example uses: Say you have a bottle collection, and you want to keep up with what you have. You could make a table with these fields: Date Acquired, Bottle Type, Bottle Origin, Shape, Notes. Then whenever you add a new bottle to your collection, you can add a row to the table describing it. If you want to track visits to different vacation sites, you can make a table with fields for the Date Visited, Location, Description, and Attraction. As you visit the sites, you can add corresponding rows to your table. After you add rows to your tables, they will be: * Searchable * Sortable * Selectable Many apps are too specific to a subject, but General DB is flexible enough to handle many, many needs, such as: - Inventories - Customer info - Membership lists - Tracking Logs - Accounts - and many more ! No database knowledge is required to use this app, but you will pick some up as you go! Distribute databases to either General DB for the iPhone and iPad, or the free Private DB! For power users: General DB allows easy data entry into a full-fledged SQLite database. To do so, it enhances it with field formats. The field formats allowed are Text, Number, Date, Time, Duration, Location, Photo, Barcode, Raw, Picker, and Lookup Table. There are convenient buttons next to some fields for easier input. For administrators or IT manager, you can create a master database of reference information that you don't want your users to modify. This master database can be published on the internet and either the Private DB app or General DB can download and view it. Some more powerful features: - Import text files into tables - Execute SQL - Custom picker field formats to select values from a list - SQL templates for tables - Add SQL statements to your Favorites - See and execute past SQL in the History - Create views as JOINs of 2 or more tables for relational capabilities - Export selected rows from your tables to a file - Create databases - And much more!
A Great Find
This is a super little product that does far more than I expected. It certainly provides all the basics that I need and, with a little practice, is very easy to use. Thank you to the developer! It's just what I needed.
NOT FOR BEGINNERS !!
There is NOTHING intuitive in this program. I watched their videos on how to do things, like simply add a row. I still have no clue. I'm sure when you know it's easy as pie. I wanted to make a simple invintory list of 20 items and 3 columns. Not take a course in DB construction.
Worse Database I've ever used
Not simple...or "Efficient"...manual makes no sense! Impossible to print data properly...doesn't explain how to set margins, sizes, columns, etc. Created for db designers maybe? But not for the average user. I've worked with Mac db's for years but this is a waste of money!!! Actually not worth any Stars!!!!!
Efficient and Powerful
I needed a Mac database to perform simple searches on a 1.5M record file (usually done with Access on Windows). General DB did the trick, and sooo much quicker than Access. Support questions sent to the developer were answered quickly. 5 stars!
Works great even for a newbie!
I am anything but experienced with SQL, and I am delighted with the ease of use of this app. Product support is also timely and helpful, and I’m really glad I gave General DB a shot! I’ll be using this app a lot.
Horrible excuse for a database
I have never used a program that was so hard to figure out. I can’t even figure out how to add a entry very easily. Seems like they went out of their way to make this app harder to use. This update made it even worse than the last one. Save your money this app is ore bother than it;s worth. General DB your out of chances to impress me, my recycle bin is hungry.
As Advertised
Solid app that does what it’s advertised to do. Here are the features I like about General DB: - I didn’t pay big bucks for the app. I could have purchased an enterprise level database app more with a more powerful user interface, but I would have shelled out for it. - The database easily handles large data tables with many records. In contrast, another popular database app I have groans with large data tables. - The corresponding iOS app makes it handy to share data files with my mobile devices. This can be done through Dropbox or through iTunes. - Tech support through email is responsive and friendly. - The database comes with some helpful SQLite templates — perfect for me as I am not altogether fluent in SQLite. I hope General DB’s developers continue to refine the app. I would like to see more varieties of field types such as integer, decimal, and boolean.
SELECT * FROM Maintenance WHERE Description REGEXP '^Fixed' - SQLite 3.36.0
Subscribe our newsletter and get useful information every week.