The company does offer a migration tool that helps you move data from Bento 4 for Mac to FileMaker Pro 12. The Mac version can also export databases to Numbers, Excel, and comma- or tab-delimited. Download the latest version of TinkerTool for Mac for free. Read 118 user reviews and compare with similar apps on MacUpdate. Bento de Espinosa.
Overview
A big part of creating web applications is storing and managing data. Learn how to model your data, store it, and manage it with one of the most powerful databases professional developers use. This is the natural next step after the Backend track, and it is a prerequisite for this track. If you are interested in data science, you can also go through part of this track to deepen your skills.
Intro to Relational Databases
(www.youtube.com)
Watch this series of videos to learn about how relational databases work. This will give you a solid foundation in how data is managed in your web applciation.
Introduction to SQL
(www.w3schools.com)
You've had some exposure to SQL in the foundations section of this track, but learn the ins and outs of the language. This is an old, but still excellent tutorial on SQL from w3schools.
SQLZoo
(sqlzoo.net)
Now that you know the basics of SQL, it's time to try some exercises and get your hands dirty. Go through these interactive tutorials to get through the motions.
Postgres.app
(postgresapp.com)
This is the easiest way to download Postgres if you have a Mac. Go ahead and download it.
Top 10 Psql Commands I Use
(www.chesnok.com)
Once you install Postgres, you should have access to the command 'psql' in your terminal to interact with Postgres. Learn how to use some basic commands in this article.
Use PostgreSQL with Flask
(killtheyak.com)
This is a very quick guide to getting your Postgres database connected to Flask. To start using SQLAlchemy, you're going to need to do this. Try it with your own Flask application.
Flask-SQLAlchemy Quickstart
(flask-sqlalchemy.pocoo.org)
Download the Flask-SQLAlchemy package using Python's pip and go through this tutorial. Try going through it using your Postgres database instead of a SQLite database.
Python SQLAlchemy Tutorial
(www.pythoncentral.io)
This is a pretty extensive tutorial that will show you how Python works together with SQLAlchemy. Go through all the articles in this series, using Postgres as your database instead of SQLite.
Object Relational Tutorial
(docs.sqlalchemy.org)
This is the official documentation for SQLAlchemy. It's the most comprehensive tutorial on their platform as you'll get and it's worth spending time studying it. Go through the whole thing.
Alembic Tutorial
(alembic.readthedocs.org)
Even with a practical understanding of Alembic, it's still very important to get a comprehensive understanding of the technology. This is Alembic's official tutorial. Go through the whole thing.
How Flask, Heroku & Alembic Play Together
(nyghtowl.io)
Read this short tutorial on how Alembic can help you manage database changes, in addition to how it works with Flask and Heroku. Try it with your own application.
FileMaker has announced that it’s discontinuing Bento, its consumer-level database for the Mac and iOS. The app will be available for purchase until September 30.
First introduced back in 2008, Bento sought to make databases less intimidating to the average user. It automatically imported contacts and calendar events, provided iTunes-like search tools, and let users drag-and-drop items for import. The company rapidly iterated on that initial release—Bento 2 came out in late 2008, Bento 3 in 2009, and the current version, Bento 4, in 2011—adding integration with Mail and iPhoto, multi-user sharing, improved security, and more along the way.
Bento Download Machine
FileMaker says that it is discontinuing Bento in order to focus on its namesake product line. If you want a database product, the company is encouraging you to take a look at FileMaker Pro. The company does offer a migration tool that helps you move data from Bento 4 for Mac to FileMaker Pro 12. The Mac version can also export databases to Numbers, Excel, and comma- or tab-delimited formats. Those who used just the iOS versions of Bento can get a free trial version of the app for the Mac, sync their iOS data to that, then export from there to whatever new format they choose. For Bento users who choose to make the migration to the full-powered database tool, the company website recommends using FileMaker Pro’s built-in “starter” templates.
Bento Database Replacement
Users who bought Bento from the Mac or iTunes app stores but then accidentally delete it will still be able to download it again from those sources. Those looking for old software updates will be able to download those from the FileMaker Product Downloads Archive until July 30, 2014 (and possibly beyond). And Bento’s support forums will also continue to be moderated until then.