Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Bryan Guillen
Bryan Guillen
1,051 Points
Posted by Bryan Guillen
Bryan Guillen
1,051 Points

DECISION FRAMEWORK SQLITE3 or SQL?

Hey,

I am going to begin developing my first ever app for production using rails. Quick question.

What are some questions I should be asking myself before choosing which one to go with?

In other words, what are considerations I have to keep in mind when deciding to go with one or the other?

If possible, maybe 3-5 points on which I could make a decision.

PS Goal is to develop a prototype quickly to go to market with it, so it's not some complex ENTERPRISE piece of goodness.

B.G

1 Answer

andi mitre
STAFF
andi mitre
Treehouse Guest Teacher
andi mitre
andi mitre
Treehouse Guest Teacher

Hey Bryan, being that you will be using rails you should make use of rails ORM (activerecord) which is already bundled with sqlite3, MySQL, and Postgres Of course activerecord makes it super easy to perform CRUD operations with these databases. However, keep in mind that the three databases mentioned work great with structured data. If your use case is for unstructured data also consider MongoMapper, MongoID and many more.

Hope that helps!

cheers

Bryan Guillen
Bryan Guillen
1,051 Points
Bryan Guillen
Bryan Guillen
1,051 Points

hey Andi, thanks for your reply, as a new developer, this can be a bit confusing with floods of information out there. I am sure you know the feeling.

Since, I went through MYSQL courses on this website, I now feel extremely confident in working with a simple and basic database. With that said, last thing I am curious of, is where would be ideal to deploy the web app?

I was reading that heroku, with rails apps, only does well with postgres. With that said, when I get to that point, what would you recommend for deployment? Of course this is subjective in nature, from your own experience.

Again, thank you very much for your help.. This community is better place because of nice people like yourself.

cheers.

andi mitre
andi mitre
Treehouse Guest Teacher
andi mitre
andi mitre
Treehouse Guest Teacher

Bryan i usually have deployed to amazon web services, azure or pivotal cloud foundry..however these are not free but aws is also not very expensive and it handles a great burst in requests very well.

Cheers