Python Forum
Package delivery app, what is the best database to use
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Package delivery app, what is the best database to use
#1
In dire need of an app to manage 200+ packages on a 600+ box postal route
Need a local file dB to enter 600 box #’s of the route along with road names and geo coords
We are required to put 200+ card stock reminders in the mail
Wouldn’t it be great to scan the package labels and have an app tell you of an approaching delivery ?

WHAT IS THE BEST DATABASE TYPE, ANY IDEAS ?
Reply
#2
It all depends on your application, with a bit of personal bias thrown in.
If I am building a small to medium application, I tend to use sqlite as it's easy to implement and everything is contained in a single file which makes transfers and distribution easy.
If you are going to be implementing anything with global information like spatial maps, PostgreSQL is the winner hands down (in my opinion). I would also use it where large numbers of users might be involved.

A good place to start is: https://en.wikipedia.org/wiki/Comparison...nt_systems

A lot of chatter these days about graph databases, I'm not convinced (yet) that they can handle large scale implementations.
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020