Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-27 Thread bauss via Digitalmars-d-learn
On Monday, 25 October 2021 at 12:54:32 UTC, greenbyte wrote: On Monday, 25 October 2021 at 07:45:26 UTC, Imperatorn wrote: On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-25 Thread greenbyte via Digitalmars-d-learn
On Monday, 25 October 2021 at 07:45:26 UTC, Imperatorn wrote: On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I config

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-25 Thread Imperatorn via Digitalmars-d-learn
On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I configured MySQL and ran the code from the instructions https://

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-25 Thread greenbyte via Digitalmars-d-learn
with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I configured MySQL and ran the code from the instructions https://github.com/huntlabs/hunt-entity MySQL: mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - GPL) DUB: vers

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-25 Thread bauss via Digitalmars-d-learn
On Sunday, 24 October 2021 at 20:58:22 UTC, greenbyte wrote: On Friday, 22 October 2021 at 11:51:03 UTC, WebFreak001 wrote: On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-24 Thread greenbyte via Digitalmars-d-learn
On Friday, 22 October 2021 at 11:51:03 UTC, WebFreak001 wrote: On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I config

Re: TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-22 Thread WebFreak001 via Digitalmars-d-learn
On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote: Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I configured MySQL and ran the code from the instructions https://

TimeoutException for connecting to MySQL using a hunt-entity.

2021-10-22 Thread greenbyte via Digitalmars-d-learn
Hi, all! I use the hunt-entity library to work with MySQL. I get the hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when trying to connect. I configured MySQL and ran the code from the instructions https://github.com/huntlabs/hunt-entity MySQL: mysql Ver 8.0.27 for Linux

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread frame via Digitalmars-d-learn
On Sunday, 8 November 2020 at 05:07:54 UTC, frame wrote: Something wrong with this library. Well, we need an edit function here. The library has no TCP_NODELAY flag enabled. This fix speeds it up to 10x and solves the 44ms problem to 400us https://github.com/mysql-d/mysql-native/pull/221

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 12:29:46 UTC, Andre Pany wrote: Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly. I have tried mysql-native and it tooks way to long for simple things. My test setup is a remote

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 16:37:22 UTC, Vino wrote: , Trying to improve the above code hence request your help on how to use array container instead of array, tried as per the example below but not working. I think you can just use a static array as ubyte[1024] if you want a fixed bu

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread Vino via Digitalmars-d-learn
On Saturday, 7 November 2020 at 15:26:48 UTC, frame wrote: On Saturday, 7 November 2020 at 14:57:39 UTC, Vino wrote: After further analysis we suspect that the issue is at the package std.net.curl the flow of the program is as below Establishing a new connection may vary in duration of +2

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 14:57:39 UTC, Vino wrote: After further analysis we suspect that the issue is at the package std.net.curl the flow of the program is as below Establishing a new connection may vary in duration of +200ms or more.

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread Vino via Digitalmars-d-learn
do each test multiple time (at least 5 times). There could be for example an effect that executing a db query the first time is a lot slower than afterwards. Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly.

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread Vino via Digitalmars-d-learn
be for example an effect that executing a db query the first time is a lot slower than afterwards. Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly. Kind regards Andre Hi Andre, The benchmark was performed

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread Vino via Digitalmars-d-learn
first time is a lot slower than afterwards. Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly. Kind regards Andre Hi Andre, The benchmark was performed with 100 executions as below void main() { void f() {

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-07 Thread Andre Pany via Digitalmars-d-learn
On Friday, 6 November 2020 at 04:58:05 UTC, Vino wrote: Hi All, We recently tested the below components and the test results are as below, even though hunt-database is faster than mysql-native it is hard to use this package as it lacks on documentation, non of the example provided in the

Re: Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-06 Thread frame via Digitalmars-d-learn
On Friday, 6 November 2020 at 04:58:05 UTC, Vino wrote: Component : mysql-native + asdf Executable size : 17 MB Execution time : 10 secs, 189 ms, 919 μs, and 3 hnsecs Component : hunt-database + asdf Executable size : 81 MB Execution time : 5 secs, 916 ms, 418 μs, and 3 hnsecs Interesting

Comparison : mysql-native + asdf and hunt-database + asdf

2020-11-05 Thread Vino via Digitalmars-d-learn
Hi All, We recently tested the below components and the test results are as below, even though hunt-database is faster than mysql-native it is hard to use this package as it lacks on documentation, non of the example provided in the documentation works, one has to go through the code and

Re: mysql-native Help required

2020-10-24 Thread Vino via Digitalmars-d-learn
On Friday, 23 October 2020 at 20:28:40 UTC, aberba wrote: On Thursday, 22 October 2020 at 18:43:40 UTC, Steven Schveighoffer wrote: [...] Was about to say that. Part of why I think some people hate OOP...due to misuse. All my MySQL projects have this getConnection() function. Hi All

Re: mysql-native Help required

2020-10-23 Thread aberba via Digitalmars-d-learn
On Thursday, 22 October 2020 at 18:43:40 UTC, Steven Schveighoffer wrote: On 10/22/20 11:00 AM, Vino wrote: [...] Different error: Row[] data = conn.query("SELECT * FROM hostlog").array; This is trying to call mysql-native's UFCS query function on Connections, which isn&#x

Re: mysql-native Help required

2020-10-22 Thread Steven Schveighoffer via Digitalmars-d-learn
On 10/22/20 11:00 AM, Vino wrote: On Thursday, 22 October 2020 at 14:08:30 UTC, Steven Schveighoffer wrote: On 10/22/20 7:04 AM, Vino wrote: Hi All,    Request your help on the below code as it is not working as expected. GetConnections.d module common.GetConnections; import mysql; class

Re: mysql-native Help required

2020-10-22 Thread Vino via Digitalmars-d-learn
On Thursday, 22 October 2020 at 14:08:30 UTC, Steven Schveighoffer wrote: On 10/22/20 7:04 AM, Vino wrote: Hi All,   Request your help on the below code as it is not working as expected. GetConnections.d module common.GetConnections; import mysql; class Connections {   private

Re: mysql-native Help required

2020-10-22 Thread Steven Schveighoffer via Digitalmars-d-learn
On 10/22/20 7:04 AM, Vino wrote: Hi All,   Request your help on the below code as it is not working as expected. GetConnections.d module common.GetConnections; import mysql; class Connections {   private Connection conn;   auto constr = "host=localhost;port=3910;user=user;pwd=pas

Re: mysql-native Help required

2020-10-22 Thread novice3 via Digitalmars-d-learn
On Thursday, 22 October 2020 at 11:04:53 UTC, Vino wrote: class Connections { private Connection conn; auto constr = "host=localhost;port=3910;user=user;pwd=password#;db=testdb"; this.conn = new Connection(constr); } where Connections class constructor implemented?

mysql-native Help required

2020-10-22 Thread Vino via Digitalmars-d-learn
Hi All, Request your help on the below code as it is not working as expected. GetConnections.d module common.GetConnections; import mysql; class Connections { private Connection conn; auto constr = "host=localhost;port=3910;user=user;pwd=password#;db=testdb"; this.

Re: Vibe/Mysql Testing

2019-10-17 Thread Vino via Digitalmars-d-learn
On Thursday, 17 October 2019 at 20:21:39 UTC, Andre Pany wrote: On Thursday, 17 October 2019 at 19:05:44 UTC, Vino wrote: [...] Hi, I assume you are using this mysql package http://code.dlang.org/packages/mysql-native. (If not please check wheter the package you are using is vibe-d

Re: Vibe/Mysql Testing

2019-10-17 Thread Andre Pany via Digitalmars-d-learn
: array; import mysql; import std.stdio; import std.range; void main() { auto settings = new HTTPServerSettings; settings.port = 8080; settings.bindAddresses = ["127.0.0.1"]; listenHTTP(settings, &hello); logInfo("Please open http://127.

Vibe/Mysql Testing

2019-10-17 Thread Vino via Digitalmars-d-learn
Hi All, Request your help on the below code and error Error: source\app.d(25,15): Error: none of the overloads of writeBody are callable using argument types (VariantN!20LU), candidates are Code: import vibe.vibe; import std.array : array; import mysql; import std.stdio; import std.range

Re: DUB mysql-native

2019-10-08 Thread Daniel Kozak via Digitalmars-d-learn
to resolve the dub test issue using the you tube video "https://www.youtube.com/watch?v=zvrf7nlq5Og";, but not able to execute the code Code Execution cd HUB/source app.d(3): Error: module `mysql` is in file 'mysql.d' which cannot be read import path[0] = . import path[1]

Re: DUB mysql-native

2019-10-08 Thread Vino via Digitalmars-d-learn
"https://www.youtube.com/watch?v=zvrf7nlq5Og";, but not able to execute the code Code Execution cd HUB/source app.d(3): Error: module `mysql` is in file 'mysql.d' which cannot be read import path[0] = . import path[1] = C:\D\dmd2\windows\bin\..\..\src\phobos import path[2] = C

Re: DUB mysql-native

2019-10-08 Thread Vino via Digitalmars-d-learn
On Tuesday, 8 October 2019 at 11:26:24 UTC, Daniel Kozak wrote: On Tue, Oct 8, 2019 at 1:15 PM Daniel Kozak wrote: ... It is known issue, you can not use mysql-native right now with anything else than libevent https://github.com/mysql-d/mysql-native/issues/199 Or you can just remove

Re: DUB mysql-native

2019-10-08 Thread Daniel Kozak via Digitalmars-d-learn
On Tue, Oct 8, 2019 at 1:15 PM Daniel Kozak wrote: > ... > It is known issue, you can not use mysql-native right now with > anything else than libevent > > https://github.com/mysql-d/mysql-native/issues/199 > > Or you can just remove > > "subConfiguration

Re: DUB mysql-native

2019-10-08 Thread Daniel Kozak via Digitalmars-d-learn
On Tue, Oct 8, 2019 at 10:55 AM Vino via Digitalmars-d-learn wrote: > > Could not resolve configuration for package hub > > From, > Vino.B It is known issue, you can not use mysql-native right now with anything else than libevent https://github.com/mysql-d/mysql-native/issues/

DUB mysql-native

2019-10-08 Thread Vino via Digitalmars-d-learn
HUB dub add dub Adding dependency dub ~>1.17.0 dub add mysql-native Adding dependency mysql-native ~>2.3.0 dub build Fetching libevent 2.0.2+2.0.16 (getting selected version)... Fetching vibe-core 1.7.0 (getting selected version)... Fetching taggedalgebraic 0.11.4 (getting selected version)...

Re: Mysql query result access by field name

2018-05-21 Thread Steven Schveighoffer via Digitalmars-d-learn
On 5/21/18 10:59 AM, kdevel wrote: On Monday, 21 May 2018 at 14:17:23 UTC, Steven Schveighoffer wrote:     Data f;     allrows[0].toStruct (f); I haven't checked this. This only works if your struct has exactly the same layout as the fields. So if, for instance, your rows are selected "title

Re: Mysql query result access by field name

2018-05-21 Thread kdevel via Digitalmars-d-learn
On Monday, 21 May 2018 at 14:17:23 UTC, Steven Schveighoffer wrote:    Data f;    allrows[0].toStruct (f); I haven't checked this. This only works if your struct has exactly the same layout as the fields. So if, for instance, your rows are selected "title", "name", "surname", but your da

Re: Mysql query result access by field name

2018-05-21 Thread Steven Schveighoffer via Digitalmars-d-learn
On 5/21/18 9:39 AM, kdevel wrote: On Sunday, 20 May 2018 at 16:08:03 UTC, ipkwena wrote: How does one access the columns fields in a Mysql query results by the column name. [...] Data f; f.name = to!string(allrows[0][0]); f.surname = to!string(allrows[0][1]); f.title  = to!string(allrows[0

Re: Mysql query result access by field name

2018-05-21 Thread Steven Schveighoffer via Digitalmars-d-learn
On 5/20/18 12:08 PM, ipkwena wrote: I have started learning D and I am enjoying it so far. How does one access the columns fields in a Mysql query results by the column name. Currently I have to use the method as shown in a couple of example by indexing array values (f being a struct variable

Re: Mysql query result access by field name

2018-05-21 Thread kdevel via Digitalmars-d-learn
On Sunday, 20 May 2018 at 16:08:03 UTC, ipkwena wrote: How does one access the columns fields in a Mysql query results by the column name. [...] Data f; f.name = to!string(allrows[0][0]); f.surname = to!string(allrows[0][1]); f.title = to!string(allrows[0][2]); I am using the mysql-native

Mysql query result access by field name

2018-05-20 Thread ipkwena via Digitalmars-d-learn
I have started learning D and I am enjoying it so far. How does one access the columns fields in a Mysql query results by the column name. Currently I have to use the method as shown in a couple of example by indexing array values (f being a struct variable): Data f; f.name

Re: mysql-native ResultRange + map

2017-07-11 Thread crimaniak via Digitalmars-d-learn
On Tuesday, 11 July 2017 at 22:46:00 UTC, Steven Schveighoffer wrote: On 7/5/17 12:04 PM, crimaniak wrote: ... Because of the temporary copy likely inside map closes the connection. See the bug I reported: https://github.com/mysql-d/mysql-native/issues/117 Yes, it seems to be the same

Re: mysql-native ResultRange + map

2017-07-11 Thread Steven Schveighoffer via Digitalmars-d-learn
On 7/5/17 12:04 PM, crimaniak wrote: Hi all! After some hard time with debugging, I found ResultRange returned by query() and Prepared::query() of mysql-native package can't be combined with map() because after map() it becomes empty resultset. [snip] As you see simple each() and fo

mysql-native ResultRange + map

2017-07-05 Thread crimaniak via Digitalmars-d-learn
Hi all! After some hard time with debugging, I found ResultRange returned by query() and Prepared::query() of mysql-native package can't be combined with map() because after map() it becomes empty resultset. Code (conn.queryRows just a wrapper for query(Connections

Re: mysql-native + vibe.d example

2017-06-30 Thread crimaniak via Digitalmars-d-learn
On Friday, 30 June 2017 at 16:18:33 UTC, tetyys wrote: On Friday, 30 June 2017 at 00:52:28 UTC, crimaniak wrote: Hi! Moving my project from mysql-lited to mysql-native I faced the problem with null pointer error inside of mysql-native: seems like it's already fixed https://githu

Re: mysql-native + vibe.d example

2017-06-30 Thread tetyys via Digitalmars-d-learn
On Friday, 30 June 2017 at 00:52:28 UTC, crimaniak wrote: Hi! Moving my project from mysql-lited to mysql-native I faced the problem with null pointer error inside of mysql-native: seems like it's already fixed https://github.com/mysql-d/mysql-native/c

Re: mysql-native + vibe.d example

2017-06-30 Thread Martin Tschierschke via Digitalmars-d-learn
On Friday, 30 June 2017 at 00:52:28 UTC, crimaniak wrote: Hi! Moving my project from mysql-lited to mysql-native I faced the problem with null pointer error inside of mysql-native: [...] It seems I am doing something wrong so myself-native fails to detect it in isValid(). So I search for

mysql-native + vibe.d example

2017-06-29 Thread crimaniak via Digitalmars-d-learn
Hi! Moving my project from mysql-lited to mysql-native I faced the problem with null pointer error inside of mysql-native: Log: SELECT id FROM versionupdate ORDER BY id Task terminated with unhandled exception: etc.linux.memoryerror.NullPointerError@src/etc/linux/memoryerror.d(325

How to Exec Store Procedure For MySql in D? Thanks

2017-02-01 Thread FrankLike via Digitalmars-d-learn
Hi,everyone: Now,I find that I can't exec Store Procedure For MySql in D. use mySql-d,mySql-native,or ddbc. I want to get a SqlResult. I think that it's the time to fix the bug! Who can help me? Thank you! Frank

Re: Problems with stored procedure using the mysql-native library.

2017-01-18 Thread TheFlyingFiddle via Digitalmars-d-learn
On Wednesday, 18 January 2017 at 19:40:12 UTC, TheFlyingFiddle wrote: Hi I am having problems using stored procedures that return results. Update: I am using the SvrCapFlags.MULTI_RESULTS flag when initiating the connection and have also tried using the SvrCapFlags.MULTI_STATEMENTS flag.

Problems with stored procedure using the mysql-native library.

2017-01-18 Thread TheFlyingFiddle via Digitalmars-d-learn
Hi I am having problems using stored procedures that return results. Example procedure: CREATE PROCEDURE GetUsers() SELECT * FROM users; When I use this procedure from the MySQL command line everything works fine. However, when I use it from the mysql-native library i get into problems

Re: Mysql-native - full database backup

2017-01-05 Thread Geert via Digitalmars-d-learn
On Thursday, 5 January 2017 at 21:47:55 UTC, Daniel Kozák wrote: Geert via Digitalmars-d-learn napsal Čt, led 5, 2017 v 3∶13 : [...] [...] Nice function. Thanks!

Re: Mysql-native - full database backup

2017-01-05 Thread Daniel Kozák via Digitalmars-d-learn
Geert via Digitalmars-d-learn napsal Čt, led 5, 2017 v 3∶13 : On Thursday, 5 January 2017 at 01:16:09 UTC, crimaniak wrote: On Monday, 2 January 2017 at 15:29:08 UTC, Geert wrote: Hi! How can i create a full database backup using mysql-native for D? Too common question. Do you have problems

Re: Mysql-native - full database backup

2017-01-05 Thread Geert via Digitalmars-d-learn
On Thursday, 5 January 2017 at 01:16:09 UTC, crimaniak wrote: On Monday, 2 January 2017 at 15:29:08 UTC, Geert wrote: Hi! How can i create a full database backup using mysql-native for D? Too common question. Do you have problems with driver usage? Do you have problems with database backup

Re: Mysql-native - full database backup

2017-01-04 Thread crimaniak via Digitalmars-d-learn
On Monday, 2 January 2017 at 15:29:08 UTC, Geert wrote: Hi! How can i create a full database backup using mysql-native for D? Too common question. Do you have problems with driver usage? Do you have problems with database backup schema?

Mysql-native - full database backup

2017-01-02 Thread Geert via Digitalmars-d-learn
Hi! How can i create a full database backup using mysql-native for D? https://github.com/mysql-d/mysql-native Thanks!

Re: Mysql-native with LAMPP

2016-09-12 Thread Geert via Digitalmars-d-learn
On Monday, 12 September 2016 at 15:02:50 UTC, Martin Krejcirik wrote: # netstat -npl | grep mysql unix 2 [ ACC ] STREAM LISTENING 239449 6293/mysqld /opt/lampp/var/mysql/mysql.sock Mysql defaults to unix socket, you need to add bind-address=127.0.0.1 to my.cnf

Re: Mysql-native with LAMPP

2016-09-12 Thread Martin Krejcirik via Digitalmars-d-learn
# netstat -npl | grep mysql unix 2 [ ACC ] STREAM LISTENING 239449 6293/mysqld /opt/lampp/var/mysql/mysql.sock Mysql defaults to unix socket, you need to add bind-address=127.0.0.1 to my.cnf [mysqld] section.

Re: Mysql-native with LAMPP

2016-09-12 Thread Geert via Digitalmars-d-learn
On Monday, 12 September 2016 at 14:00:18 UTC, Daniel Kozak wrote: And are you sure it is using tcp4 socket on port 3306? You can use netstat -tlnp to see if is running on tcpv4 3306 I get nothing with TCP option, only when i run this command: # netstat -npl | grep mysql unix 2

Re: Mysql-native with LAMPP

2016-09-12 Thread Daniel Kozak via Digitalmars-d-learn
wrote: Hi all! I tried the client driver for MySQL/MariaDB "mysql-native". https://github.com/mysql-d/mysql-native Everything works well with an individually installed version of MySql. But I would like to know if there is a way to make D programms work with LAMPP/XAMPP. I'

Re: Mysql-native with LAMPP

2016-09-12 Thread Geert via Digitalmars-d-learn
On Monday, 12 September 2016 at 09:59:30 UTC, wobbles wrote: On Monday, 12 September 2016 at 05:31:46 UTC, Geert wrote: Hi all! I tried the client driver for MySQL/MariaDB "mysql-native". https://github.com/mysql-d/mysql-native Everything works well with an individually installed v

Re: Mysql-native with LAMPP

2016-09-12 Thread wobbles via Digitalmars-d-learn
On Monday, 12 September 2016 at 05:31:46 UTC, Geert wrote: Hi all! I tried the client driver for MySQL/MariaDB "mysql-native". https://github.com/mysql-d/mysql-native Everything works well with an individually installed version of MySql. But I would like to know if there is a way

Mysql-native with LAMPP

2016-09-11 Thread Geert via Digitalmars-d-learn
Hi all! I tried the client driver for MySQL/MariaDB "mysql-native". https://github.com/mysql-d/mysql-native Everything works well with an individually installed version of MySql. But I would like to know if there is a way to make D programms work with LAMPP/XAMPP. I'm get

Re: Error while compiling and linking modules (mysql)

2016-09-11 Thread Geert via Digitalmars-d-learn
On Sunday, 11 September 2016 at 21:43:12 UTC, Geert wrote: Hi! I'm using a mysql wrapper (i don't even know how to use it yet) that i got from github: https://github.com/adamdruppe/arsd When i try to compile the code i get an error message: Error: module mysql is in file '

Error while compiling and linking modules (mysql)

2016-09-11 Thread Geert via Digitalmars-d-learn
Hi! I'm using a mysql wrapper (i don't even know how to use it yet) that i got from github: https://github.com/adamdruppe/arsd When i try to compile the code i get an error message: Error: module mysql is in file 'mysql.d' which cannot be read This is the folder stru

Re: Best way to convert Apachelog Datetime 01/Jan/2016:02:25:10 -> 2016-01-01 02:25:10 MySQL-Datetime Format

2016-06-08 Thread Martin Tschierschke via Digitalmars-d-learn
On Wednesday, 8 June 2016 at 10:42:19 UTC, Martin Tschierschke wrote: I know there are easy ways to handle this, anyone with a code snippet for me? I found this solution, letting the MySQL engine do the work: SELECT STR_TO_DATE('26/Apr/2011:13:21:58', '%d/%b/%Y:%H:

Best way to convert Apachelog Datetime 01/Jan/2016:02:25:10 -> 2016-01-01 02:25:10 MySQL-Datetime Format

2016-06-08 Thread Martin Tschierschke via Digitalmars-d-learn
I know there are easy ways to handle this, anyone with a code snippet for me? I would use two regex first to make 01,02,03... from Jan,Feb,.. and second to split the result. best regards mt.

Re: Question about mysql-d Object

2015-12-08 Thread Martin Tschierschke via Digitalmars-d-learn
On Tuesday, 8 December 2015 at 15:14:06 UTC, Daniel Kozak wrote: [...] >> A nested loop, did not worked either: >> >> foreach(row;rows){ >> foreach(field;row){ >> writeln(field);} >> } [...] Now I took a work around, getting the field names in a separa

Re: Question about mysql-d Object

2015-12-08 Thread Daniel Kozak via Digitalmars-d-learn
V Tue, 08 Dec 2015 14:34:53 + Martin Tschierschke via Digitalmars-d-learn napsáno: > On Monday, 7 December 2015 at 16:11:19 UTC, Daniel Kozak wrote: > > On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke > > wrote: > >> When I do the following: &g

Re: Question about mysql-d Object

2015-12-08 Thread Daniel Kozak via Digitalmars-d-learn
V Tue, 08 Dec 2015 14:34:53 + Martin Tschierschke via Digitalmars-d-learn napsáno: > On Monday, 7 December 2015 at 16:11:19 UTC, Daniel Kozak wrote: > > On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke > > wrote: > >> When I do the following: &g

Re: Question about mysql-d Object

2015-12-08 Thread Martin Tschierschke via Digitalmars-d-learn
On Monday, 7 December 2015 at 16:11:19 UTC, Daniel Kozak wrote: On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke wrote: When I do the following: auto mysql = new Mysql("localhost", 3306, "mt", "", "verwaltung"); auto rows = mysql.qu

Re: Question about mysql-d Object

2015-12-07 Thread Daniel Kozak via Digitalmars-d-learn
On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke wrote: When I do the following: auto mysql = new Mysql("localhost", 3306, "mt", "", "verwaltung"); auto rows = mysql.query("select field from my_table limit 50"); foreach(row;ro

Re: Question about mysql-d Object

2015-12-07 Thread Márcio Martins via Digitalmars-d-learn
On Monday, 7 December 2015 at 14:40:12 UTC, Martin Tschierschke wrote: When I do the following: auto mysql = new Mysql("localhost", 3306, "mt", "", "verwaltung"); auto rows = mysql.query("select field from my_table limit 50"); foreach(row;ro

Question about mysql-d Object

2015-12-07 Thread Martin Tschierschke via Digitalmars-d-learn
When I do the following: auto mysql = new Mysql("localhost", 3306, "mt", "", "verwaltung"); auto rows = mysql.query("select field from my_table limit 50"); foreach(row;rows){ writeln(row["field"]);} // second time same loop foreac

Re: mysql-native: SQL Transaction support?

2015-09-18 Thread salvari via Digitalmars-d-learn
On Thursday, 17 September 2015 at 21:19:07 UTC, Gary Willoughby wrote: On Thursday, 17 September 2015 at 19:47:33 UTC, salvari wrote: I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours to load data. I've

Re: mysql-native: SQL Transaction support?

2015-09-17 Thread Gary Willoughby via Digitalmars-d-learn
On Thursday, 17 September 2015 at 19:47:33 UTC, salvari wrote: I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours to load data. I've used mysql-native before to handle hundreds of millions of rows of

mysql-native: SQL Transaction support?

2015-09-17 Thread salvari via Digitalmars-d-learn
I'm using mysql-native library for massive data load. I've been trying to use transactions to improve performance but it doesn't seem to work. I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours

Re: ddbc: MySQL/MariaDB: Access Violation

2015-05-20 Thread TiberiuGal via Digitalmars-d-learn
this" is executed, that's why you get access violation ( it has nothing to do with permissions ). The solution is to use main(). here are some reported issues related to the problem you have described. https://github.com/mysql-d/mysql-native/issues/53 https://github.com/rejectedsoftware/vibe.d/issues/906

Re: ddbc: MySQL/MariaDB: Access Violation

2015-05-20 Thread Vadim Lopatin via Digitalmars-d-learn
On Monday, 18 May 2015 at 18:54:20 UTC, Suliman wrote: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; p.s. this command return my: "Affected rows: 0 " Do you see some stack trace on crash? No. I checked on 2 PC and it's not look like my issue, because

Re: ddbc: MySQL/MariaDB: Access Violation

2015-05-18 Thread Suliman via Digitalmars-d-learn
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; p.s. this command return my: "Affected rows: 0 " Do you see some stack trace on crash? No. I checked on 2 PC and it's not look like my issue, because result is totally same. If I change void main() to vibe

Re: ddbc: MySQL/MariaDB: Access Violation

2015-05-18 Thread Suliman via Digitalmars-d-learn
still can't get it's work :(

Re: ddbc: MySQL/MariaDB: Access Violation

2015-05-18 Thread Vadim Lopatin via Digitalmars-d-learn
On Sunday, 17 May 2015 at 10:24:43 UTC, Suliman wrote: I am using this driver for access to MariaDB http://code.dlang.org/packages/ddbc The problem that it's work fine when it's used from desktop App, but when I try to run it's from vibed app i get "Access Violation". In my.ini I added string

ddbc: MySQL/MariaDB: Access Violation

2015-05-17 Thread Suliman via Digitalmars-d-learn
I am using this driver for access to MariaDB http://code.dlang.org/packages/ddbc The problem that it's work fine when it's used from desktop App, but when I try to run it's from vibed app i get "Access Violation". In my.ini I added string: bind-address = 127.0.0.1 Also I run next command:

Re: Mysql - Sql things ?

2013-08-01 Thread Larry
On Wednesday, 31 July 2013 at 12:09:02 UTC, David wrote: https://github.com/rejectedsoftware/mysql-native Waw ! Many thanks, Completely missed it :) See you

Re: Mysql - Sql things ?

2013-07-31 Thread David
https://github.com/rejectedsoftware/mysql-native

Mysql - Sql things ?

2013-07-31 Thread Larry
Hello, I was searching the web for anything relating D to mysql but didn't find my way. Is it on the roadmap to add mysql support ? There is a c++ connector on debian, but no mention of a D connector.. Thanks, Larry

Re: Using MySql with D on Mac OS 10.8

2013-05-17 Thread Jacob Carlborg
On 2013-05-17 14:00, Gary Willoughby wrote: Are there any decent wrappers available for D to allow me to read data from a file and place it into a MySql database. I'm using Mac OS 10.8. Is there an official library? Has anyone used MySql with D on Mac OS? Check this out:

Using MySql with D on Mac OS 10.8

2013-05-17 Thread Gary Willoughby
Are there any decent wrappers available for D to allow me to read data from a file and place it into a MySql database. I'm using Mac OS 10.8. Is there an official library? Has anyone used MySql with D on Mac OS? Thanks.

Re: mysql

2013-04-17 Thread simendsjo
On Tuesday, 16 April 2013 at 21:09:42 UTC, gedaiu wrote: On Monday, 15 April 2013 at 19:25:19 UTC, simendsjo wrote: On Monday, 15 April 2013 at 17:34:07 UTC, gedaiu wrote: Hi, Can anyone help me to connect to mysql from D? Thanks! You can use Steve Teales native library. The most up-to

Re: mysql

2013-04-17 Thread Rob T
On Tuesday, 16 April 2013 at 21:09:42 UTC, gedaiu wrote: On Monday, 15 April 2013 at 19:25:19 UTC, simendsjo wrote: On Monday, 15 April 2013 at 17:34:07 UTC, gedaiu wrote: Hi, Can anyone help me to connect to mysql from D? Thanks! You can use Steve Teales native library. The most up-to

Re: mysql

2013-04-16 Thread gedaiu
On Monday, 15 April 2013 at 19:25:19 UTC, simendsjo wrote: On Monday, 15 April 2013 at 17:34:07 UTC, gedaiu wrote: Hi, Can anyone help me to connect to mysql from D? Thanks! You can use Steve Teales native library. The most up-to-date version is here: https://github.com/rejectedsoftware

Re: mysql

2013-04-15 Thread simendsjo
On Monday, 15 April 2013 at 17:34:07 UTC, gedaiu wrote: Hi, Can anyone help me to connect to mysql from D? Thanks! You can use Steve Teales native library. The most up-to-date version is here: https://github.com/rejectedsoftware/mysql-native It relies on vibes async sockets though. You&#x

mysql

2013-04-15 Thread gedaiu
Hi, Can anyone help me to connect to mysql from D? Thanks!

Re: Frustration [Was: mysql binding/wrapper?]

2012-05-10 Thread #coder
I found a bug in the code. If you don't specify the password for your test mySQL server then the mysql.d fails. It is always expecting a password and on empty password it throws the exception. file: mysql.d function: open [line 1415] I think when it calls _socket.send then it fails. So

Re: mysql binding/wrapper?

2012-05-01 Thread SomeDude
some common functions with other db providers.) That's it though, D wise. It also uses the mysql C library so you'll need libmysql on your system for it to link too. Would you mind if the module was added to vibe, and thus relicensed to MIT? No idea if the vibe folks would actually

Re: Frustration [Was: mysql binding/wrapper?]

2012-05-01 Thread SomeDude
ng it compiled. If you end up succeeding, maybe you can propose him to update his file, so that we can benefit ? Looking at his code, it seems to me that he is very far from the original goal, which was to make a generic database driver. This one seems completely linked to MySQL and will need

Re: Frustration [Was: mysql binding/wrapper?]

2012-05-01 Thread SomeDude
ropose him to update his file, so that we can benefit ? Looking at his code, it seems to me that he is very far from the original goal, which was to make a generic database driver. This one seems completely linked to MySQL and will need to be completely rewritten for Postgres. Am I wrong ?

Re: Frustration [Was: mysql binding/wrapper?]

2012-05-01 Thread simendsjo
On Tue, 01 May 2012 04:04:01 +0200, Ary Manzana wrote: It's sad. I always want to give D a chance. And when I do I always bump into errors and inconveniences. (...) Every time I want to start coding in D, or helping some project, I stumble into all kind of troubles. I have the same feelin

Frustration [Was: mysql binding/wrapper?]

2012-04-30 Thread Ary Manzana
On 5/1/12 2:44 AM, simendsjo wrote: On Mon, 30 Apr 2012 20:55:45 +0200, Ary Manzana wrote: Looking at the code of mysql.d I see a big switch with many cases like "case 0x01: // TINYINT". But then there's the SQLType enum with those constants. Why the enum values are not used in the cases? (and

Re: mysql binding/wrapper?

2012-04-30 Thread simendsjo
On Mon, 30 Apr 2012 20:55:45 +0200, Ary Manzana wrote: Looking at the code of mysql.d I see a big switch with many cases like "case 0x01: // TINYINT". But then there's the SQLType enum with those constants. Why the enum values are not used in the cases? (and also in other parts of the co

  1   2   >