can i use sqlite for big project?

[Arindam sarkar]

i need to develop a job portal . is there any problem if i use sqlite ? coz i am having problem to setup mysql or postgresql . please help.

--

Regards,

Arindam

Contact no. 08732822385

[Karim]

On Thu, Jun 25, 2015 at 5:08 PM, Arindam sarkar <asark...@gmail.com> wrote:

i need to develop a job portal . is there any problem if i use sqlite ? coz i am having problem to setup mysql or postgresql . please help.

​sqlite was not created for big portal. Use postgresql​

--

Karim N. Gorjux

[Gagaro]

Please refer to the Appropriate Uses For SQLite page: https://www.sqlite.org/whentouse.html

[dk]

as my understanding SQLite will only let you do one transaction at the time. and cant handle big volume of inputs at  once.

is great and easy since comes already as part of python if you are doing something for your local team. like a bug report or something that you know that not every one will be using it ALL the time.

[Andrew Farrell]

Arindam, 

Here are two routes you should consider:

1) Develop your site using SQLite until you get to the point of needing something more performant under heavy loads, then switch over. By the time you switch, you will have developed a deeper understanding of Django and also will have demonstrated confidence-inspiring progress to your client.

2) Work through this tutorial on how to set up django with postgres as well as the webserver combination of gunicorn and nginx. This will give you a robust setup from the beginning and should Just Work.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/9ea5b889-c4fc-474c-87d4-e4a4f71317a5%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Alon Nisser]

Using sqlite would bite you in many way, not really transactional for example, some features (such as certain variation of ```distinct```) not supported etc. Use Postgresql, If you find it hard to setup you can use RDS (that has amazon web services offer of postgresql) or heroku postgresql - both have a basic free tier and take care of all the setup for you.. 

[Thomas Lockhart]

On 6/25/15 7:08 AM, Arindam sarkar wrote:
> i need to develop a job portal . is there any problem if i use sqlite
> ? coz i am having problem to setup mysql or postgresql . please help.

As others have suggested, use Postgres from the start. Spend a few
minutes to understand the setup; it will be worth it.

Feel free to ask more specific questions if you continue to have trouble.

- Tom