![]() ![]() SQLMagic is currently in limited beta test and will soon be released for public beta. Users can search by typing their search operators/values into fields on a card and can save search criteria for later use.įor many transactions, SQLMagic removes the need for issuing SQL statements or writing Livecode scripts but also provides callbacks at various critical processing points to give you complete control. It also takes care of formatting of dates, currencies, and numbers based on a combination of the user's local and preference settings. SQLMagic will figure out the appropriate linkages between tables based on foreign keys and only display the linked entries. You can access multiple tables on one card, populate option menus for database values, and operate in any combination of Select, Update, Insert or Delete mode. Using the SQLMagic palette, you will be able to drag and drop standard LC controls onto a card and relate them to columns/expressions in you database, or you can quickly create all the controls necessary to maintain a table using the Generate Layout feature. I feel I should mention my upcoming product, SQLMagic, in this thread. I do remember reading something in the Kickstarter Campaign about additional Database tools being developed. Finally I can move on from Filemaker, which I have been hoping to do for some time now. It is really good for that, as database concepts can be overwhelming at first and Filemaker provides the GUI and streamlined tools for managing a database and all its confusing dimensions.īut Livecode has enough tools at this point to do what I need, with some features that will allow me to put together a database application in short time. So I no longer have to fire up a Virtual Machine every time I am working on a database application.įilemaker was where I learned about databases. ![]() Lastly, and the most important to me, Livecode runs on Ubuntu. You have to set up each computer with ODBC, then you have to open your database to be accessible from the WAN (which is always frightening, even when I restrict it to specific IP's)Īlso, Filemaker is essentially an Apple product, and like other Apple products they are proprietary and want you to use other Apple products (Filemaker Go, Filemaker Server)įor the past month, I have been spending a little time each day with Livecode, and then a little time learning some SQL.īetween the two, I feel I can build a database application that will work across multiple platforms, is secure, and uses standard SQL that I can take anywhere. In particular, connecting to a remote MySQL server is a pain. I have not found anything that manages that as well (not even MySQL workbench.which is good, but not as fluid as Filemaker)īut Filemaker has its shortcomings. The exception is that Filemaker has (in my opinion) an excellent graphical tool for arranging your database relationships. After one month of tinkering with Livecode, I can say with honesty that I like Livecode better than Filemaker. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |