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

Posted by john larson
john larson
16,594 Points

If I just want to collect form data, is sqlite a reasonable choice for that?

Just trying to grasp the database thing. I ignorantly tried to put sqlite on my server, and there didn't seem to be a process for that (at least not one obvious to me) So I began looking into it further and started to get the impression that it's designed to just be installed on my computer? Have I got that impression correct?

2 Answers

markmneimneh
markmneimneh
14,132 Points

Hi

Correct to both.

The server where you will be deploying your app need to have Python installed as well. and since you will be using sqlLite, the sqlLite file needs to be on the server. Some folks may say you can put it on a shared drive that you can access from the server ... it is really not a recommended appraoch.

john larson
john larson
16,594 Points

Thanks mark, I appreciate the input.

markmneimneh
markmneimneh
14,132 Points
markmneimneh
markmneimneh
14,132 Points

Hi

sqlite belong to type of DBs that are often non-network DB. This type of databases are intended as local data storage for apps and devices ... meaning exactly what you sensed. They can be great for the purpose they are designed for as they are fast due to localization.

If this answers your question, please mark the question as answered.

john larson
john larson
16,594 Points

Mark thanks for that. So I haven't got to the point yet of having my python code on a server. Tell me I I have this right. When I get to the point of deploying some kind of Python app, or code:

  • 1: I will need to have Python installed on my server
  • 2: my sqlite will be a file on the server just like it is a file on my pc now
  • Thanks.