Mailing List Archive: Python: Python

connection change

Index | Next | Previous | View Threaded

Inna.Belakhova at melbourne

Aug 8, 2013, 7:23 PM

Post #1 of 5 (19 views)
Permalink

connection change

Hi,

I have a compiled code, which currently uses SQLITE connection
(datastore). I was wondering if it is possible to change the connection
string to use SQL Server database.

I would like to export the datastore to SQL server database, as we are
having issues with the sqlite limit.

Thank you.

Inna

This email is intended solely for the named addressee.
If you are not the addressee indicated please delete it immediately.

joel.goldstick at gmail

Aug 9, 2013, 11:36 AM

Post #2 of 5 (13 views)
Permalink

Re: connection change [In reply to]

On Thu, Aug 8, 2013 at 10:23 PM, Inna Belakhova
<Inna.Belakhova [at] melbourne> wrote:
> Hi,
>
>
>
> I have a compiled code, which currently uses SQLITE connection (datastore).

I don't understand 'compiled code'. It would be nice if you show the
code, give the version of python you are using, and the operating
system

Have you tried to change your program to use mysql instead? If so,
show the changes you made and what the results were.

> I was wondering if it is possible to change the connection string to use SQL
> Server database.

yes it is possible
>
>
>
> I would like to export the datastore to SQL server database, as we are
> having issues with the sqlite limit.
>
>
>
> Thank you.
>
> Inna
>
>
>
> This email is intended solely for the named addressee.
> If you are not the addressee indicated please delete it immediately.
>
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>

--
Joel Goldstick
http://joelgoldstick.com
--
http://mail.python.org/mailman/listinfo/python-list

joel.goldstick at gmail

Aug 9, 2013, 10:02 PM

Post #3 of 5 (12 views)
Permalink

Re: connection change [In reply to]

On Fri, Aug 9, 2013 at 7:31 PM, Dennis Lee Bieber <wlfraed [at] ix> wrote:
> On Fri, 9 Aug 2013 14:36:54 -0400, Joel Goldstick
> <joel.goldstick [at] gmail> declaimed the following:
>
>
>>
>>Have you tried to change your program to use mysql instead? If so,
>>show the changes you made and what the results were.
>>
>
> Pardon? "mssql" is not the same as "mysql"

oops.. bad reading Dennis..
> --
> Wulfraed Dennis Lee Bieber AF6VN
> wlfraed [at] ix HTTP://wlfraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list

--
Joel Goldstick
http://joelgoldstick.com
--
http://mail.python.org/mailman/listinfo/python-list

Inna.Belakhova at melbourne

Aug 11, 2013, 4:50 PM

Post #4 of 5 (4 views)
Permalink

RE: connection change [In reply to]

Hi,

I don't know much about Python code. Where is the connection made, eg
config file - where can I find it?

Our SQLITe database is currently 9GB and we have a table that contains
7GB of BLOB type. I think the table cannot handle any more insert of
BLOB hence I want to change it to SQL database - which has no
restriction on database size.

Any suggestions?

Cheers,
Inna

-----Original Message-----
From: Python-list
[mailto:python-list-bounces+inna.belakhova=melbourne.vic.gov.au [at] python
rg] On Behalf Of Joel Goldstick
Sent: Saturday, 10 August 2013 3:02 PM
To: Dennis Lee Bieber
Cc: python-list [at] python
Subject: Re: connection change

On Fri, Aug 9, 2013 at 7:31 PM, Dennis Lee Bieber
<wlfraed [at] ix> wrote:
> On Fri, 9 Aug 2013 14:36:54 -0400, Joel Goldstick
> <joel.goldstick [at] gmail> declaimed the following:
>
>
>>
>>Have you tried to change your program to use mysql instead? If so,
>>show the changes you made and what the results were.
>>
>
> Pardon? "mssql" is not the same as "mysql"

oops.. bad reading Dennis..
> --
> Wulfraed Dennis Lee Bieber AF6VN
> wlfraed [at] ix HTTP://wlfraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list

--
Joel Goldstick
http://joelgoldstick.com
--
http://mail.python.org/mailman/listinfo/python-list
This email is intended solely for the named addressee.
If you are not the addressee indicated please delete it immediately.

--
http://mail.python.org/mailman/listinfo/python-list

joel.goldstick at gmail

Aug 12, 2013, 11:07 AM

Post #5 of 5 (3 views)
Permalink

Re: connection change [In reply to]

On Sun, Aug 11, 2013 at 7:50 PM, Inna Belakhova
<Inna.Belakhova [at] melbourne> wrote:
> Hi,
>
> I don't know much about Python code. Where is the connection made, eg
> config file - where can I find it?
>
> Our SQLITe database is currently 9GB and we have a table that contains
> 7GB of BLOB type. I think the table cannot handle any more insert of
> BLOB hence I want to change it to SQL database - which has no
> restriction on database size.
>
> Any suggestions?

use google: "python mssql"

>
> Cheers,
> Inna
>

--
Joel Goldstick
http://joelgoldstick.com
--
http://mail.python.org/mailman/listinfo/python-list

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads