Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-21 Thread LacaK via fpc-pascal
https://github.com/fpc/FPCSource/tree/main/packages/mysql I do not understand. I see a source file for mysql80dyn.pp, but shouldn't tthere also be a mysql80conn.pp? It is in https://github.com/fpc/FPCSource/tree/main/packages/fcl-db/src/sqldb/mysql L. ___

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-20 Thread Terry A. Haimann via fpc-pascal
https://github.com/fpc/FPCSource/tree/main/packages/mysql I do not understand. I see a source file for mysql80dyn.pp, but shouldn't tthere also be a mysql80conn.pp? Terry H. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org https://lists.free

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-20 Thread Ralf Quint via fpc-pascal
On 9/20/2021 12:39 AM, antlists via fpc-pascal wrote: On 20/09/2021 00:12, Ralf Quint via fpc-pascal wrote: On 9/18/2021 7:33 AM, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal i

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-20 Thread antlists via fpc-pascal
On 20/09/2021 00:12, Ralf Quint via fpc-pascal wrote: On 9/18/2021 7:33 AM, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal install for MySQL 8.0.  I do see that there is an open t

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Ralf Quint via fpc-pascal
On 9/18/2021 7:33 AM, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal install for MySQL 8.0. I do see that there is an open ticket to create a connector. Is there an Alpha or Beta

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Terry A. Haimann via fpc-pascal
I hate to sound stupid, but ... I found the link to fpc.zip, but firefox can't do anything with it. If it is a ftp site I need to go to, I need the address and user/pw/port to get in. I found a refrence to fpc.dfmk.hu, but I don't know user/pw/port. Thank You for your attention. Terry H. On S

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Florian Klämpfl via fpc-pascal
> Am 19.09.2021 um 10:46 schrieb Michael Van Canneyt via fpc-pascal > : > > > > On Sun, 19 Sep 2021, Florian Klämpfl via fpc-pascal wrote: > >> >> >>> Am 19.09.2021 um 10:16 schrieb Michael Van Canneyt via fpc-pascal >>> : >>> On Sat, 18 Sep 2021, Florian Klämpfl via fpc-pascal wrote: >>>

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Michael Van Canneyt via fpc-pascal
On Sun, 19 Sep 2021, Florian Klämpfl via fpc-pascal wrote: Am 19.09.2021 um 10:16 schrieb Michael Van Canneyt via fpc-pascal : On Sat, 18 Sep 2021, Florian Klämpfl via fpc-pascal wrote: Am 18.09.21 um 17:34 schrieb Michael Van Canneyt via fpc-pascal: On Sat, 18 Sep 2021, Terry A. Hai

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Florian Klämpfl via fpc-pascal
> Am 19.09.2021 um 10:16 schrieb Michael Van Canneyt via fpc-pascal > : > > > > On Sat, 18 Sep 2021, Florian Klämpfl via fpc-pascal wrote: > >> Am 18.09.21 um 17:34 schrieb Michael Van Canneyt via fpc-pascal: >>> On Sat, 18 Sep 2021, Terry A. Haimann via fpc-pascal wrote: I just upgrade

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-19 Thread Michael Van Canneyt via fpc-pascal
On Sat, 18 Sep 2021, Florian Klämpfl via fpc-pascal wrote: Am 18.09.21 um 17:34 schrieb Michael Van Canneyt via fpc-pascal: On Sat, 18 Sep 2021, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connecto

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-18 Thread Florian Klämpfl via fpc-pascal
Am 18.09.21 um 17:34 schrieb Michael Van Canneyt via fpc-pascal: On Sat, 18 Sep 2021, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal install for MySQL 8.0.  I do see that there

Re: [fpc-pascal] FreePascal and MySQL 8.0

2021-09-18 Thread Michael Van Canneyt via fpc-pascal
On Sat, 18 Sep 2021, Terry A. Haimann via fpc-pascal wrote: I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal install for MySQL 8.0. I do see that there is an open ticket to create a connector. Is there an Alpha or Be

[fpc-pascal] FreePascal and MySQL 8.0

2021-09-18 Thread Terry A. Haimann via fpc-pascal
I just upgraded to a new laptop and see that MariaDB is using MySQL 8.0 . I also see there is no connector in my Free Pascal install for MySQL 8.0. I do see that there is an open ticket to create a connector. Is there an Alpha or Beta version of the connector available that I can try? Thank you

Re: [fpc-pascal] FreePascal and MySQL ?

2017-11-20 Thread Michael Van Canneyt
On Mon, 20 Nov 2017, Terry A. Haimann wrote: Hello, This is probably a dumb question. But I have data in a tstringlist that I want to upload into a MediumText MySQL column. It looks to me as if you do something like: Stream := TMemoryStream.Create; MySL.SaveToStream(Stream)

Re: [fpc-pascal] FreePascal and MySQL ?

2017-11-20 Thread Snorkl e
You don't need to use a stream just do Dataset.fieldbyname('somecolumn').asstring:=mystringlist.text On Nov 20, 2017 10:02 AM, "Terry A. Haimann" wrote: > Hello, > > This is probably a dumb question. But I have data in a tstringlist that > I want to upload into a MediumText MySQL column. It l

[fpc-pascal] FreePascal and MySQL ?

2017-11-20 Thread Terry A. Haimann
Hello, This is probably a dumb question. But I have data in a tstringlist that I want to upload into a MediumText MySQL column. It looks to me as if you do something like: Stream := TMemoryStream.Create; MySL.SaveToStream(Stream); Blobfield(BcfQuery.FieldByName('JobMemo'

Re: [fpc-pascal] FreePascal and MySQL

2015-05-02 Thread Marco van de Voort
In our previous episode, Terry A. Haimann said: > I was kind of unimpressed with the performance of TSqlQuery compared to > c. > > I wrote two programs that built the same identical table. A random set > of names with addresses. I found the user time of the program written > in c was 20% of th

Re: [fpc-pascal] FreePascal and MySQL

2015-05-02 Thread Michael Van Canneyt
On Fri, 1 May 2015, Terry A. Haimann wrote: I was kind of unimpressed with the performance of TSqlQuery compared to c. That is logical. Beside the point raised by Jonas, if you use a library which is designed to be general and cross-db-engine, it will always be somewhat slower than code w

Re: [fpc-pascal] FreePascal and MySQL

2015-05-01 Thread Adriaan van Os
Terry A. Haimann wrote: I was kind of unimpressed with the performance of TSqlQuery compared to c. To build a table really fast, try Postgres COPY FROM STDIN / TO STDOUT BINARY with Postgres libpq

Re: [fpc-pascal] FreePascal and MySQL

2015-05-01 Thread Jonas Maebe
On 01/05/15 18:07, Terry A. Haimann wrote: > I wrote two programs that built the same identical table. A random set > of names with addresses. I found the user time of the program written > in c was 20% of that which was written in Free Pascal. How did you generate the random names? FPC uses the

[fpc-pascal] FreePascal and MySQL

2015-05-01 Thread Terry A. Haimann
I was kind of unimpressed with the performance of TSqlQuery compared to c. I wrote two programs that built the same identical table. A random set of names with addresses. I found the user time of the program written in c was 20% of that which was written in Free Pascal. Is there any chance of