Re: Mysql for Django

Yes absolutely you can use it , what kind of error have u faced? On Mon, 25 Sept 2023 at 03:46, DieHardMan 300 wrote: > Do you mean you can't use mysqlclient with Django? Do you already install > homebrew in MAC? Do you already install mysql server using homebrew? > ในวันที่ ว

Re: Mysql for Django

Download MySQL server at https://dev.mysql.com/downloads/mysql/ It will most likely come with mysqlclient but if not, you can download mysqlclient using homebrew, `brew install mysql-client`. You can check out the guide here at https://www.bytebase.com/blog/how-to-install-mysql-client-on-mac

Re: Mysql for Django

Do you mean you can't use mysqlclient with Django? Do you already install homebrew in MAC? Do you already install mysql server using homebrew? ในวันที่ วันจันทร์ที่ 25 กันยายน ค.ศ. 2023 เวลา 3 นาฬิกา 50 นาที 25 วินาที UTC+7 Lakhjeet Samra เขียนว่า: > Hi Guys, > I am new to Django

Re: Mysql for Django

ango project any suggestions > I have Mysql workbench installed Is it right. > > Thank You > Lakhjeet > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receivin

Mysql for Django

Hi Guys, I am new to Django I use Mac , I am unable to down mysqlclient for Django project any suggestions I have Mysql workbench installed Is it right. Thank You Lakhjeet -- You received this message because you are subscribed to the Google Groups "Django users" group. To u

Re: MySQL table is missing ON DELETE CASCADE constraint

you can read through the comments the ticket for the reasons :) On Monday, January 23, 2023 at 3:44:41 AM UTC-5 Dennis Tants wrote: > Thanks for the answers. Still not sure why it would not implement ON > DELETE CASCADE in the DB itself. But whatever. > > Regards, > Dennis > > > On 20/01/2023 2

Re: MySQL table is missing ON DELETE CASCADE constraint

Thanks for the answers. Still not sure why it would not implement ON DELETE CASCADE in the DB itself. But whatever. Regards, Dennis On 20/01/2023 20:15, Jason wrote: https://docs.djangoproject.com/en/4.1/ref/models/fields/#django.db.models.CASCADE > Django emulates the behavior of the SQL c

Re: MySQL table is missing ON DELETE CASCADE constraint

https://docs.djangoproject.com/en/4.1/ref/models/fields/#django.db.models.CASCADE > Django emulates the behavior of the SQL constraint ON DELETE CASCADE and also deletes the object containing the ForeignKey. this is specified in the docs. https://code.djangoproject.com/ticket/21961 On Friday,

Re: MySQL table is missing ON DELETE CASCADE constraint

Hi dennis, You can open a ticket on the trac (https://code.djangoproject.com/query) for whatever issue you are facing.It will be easier to understand there. Regards Bhuvnesh On Fri, Jan 20, 2023, 8:36 PM Dennis Tants wrote: > Hey folks, > > I recently came across what I think is a bug. Let me

MySQL table is missing ON DELETE CASCADE constraint

Hey folks, I recently came across what I think is a bug. Let me try to explain it as detailed as possible. Imagine I have two models, one is called Events, the other is called EventAccounts. EventAccounts can't exist without an Event, so I added a ForeignKey with the on_delete=models.CASCADE c

Re: i am facing problem with my project to update data in mysql using django

can you conform that database user has permissions to update data in all three databases using a mysql client? On Thursday, June 16, 2022 at 12:02:00 PM UTC-4 rafiurra...@gmail.com wrote: > here is my problem description link in stackoverflow > if anyone can help me, i will be gra

Lost connection to MySQL server during query

I have a standalone python script (i.e. not part of a web app) that makes use of the ORM. I call djago.setup(), make some queries, then call a function that can take 8 hours or more to run. When the function returns I want to make more queries, but they fail with 'Lost connection to MySQL s

i am facing problem with my project to update data in mysql using django

here is my problem description link in stackoverflow if anyone can help me, i will be gratefull linkproblem link -- You received this message because you are subscribed to the Google Groups "Django us

Re: mysql 8 file creation issue

I'm not certain, but it doesn't look to me as a MySQL version issue. It's more probably a umask issue. Search for "umask" and you'll probably find the answer. However, it's likely that this is suboptimal and risky. It would probably be better to run `mysql

mysql 8 file creation issue

When I run this query on mysql 5.7: SELECT CURDATE() INTO OUTFILE '/var/lib/mysql-files/test.csv'; It creates test.csv with the following permissions: -rw-rw-rw- 1 mysql mysql 11 Mar 18 04:27 test.csv But when I create the same file in mysql 8.0 it creates file with the

Re: Potential bug: mysql-connector-python Django 3.2.11 and third-party packages that populate the Admin Site

mysql-connector-python 8.0.27 has another bug (see https://stackoverflow.com/questions/69900463/django-migration-error-typeerror-sequence-item-1-expected-a-bytes-like-object ) so I did not try it. mysql-connector-python 8.0.26 did not have this problem with Django 3.1. So the bug must have been

Re: Potential bug: mysql-connector-python Django 3.2.11 and third-party packages that populate the Admin Site

can you observe the same behavior in previous versions of connector? You listed two patch versions, makes me curious where in the 8.x version line this works. Likely this is an issue with mysql-connector-python, but with it being an Oracle product, it doesn't have much internal visib

Re: Potential bug: mysql-connector-python Django 3.2.11 and third-party packages that populate the Admin Site

Use only the mysqlclient package to populate your admin site with MySQL database. You can watch this tutorial also : https://youtu.be/SNyCV8vOr-g On Thu, Feb 3, 2022, 06:19 Richard Mayebo wrote: > Platform: Observed on Ubuntu 20.04 > > > 1. Install MySQL (Observed on 5.7 and

Potential bug: mysql-connector-python Django 3.2.11 and third-party packages that populate the Admin Site

Platform: Observed on Ubuntu 20.04 1. Install MySQL (Observed on 5.7 and 8.0) 2. Create a Virtual environment using venv, and activate it. 3. Install Django 3.2.11 4. Install mysql-connector-python (Observed on 8.0.26 and 8.0.28) 5. Install django-easy-audit and/or django-axes

Re: How to change Mysql server port for using two instances of mysql when running Django code

Thank you!! Vào lúc 00:20:44 UTC+7 ngày Thứ Bảy, 15 tháng 1, 2022, Kasper Laudrup đã viết: > On 14/01/2022 09.18, Khánh Hoàng wrote: > > I want to change mysql server port in 2 different instances of Mysql, > > one for WSL and one for Windows. How can I do it? > > >

Re: How to change Mysql server port for using two instances of mysql when running Django code

On 14/01/2022 09.18, Khánh Hoàng wrote: I want to change mysql server port in 2 different instances of Mysql, one for WSL and one for Windows. How can I do it? https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html Kind regards, Kasper Laudrup -- You received this message because

How to change Mysql server port for using two instances of mysql when running Django code

Hi everyone, I'm new to Django, I'm trying to run Python code using Django framework, I'm on Windows and want to try Redis, because Redis doesn't support Windows machines so I want to run it with WSL I want to change mysql server port in 2 different instances of Mysql,

Re: Strange Errors when Using MySQL DB

https://code.djangoproject.com/ticket/13906 might give some backgroud on this. tl;dr its django setting the default transaction the errors your seeing are mysql bugs, would it be possible to update to a newer version or at least the latest patch of 5.7? On Friday, August 20, 2021 at 12:05:20

Strange Errors when Using MySQL DB

I have a Django (v2.2.23) application connected to a MySQL (v5.7) database. Every now and then, for a few minutes at a time, all my DB queries start to fail with one of the following errors: "Unknown MySQL Error" (error code 2000), "InterfaceError", or "Malformed Packe

Got an error creating the test databse - with mysql and docker-compose

Hi django developers! I have an issue with creating test database. I use mysql for db and docker compose. I have no problem running docker containers with docker-compose, but when I run test it spits this error message. Note that the name of django service is web, and mysql service is db

Re: can I use django authentication in already created mysql database with user data?

On 10/03/2021 07.54, Kevin Thomas wrote: I am creating a web app and I need to authenticate the login. The username and password is already stored in mysql database. Can I use django for authentication of existing data? It will be great help if anyone knows the answer. You can: https

can I use django authentication in already created mysql database with user data?

I am creating a web app and I need to authenticate the login. The username and password is already stored in mysql database. Can I use django for authentication of existing data? It will be great help if anyone knows the answer. -- You received this message because you are subscribed to the

Re: django -mysql

U have try pip install MySql Mahendra Yadav On Tue, 2 Feb 2021, 06:53 Juan Quiroz, wrote: > Trato de usar el pip3 install mysqlclient y me genera este error. > > ERROR: Command errored out with exit status 1: python setup.py egg_info > Check the logs for full command output.

django -mysql

Trato de usar el pip3 install mysqlclient y me genera este error. ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe fr

Re: Django Mysql Bulk_Create Ids

Hi do you hire contract based python/django freelancer? We can help you in this and related techincal tasks at fair prices. Reply or send email to divy...@pythonmate.com Best Regards, Divyesh Khamele, Pythonmate On Mon, 28 Sep 2020, 4:44 am Rohan Nahata, wrote: > How can we make this happen? > W

Re: Django Mysql Bulk_Create Ids

Unfortunately MySQL doesn't support an equivalent of the RETURNING clause on PostgreSQL/Oracle. In other words MySQL only allows to retrieve an inserted row auto id one at a time through its non-standard LAST_INSERT_ID function. That prevents any attempts at inserting multiple row

Django Mysql Bulk_Create Ids

How can we make this happen? What steps would be needed so that bulk_create ends up returning the ids of the items that just got created? I don't want to be machine gunning my db with save statements to retrieve ids. -- You received this message because you are subscribed to the Google Groups

Re: Django MySQL database backup and restore to new server

ango.contrib.contenttypes.models import ContentType > -- >> ContentType.objects.all().delete() > -- >> quit() > - sftp db.json file to new server web project directory > - python manage.py loaddata db.json > > > On Monday, May 4, 2020 at 4:53:29 PM UTC-5, marc bellazzini wrote: >>

Re: Mysql Connect in Django

Watch this to solve your error https://www.youtube.com/watch?v=6SnE0r7g2lE On Mon, Jul 20, 2020 at 7:13 PM Ravindra Mogilipalem < ravindra.m...@gmail.com> wrote: > > When i install mysqlclient in Django so many errors are occured like > Running setup.py clean for mysqlclient > Failed to build

Re: Mysql Connect in Django

Once check which python version you have installed. Like 32 bit or 64bit. Based on your Is try to install the python. It might work. On Mon, 20 Jul 2020, 7:13 pm Ravindra Mogilipalem, wrote: > > When i install mysqlclient in Django so many errors are occured like > Running setup.py clean for m

Mysql Connect in Django

When i install mysqlclient in Django so many errors are occured like Running setup.py clean for mysqlclient Failed to build mysqlclient Installing collected packages: mysqlclient Building wheel for mysqlclient (setup.py) ... error -- You received this message because you are subscribed to the

SRID issues with GeoDjango on MySQL 8

GeoDjango is not respecting SRIDs with MySQL 8. I created a new column geo_code = PointField(srid=4326) and ran makemigrations. Running sqlmigrate on the generated migration gives BEGIN; -- -- Create model Location -- CREATE TABLE `locations_location` (`id` integer AUTO_INCREMENT NOT NULL

Re: Postgresql and mysql

Hey you can Import Files on a Terminal with sudo -u postgres psql < File.txt Salima Begum schrieb am Mo., 18. Mai 2020, 13:50: > Hi , > Mysql query which we used previously now we moved to postgresql, > Here is the below query in mysql , Can anyone help me to write > similar quer

Re: Postgresql and mysql

benefits. https://pgloader.readthedocs.io/en/latest/index.html HTH, ~Ram On Mon, May 18, 2020 at 5:50 AM Salima Begum wrote: > Hi , > Mysql query which we used previously now we moved to postgresql, > Here is the below query in mysql , Can anyone help me to write > similar query i

Re: Can Django (application itself) connect to MySQL via Kerberos/GSSAPI ticket instead of password?

Mysql8.0以上的版本更改了加密规则，这可能需要你多研究一下遇到的问题。我记得需要修改Django框架中的一些源码。 在 2020年5月20日星期三 UTC+8上午9:37:33，Edward Rose写道： > > Hello - Does Django have any support for the web application itself being > able to connect to MySQL using Kerberos Authentication / GSSAPI rather than > a hard coded d

Can Django (application itself) connect to MySQL via Kerberos/GSSAPI ticket instead of password?

Hello - Does Django have any support for the web application itself being able to connect to MySQL using Kerberos Authentication / GSSAPI rather than a hard coded database user name and password? I have searched around the web for a while and am still trying to find a way to get a Django web

Postgresql and mysql

Hi , Mysql query which we used previously now we moved to postgresql, Here is the below query in mysql , Can anyone help me to write similar query in postgresql. query = "LOAD DATA LOCAL INFILE '41098_category_list.txt' INTO TABLE pages_rim_ls_categories FIELDS TERMINATED BY '

Getting error while importing xls file from django admin panel to csv for storing in database mysql gating error like

Imported file has a wrong encoding: 'charmap' codec can't decode byte 0x8d in position 1774: character maps to -- 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 d

Custom Mysql Lookup for FULLTEXT Search Returns empy on test runs

Hi everyone - I am sorry if this is not the right place or format to ask for this typo of help. I have been trying to solve this issue for a while but have not had any luck. I created a Custom Lookup to be able to do full text search on mysql: ``` # lookup class Search(models.Lookup

Re: Django MySQL database backup and restore to new server

ango 2.x running on an old Ubuntu server with a MySQL database. I > have installed a new Ubuntu 20.04 server on another machine with Django 3.x > and MySQL. I would like to backup the old Django/mysql database and restore > it on the new server. What is the best practice for doing this? &

Re: Django MySQL database backup and restore to new server

ango 2.x running on an old Ubuntu server with a MySQL database. I > have installed a new Ubuntu 20.04 server on another machine with Django 3.x > and MySQL. I would like to backup the old Django/mysql database and restore > it on the new server. What is the best practice for doing

Django MySQL database backup and restore to new server

Hello, I have Django 2.x running on an old Ubuntu server with a MySQL database. I have installed a new Ubuntu 20.04 server on another machine with Django 3.x and MySQL. I would like to backup the old Django/mysql database and restore it on the new server. What is the best practice for doing

Re: i want to change database sqllite to mysql but show error

ng for file changes with StatReloader > Exception in thread django-main-thread: > Traceback (most recent call last): > File > "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\site-packages\django\db\backends\mysql\base.py", > > line 16, in > > imp

Re: i want to change database sqllite to mysql but show error

May we see some of your files..precisely settings.py...and have you properly configured your MySQL app...either workbench or xampp? On Apr 12, 2020 20:53, "Andrew Fetting" wrote: > Have you tried > pip3 install mysqlclient > > On Sun, Apr 12, 2020, 7:36 AM Arun Sharma

Re: i want to change database sqllite to mysql but show error

\Users\Arunkumar\PycharmProjects\app2\venv\lib\site-packages\django\db\backends\mysql\base.py", > line 16, in > > import MySQLdb as Database > ModuleNotFoundError: No module named 'MySQLdb' > > The above exception was the direct cause of the following excep

i want to change database sqllite to mysql but show error

python manage.py runserver Watching for file changes with StatReloader Exception in thread django-main-thread: Traceback (most recent call last): File "C:\Users\Arunkumar\PycharmProjects\app2\venv\lib\site-packages\django\db\backends\mysql\base.py", line 16, in import

Re: Can't find the .sql file when config the MySQL as backend server

https://stackoverflow.com/help/how-to-ask -- 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 t

Can't find the .sql file when config the MySQL as backend server

-- 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

Re: Please help me while i am connecting mysql database to django lroject iam getting following error

Thanks brother it really works!!☺️😊 On Sun, 22 Mar 2020, 10:54 pm Motaz Hejaze, wrote: > There is a leading space in ' localhost'.. > Remove it > > On Sun, 22 Mar 2020, 6:59 pm fahad rasool, > wrote: > >> Please help me while i am connecting mysql database

Re: Please help me while i am connecting mysql database to django lroject iam getting following error

There is a leading space in ' localhost'.. Remove it On Sun, 22 Mar 2020, 6:59 pm fahad rasool, wrote: > Please help me while i am connecting mysql database to django lroject iam > getting following error > > -- > You received this message because you are subscr

Re: Inability to Connect django with MySQL database

This looks like your Mysql user can login without password in localhost (are you sure, your user has correct permissions?). Try to create a user with password and allow login from localhost, and change your django settings, also try to connect with your user with mysql client from localhost. El

Re: Inability to Connect django with MySQL database

What's the database variable in your settings.py file On Friday, March 20, 2020 at 2:54:05 PM UTC+1, Ifeanyi Chielo wrote: > > Hello, > I am new to Python django, I have been making efforts to connect a django > application to mysql without success. Bellow is the information

Inability to Connect django with MySQL database

Hello, I am new to Python django, I have been making efforts to connect a django application to mysql without success. Bellow is the information that I got PS C:\Users\IFEANYI CHIELO\divine> python manage.py migrate Traceback (most recent call last): File "C:\Users\IFEANYI CHIELO

Re: ValueError: set_wakeup_fd only works in main thread on Apache2.4.41 + Python 3.8.1 + Django 3.0.2 + MySQL 8.0.19

> wrote: >> >>> Hello >>> When I run my Django Web application with Apache2.4.41 + Python 3.8.1 + >>> Django 3.0.2 + MySQL 8.0.19 on Windows 10 Professional 64 bit version it >>> throws Value Error at /. set_wakeup_fd only works in main thread. >>

Re: ValueError: set_wakeup_fd only works in main thread on Apache2.4.41 + Python 3.8.1 + Django 3.0.2 + MySQL 8.0.19

arth Agarwal > wrote: > >> Hello >> When I run my Django Web application with Apache2.4.41 + Python 3.8.1 + >> Django 3.0.2 + MySQL 8.0.19 on Windows 10 Professional 64 bit version it >> throws Value Error at /. set_wakeup_fd only works in main thread. >> >> T

Re: ValueError: set_wakeup_fd only works in main thread on Apache2.4.41 + Python 3.8.1 + Django 3.0.2 + MySQL 8.0.19

On Sat, Feb 22, 2020 at 9:02 PM Siddharth Agarwal wrote: > Hello > When I run my Django Web application with Apache2.4.41 + Python 3.8.1 + > Django 3.0.2 + MySQL 8.0.19 on Windows 10 Professional 64 bit version it > throws Value Error at /. set_wakeup_fd only works in main thread. &g

RE: Django mysql db issue

Sent from Mail for Windows 10 From: Integr@te System Sent: Saturday, February 22, 2020 4:12 PM To: django-users@googlegroups.com Subject: Re: Django mysql db issue Hi Maturure, Plz look at limitation of char field and option in dj doc: https://docs.djangoproject.com/en/dev/ref/databases

Re: Django mysql db issue

Hi Maturure, Plz look at limitation of char field and option in dj doc: https://docs.djangoproject.com/en/dev/ref/databases/#character-fields On Sat, Feb 22, 2020, 14:52 Perceval Maturure wrote: > Dear all > > Is there anyone experiencing the below with python3.7 Django 2.2 > > django.db.uti

Django mysql db issue

Dear all Is there anyone experiencing the below with python3.7 Django 2.2 django.db.utils.OperationalError: (1074, "Column length too big for column 'url' (max = 16383); use BLOB or TEXT instead") -- You received this message because you are subscribed to the Google Groups "Django users" grou

Re: Django queryset result and mysql query are wrong after updating from 3.0.2 to 3.0.3

بتاريخ الأربعاء، 19 فبراير، 2020 10:51:53 م UTC+3، كتب Ricardo H: > Hi Simon,  > > > It was ok on 2.2.6, only on 3.0.3 it fails. > > > I use BigIntegerField because I use it for some calculations after that, but > even if I try with DurationField it doens't assert right. > > > Definitely mus

Re: Django queryset result and mysql query are wrong after updating from 3.0.2 to 3.0.3

Hello Ricardo, I suggest you follow these docs to submit your bug report and link to this thread. https://docs.djangoproject.com/en/3.0/internals/contributing/bugs-and-features/#reporting-bugs I'd mention that the issue is also present if you use `output_field=DurationField` as BigIntegerField

Re: Django queryset result and mysql query are wrong after updating from 3.0.2 to 3.0.3

Hi Simon, It was ok on 2.2.6, only on 3.0.3 it fails. I use BigIntegerField because I use it for some calculations after that, but even if I try with DurationField it doens't assert right. Definitely must be caused by this patch, if I can't find another solution, where and how should I report

Re: Django queryset result and mysql query are wrong after updating from 3.0.2 to 3.0.3

ed django from 3.0.2 to 3.0.3 the result of the > following code has changed when using a MySQL database. It produces a wrong > sql query and also the wrong result for "*end_total_time"* attribute. > Is this a bug ? also is there any other way to get the wright result us

Django queryset result and mysql query are wrong after updating from 3.0.2 to 3.0.3

Hello, after I updated django from 3.0.2 to 3.0.3 the result of the following code has changed when using a MySQL database. It produces a wrong sql query and also the wrong result for "*end_total_time"* attribute. Is this a bug ? also is there any other way to get the wright result us

Re: Error: Not able to create table using models (Backend mysql)

issing: Unable to create > the django_migrations table ((1064, "You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near '(6) NOT NULL)' at line 1")) > > -- You received this message because

Re: Django and MySQL NDB Cluster

Yesterday I figured how to solve this issue using a custom Database backend. I'm posting this here to help anyone have the same problem. 1. Create a new python package for it (I recommend use poetry <https://python-poetry.org/> for it): django-mysql-nosavepoint/ > ├── django_mys

Re: Django and MySQL NDB Cluster

part is, if I'm undertanding it right, I have to implement my own database backend only to disable savepoints by default on all transactions and I don't thinks it worths the effort. Well, anyway, if someone already knows where I can find a MySQL NDBCLUSTER implementation of a djang

Re: Django and MySQL NDB Cluster

ttp://]about.me/maninder.s.kumar > <http://about.me/maninder.s.kumar?promo=email_sig> > > > > > On Thu, Jan 23, 2020 at 1:49 AM Victor Guimarães Nunes < > nuness...@gmail.com > wrote: > >> Hi, >> >> I'm having some trouble

Re: Django and MySQL NDB Cluster

Will do Em quarta-feira, 22 de janeiro de 2020 18:32:04 UTC-3, Jason escreveu: > > https://code.djangoproject.com/ticket/27677 > > Check the last comment from Tim. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group

Re: Django and MySQL NDB Cluster

> > I'm having some trouble setting up a Django project with a MySQL NDB > Cluster. I found I had to set the storage engine on > DATABASES['default']['OPTIONS'] and I did it. > > DATABASES = { > 'default': config('DATABASE_URL&

Re: Django and MySQL NDB Cluster

https://code.djangoproject.com/ticket/27677 Check the last comment from Tim. -- 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...@googlegrou

Django and MySQL NDB Cluster

Hi, I'm having some trouble setting up a Django project with a MySQL NDB Cluster. I found I had to set the storage engine on DATABASES['default']['OPTIONS'] and I did it. DATABASES = { 'default': config('DATABASE_URL', cast=db_url) } # Check if

Re: Feeding a stored procedure (MySQL) into Django_Tables2 table

es2 for front-end in my app as it nicely fits my >> requirement for displaying information. >> >> My issue is that I need to display information from multiple models >> (MySQL tables) in one screen/template. There is a stored procedure that >> gets all the information

Re: Feeding a stored procedure (MySQL) into Django_Tables2 table

Can you show us your models. On Wed, 25 Dec 2019, 08:03 Gregory Vaks, wrote: > Hello all, > > I am using Django-Tables2 for front-end in my app as it nicely fits my > requirement for displaying information. > > My issue is that I need to display information from multiple mode

Feeding a stored procedure (MySQL) into Django_Tables2 table

Hello all, I am using Django-Tables2 for front-end in my app as it nicely fits my requirement for displaying information. My issue is that I need to display information from multiple models (MySQL tables) in one screen/template. There is a stored procedure that gets all the information that

Django 3 + MySQL + User privilages in DB server

I am going to create in Django new fornt-end (HTML + JS + CSS) to old application based on big MySQL database (lots of tables, views, stored procedures, logs, triggers and so on). I need to force Django to respect database privilage for each user. I know I can give in django some rights e.g

Re: Choosing MySQL or PostGres on Heroku

that you scale by adding more power (CPU, RAM) to an existing machine. MySQL has many different storage engines: https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html <https://slack-redir.net/link?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fstorage-engines.html> Th

Re: Choosing MySQL or PostGres on Heroku

, RAM) to an existing machine. MySQL has many different storage engines: https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html <https://slack-redir.net/link?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fstorage-engines.html> The most popular storage engine among developers is

Re: Choosing MySQL or PostGres on Heroku

On 28/11/2019 10:33 am, Tim Johnson wrote: Using python 3.7.2, Django 2.1.5 on Linux development workstation with deployment to Heroku. I retired several ago, primarily coding in python and mostly working in legacy CGI systems with MySQL backends and still use mysql on my workstation. I am

Choosing MySQL or PostGres on Heroku

Using python 3.7.2, Django 2.1.5 on Linux development workstation with deployment to Heroku. I retired several ago, primarily coding in python and mostly working in legacy CGI systems with MySQL backends and still use mysql on my workstation. I am now essentially a hobbyist who wishes to

Re: How to migrate Django site from MySQL database to Postgres?

:58 PM Ram wrote: > Hi Carlos, > > I see there is a typo in my previous steps which could have mislead you. > Basically old and new sites are different databases. Old site is running > remotely in local host on our Developer's machine with MySQL dB. Now I've > s

Re: How to migrate Django site from MySQL database to Postgres?

Hi Carlos, I see there is a typo in my previous steps which could have mislead you. Basically old and new sites are different databases. Old site is running remotely in local host on our Developer's machine with MySQL dB. Now I've setup new hosting server with Postgres database (empty s

Re: How to migrate Django site from MySQL database to Postgres?

4.2. (virtual env) ~/myprojectdir/manage.py migrate >> 4.3. (virtual env) ~/myprojectdir/manage.py collectstatic >> >> 5. So I want to start with your steps pointed in your blog >> <https://www.calazan.com/migrating-django-app-from-mysql-to-postgresql/> >> since I

Re: How to migrate Django site from MySQL database to Postgres?

t; 4.2. (virtual env) ~/myprojectdir/manage.py migrate > 4.3. (virtual env) ~/myprojectdir/manage.py collectstatic > > 5. So I want to start with your steps pointed in your blog > <https://www.calazan.com/migrating-django-app-from-mysql-to-postgresql/> > since I have to start w

Re: How to migrate Django site from MySQL database to Postgres?

app-from-mysql-to-postgresql/> since I have to start with an empty Postgres database. I'm not sure whether this will work or not. 6. Hopefully if all the commands are successful, I will run the above commands. Please let me know if my plan generally would work? I know you don't have

Re: How to migrate Django site from MySQL database to Postgres?

Hello Carlos, The steps looks promising. We will try it and let you know. Our dB is originally from MySQL configured for PHP based website and later on we moved to Django project development. Now we planned to migrate the site to Postgres database running on Ubuntu for Django project. Thank you

Re: How to migrate Django site from MySQL database to Postgres?

maybe this link help you! https://www.calazan.com/migrating-django-app-from-mysql-to-postgresql/ On Sat, Nov 23, 2019 at 12:23 PM Ram wrote: > Hi, > > We have our Django based website running in our local windows box with > MySQL database. We plan to deploy our site on Ubunt

How to migrate Django site from MySQL database to Postgres?

Hi, We have our Django based website running in our local windows box with MySQL database. We plan to deploy our site on Ubuntu, Postgress, Gunicorn and Nginx stack server. I'm looking for a way to achieve this even with the manual intervention? I appreciate if someone can point me the

Re: mysql data connectivity problem

no From: django-users@googlegroups.com on behalf of Franz Ulenaers Sent: Tuesday, November 19, 2019 5:15 PM To: Django users Subject: Re: mysql data connectivity problem Hi, Do you want to write a python program which read a sqlite3 database and maybe do some

Re: mysql data connectivity problem

Post a pic of what is error First connect with the internet Run it on any other any browser And next post it what is error, so we can check where the error gets -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this gro

Re: mysql data connectivity problem

Check whether any database connection u have given in your pc ex:- if u have already installed any mysql data base in your pc, then uninstall that mysql application, restart the pc After that u can connect to the database of django Next time post with a pic(what is the error is..??) So that i

Re: mysql data connectivity problem

https://docs.djangoproject.com/en/2.2/ref/databases/#oracle-notes "you need to open your settings.py file in that you have database cinfiguration and you can see on goole also" On Wed, 20 Nov 2019 at 08:28, Desh Deepak wrote: > You need to changes Database section inside settings.py > > On Tue,

Re: mysql data connectivity problem

You need to changes Database section inside settings.py On Tue, 19 Nov 2019, 18:59 Prof soul, wrote: > Hi i'm soul i'm new to django and late, i got an idea to handle the django > but there is still lack of database connectivity with django anybody know > about it in easy manner > > -- > You r

Re: mysql data connectivity problem

Hi, Do you want to write a python program which read a sqlite3 database and maybe do some updates and/or create new records in the database ? > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving

Re: mysql data connectivity problem

Refer the docs... Its easy On Tue, 19 Nov 2019, 8:16 pm o1bigtenor, wrote: > On Tue, Nov 19, 2019 at 7:30 AM Prof soul wrote: > > > > Hi i'm soul i'm new to django and late, i got an idea to handle the > django but there is still lack of database connectivity with django > anybody know about

  1   2   3   4   5   6   7   8   9   10   >