Generally SqlLite is enough for any testing. However, if you are planning to
test it with par the other regular DBs, then do not do it. I have seen your
GIT-HUB code. Use postgres, you will be happy .
On Wednesday, 21 August, 2019, 10:12:38 pm IST, Jonathan Mrutu
<jonathan.mr...@gmail.com> wrote:
Hi Jaemin,
You can try to post this question on stack overflow, but why don't you use
PostgreSQL this is recommended.
SQLite as the name implies it's more for testing purpose in a small project
environment.//Jona
| | Virus-free. www.avast.com |
On Wed, Aug 21, 2019 at 2:48 PM Jaemin Noh <korsn...@korsnack.kr> wrote:
Hello.
My application is currently in a development state, so it's using SQLite as a
database backend at the moment.
Due to the bad design decisions, my application has a migration with raw CREATE
VIEW statements and unmanaged models. These VIEWs refer other tables with JOIN
clauses.The problem is, when a column is being added to or removed from a table
with a migration, Django remakes
table(https://github.com/django/django/blob/1e429df748867097451bf0b45d1080ae6828d921/django/db/backends/sqlite3/schema.py#L320-L346),
and VIEW throws a 'no such table' error when joined table is being deleted.
Maybe this is SQLite's problem since table is being deleted inside a
transaction and this should not cause any problem in theory. Maybe it can be
fixed in Django to use ALTER TABLE statement.
Ultimately, I can just get away with this problem if I switch to MySQL or
PostgreSQL.
So, what should I do? Where should I report this 'bug' or 'problem'? SQLite?
Django?
Thanks in advance.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/21c59661-bdba-43f6-9551-de1a6bf278de%40googlegroups.com.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAD9jLPLTvpG%3D1-Psj%2BxdfORgy1ASov-Ue6RDU8UiwRNGM6tk1w%40mail.gmail.com.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/1897926499.413486.1566407846657%40mail.yahoo.com.
