Re: syntax usage for the Database name ??
Ramiro,
Thank you so much for your reply... apologies for the late response
On Wednesday, May 14, 2014 3:43:32 PM UTC+3, Ramiro Morales wrote:
>
> On Wed, May 14, 2014 at 8:38 AM, Eran Ariel <eran@gmail.com
> > wrote:
> > Hi,
> >
> >
> >
> > I am uncertain as to the proper syntax usage for the Database name.
> >
> > I have a MYSQL database called "test". Does the subsequent script
> > automatically point to the folder where mysql databases reside on my
> Ubuntu
> > machine?
> >
> >
> >
> > os.path.join(BASE_DIR, 'db.test ')
> >
> >
> >
> > Furthermore, the instructions as per the Django site are to provide the
> full
> > path where the database resides… However, I am again uncertain whether
> that
> > refers specifically to all databases and how to apply it in proper
> syntax
> >
> >
> >
> > Can someone provide me with a configuration example?
>
> If you are using a RDBMS like mysql, or any of them different from
> sqlite3 then in the NAME value you should simply specify the name of
> the database in which you want Django creates the tables for the apps
> of your project.
>
> Per
> https://docs.djangoproject.com/en/1.6/topics/install/#get-your-database-running
>
> and https://docs.djangoproject.com/en/1.6/intro/tutorial01/#database-setup,
>
> that database should have been created previously using the MySQL
> administrative tools and the user you plan to use should have the
> right permissions on it.
>
> sqlite3 is special in the sense that it is a embeddable library (as
> opposed to a RDBMS). That's why you need to specify the file system
> path to the file the library will create the first time. No need to
> provide USER/PASASWORD credentials because that's another feature it
> doesn't provide.
>
> With a RDBMS you connect to it possibly through the network and use
> SQL to handle tables. It is in charge of handling low level details
> like which files(s) it is using to store your data.
>
> An example DATABASES setting value (for postgres)::
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.postgresql_psycopg2',
> 'HOST': '',
> 'NAME': 'django_test_suite',
> 'USER': 'ramiro',
> 'PASSWORD': '123',
> },
> 'other': {
> 'ENGINE': 'django.db.backends.postgresql_psycopg2',
> 'HOST': '',
> 'NAME': 'other',
> 'USER': 'ramiro',
> 'PASSWORD': '123',
> }
> }
>
> HTH
>
> --
> Ramiro Morales
> @ramiromorales
>
--
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 post to this group, send email to django-users@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/0aeb7f85-bda0-4bf9-9e59-c71c8ce92a0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: syntax usage for the Database name ??
On Wed, May 14, 2014 at 8:38 AM, Eran Ariel <eran.ar...@gmail.com> wrote:
> Hi,
>
>
>
> I am uncertain as to the proper syntax usage for the Database name.
>
> I have a MYSQL database called "test". Does the subsequent script
> automatically point to the folder where mysql databases reside on my Ubuntu
> machine?
>
>
>
> os.path.join(BASE_DIR, 'db.test ')
>
>
>
> Furthermore, the instructions as per the Django site are to provide the full
> path where the database resides… However, I am again uncertain whether that
> refers specifically to all databases and how to apply it in proper syntax
>
>
>
> Can someone provide me with a configuration example?
If you are using a RDBMS like mysql, or any of them different from
sqlite3 then in the NAME value you should simply specify the name of
the database in which you want Django creates the tables for the apps
of your project.
Per
https://docs.djangoproject.com/en/1.6/topics/install/#get-your-database-running
and https://docs.djangoproject.com/en/1.6/intro/tutorial01/#database-setup,
that database should have been created previously using the MySQL
administrative tools and the user you plan to use should have the
right permissions on it.
sqlite3 is special in the sense that it is a embeddable library (as
opposed to a RDBMS). That's why you need to specify the file system
path to the file the library will create the first time. No need to
provide USER/PASASWORD credentials because that's another feature it
doesn't provide.
With a RDBMS you connect to it possibly through the network and use
SQL to handle tables. It is in charge of handling low level details
like which files(s) it is using to store your data.
An example DATABASES setting value (for postgres)::
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': '',
'NAME': 'django_test_suite',
'USER': 'ramiro',
'PASSWORD': '123',
},
'other': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': '',
'NAME': 'other',
'USER': 'ramiro',
'PASSWORD': '123',
}
}
HTH
--
Ramiro Morales
@ramiromorales
--
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 post to this group, send email to django-users@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/CAO7PdF-zRbZG4dX90MET8ynynajTYdM%2BvwRqjaOuCNeDMHNC-Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
syntax usage for the Database name ??
Hi, I am uncertain as to the proper syntax usage for the Database name. I have a MYSQL database called "test". Does the subsequent script automatically point to the folder where mysql databases reside on my Ubuntu machine? os.path.join(BASE_DIR, 'db.test ') Furthermore, the instructions as per the Django site are to provide the full path where the database resides… However, I am again uncertain whether that refers specifically to all databases and how to apply it in proper syntax Can someone provide me with a configuration example? Thanks in advance Eran Ariel -- 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 post to this group, send email to django-users@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/5e9f7b94-bf02-4d00-8d56-710ad3f0dfd5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
