Client API prepared statements

Asked by Barry Leslie on 2008-12-17

It looks like the drizzle client api has no equivalent of mysql_stmt_prepare(). How do you insert binary data into tables?

Question information

Language:
English Edit question
Status:
Answered
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Last query:
2010-04-27
Last reply:
2010-04-27
Brian Aker (brianaker) said : #1

Escape the strings and store the data in the INSERT statement (same as MySQL). mysql_stmt_prepare() is discouraged in MySQL because it tends to lead to server crashes (so all drivers have disabled it at this point).

We will be coming up with a new method around doing the above.

karl.strom (cellofancello) said : #2

I have some downloaded python and for ex.elipse ,but nothing funktion.
Perheps I need to pey forit ,but I have Borland C++ and C and others.
Why can I not use anything yet.
I have Visual basic and othets but no good idea to try them under linux Mint .WHY are an amateur bu in windows I can use wort ever I wont.
Karl

karl.strom (cellofancello) said : #3

Why cant I use c++ or worth ever.
Karl

karl.strom (cellofancello) said : #4

Do you wont me to answer my one question ?
Karl

Jay Pipes (jaypipes) said : #5

Drizzle is not built for Windows. You don't need to pay for anything, but we do not currently support Windows. We support the following platforms:

32 and 64 bit:

Linux
FreeBSD
Solaris/OpenSolaris
MacOSX

karl.strom (cellofancello) said : #6

Thank's !
I dont use microsoft windows
Karl

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #54683]: Client API prepared statements
> Date: Wed, 25 Nov 2009 17:19:52 +0000
>
> Question #54683 on Drizzle changed:
> https://answers.launchpad.net/drizzle/+question/54683
>
> Jay Pipes proposed the following answer:
> Drizzle is not built for Windows. You don't need to pay for anything,
> but we do not currently support Windows. We support the following
> platforms:
>
> 32 and 64 bit:
>
> Linux
> FreeBSD
> Solaris/OpenSolaris
> MacOSX
>
> --
> You received this question notification because you are a direct
> subscriber of the question.

_________________________________________________________________
Lagra alla dina foton på Skydrive. Det är enkelt och säkert!
http://www.skydrive.live.com

Jay Pipes (jaypipes) said : #7

OK, I'm sorry I don't understand your question, then. What are you asking for help with? Setting up Drizzle on Linux?

Please check out the following wiki pages:

http://drizzle.org/wiki/Compiling
http://drizzle.org/wiki/Starting_drizzled

Cheers,

jay

karl.strom (cellofancello) said : #8

I' m useing linuxmint not microsoft windows
Thank's

> To: <email address hidden>
> From: <email address hidden>
> Subject: Re: [Question #54683]: Client API prepared statements
> Date: Wed, 25 Nov 2009 17:19:52 +0000
>
> Question #54683 on Drizzle changed:
> https://answers.launchpad.net/drizzle/+question/54683
>
> Jay Pipes proposed the following answer:
> Drizzle is not built for Windows. You don't need to pay for anything,
> but we do not currently support Windows. We support the following
> platforms:
>
> 32 and 64 bit:
>
> Linux
> FreeBSD
> Solaris/OpenSolaris
> MacOSX
>
> --
> You received this question notification because you are a direct
> subscriber of the question.

_________________________________________________________________
Hitta hetaste singlarna på MSN Dejting!
http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952

Jobin Augustine (jobinau) said : #9

Hi Karl,

after going though your mails, i assumes that you are new to opensource.

the Linux distribution you are using (Linuxmint) is just a ubuntu clone. and it is binary compatible with ubuntu.
many of the drizzle fans like me are using ubuntu without any problem.
so drizzle should work without any problem in Linuxmint.

drizzles team uses GNU C++ (g++) compiler and other GNU tools.
so you don't need to buy or pay for a c++ complier. it is there in your Linux distribution.
just need to make sure that all requied softwares libaries are installed.

there are the packages / libraries you need to intall for compiling the drizzle source. please refere following link
http://drizzle.org/wiki/Compiling#Resolving_Package_Dependencies

there is a program called "synaptic package manger" in Linuxmint which can be used to install all requied software and libaries.
its a matter of few mouse clicks if you are connected to internet.

please watch this youtube video if you are not familier with installing softwares in Linuxmint.
http://www.youtube.com/watch?v=0LmuQEVDznk

Welcome to open and free world of sofwares!.
Let your brain childs (ideas and softwares) live longer !

jobin.

karl.strom (cellofancello) said : #10

Thank's
It is nice and good edvices from You, and friendly !!
Trubble wit my ordinary e-mail ,so I use this.
Sinserly Yours
Karl

> To: <email address hidden>
> From: <email address hidden>
> Subject: RE: [Question #54683]: Client API prepared statements
> Date: Mon, 30 Nov 2009 06:07:21 +0000
>
> Question #54683 on Drizzle changed:
> https://answers.launchpad.net/drizzle/+question/54683
>
> Jobin Augustine proposed the following answer:
> Hi Karl,
>
> after going though your mails, i assumes that you are new to opensource.
>
> the Linux distribution you are using (Linuxmint) is just a ubuntu clone. and it is binary compatible with ubuntu.
> many of the drizzle fans like me are using ubuntu without any problem.
> so drizzle should work without any problem in Linuxmint.
>
> drizzles team uses GNU C++ (g++) compiler and other GNU tools.
> so you don't need to buy or pay for a c++ complier. it is there in your Linux distribution.
> just need to make sure that all requied softwares libaries are installed.
>
> there are the packages / libraries you need to intall for compiling the drizzle source. please refere following link
> http://drizzle.org/wiki/Compiling#Resolving_Package_Dependencies
>
> there is a program called "synaptic package manger" in Linuxmint which can be used to install all requied software and libaries.
> its a matter of few mouse clicks if you are connected to internet.
>
> please watch this youtube video if you are not familier with installing softwares in Linuxmint.
> http://www.youtube.com/watch?v=0LmuQEVDznk
>
> Welcome to open and free world of sofwares!.
> Let your brain childs (ideas and softwares) live longer !
>
> jobin.
>
> --
> You received this question notification because you are a direct
> subscriber of the question.

_________________________________________________________________
Nya Windows 7 - Hitta en dator som passar dig! Mer information.
http://windows.microsoft.com/shop

Vahaber (alphagoblin4) said : #11

THanx a lot!!
cuz i had the same problem!!

Barry Leslie (barry-leslie) said : #12

Hi,

Did you get a chance to look at
lp:~barry-leslie/drizzle/drizzle_events ?

Any comments or suggestions?

Barry

-------------------------------------------------------------------------
Barry Leslie

SNAP Innovation Softwareentwicklung GmbH
Senior Software Engineer

Tel: (001) 250 884 1820
Fax: (001) 250 595 4460
Email: <email address hidden>
Web: www.PrimeBase.com

SNAP Innovation Softwareentwicklung GmbH, D-22765 Hamburg,
Max-Brauer-Allee 50, Germany
Amtsgericht Hamburg HRB 61066, Geschäftsführer: Ulrich Zimmer, Paul
McCullagh
-------------------------------------------------------------------------

Jay Pipes (jaypipes) said : #13

For the most part, I really like what you've done so far, Barry! Nice work :)

Please do propose it for merging so we can do a full code review on
Launchpad and go through a couple iterations with you :)

Cheers!

jay

On Tue, Apr 27, 2010 at 12:52 PM, Barry Leslie
<email address hidden> wrote:
> Hi,
>
> Did you get a chance to look at
> lp:~barry-leslie/drizzle/drizzle_events ?
>
> Any comments or suggestions?
>
> Barry
>
> -------------------------------------------------------------------------
> Barry Leslie
>
> SNAP Innovation Softwareentwicklung GmbH
> Senior Software Engineer
>
> Tel: (001) 250 884 1820
> Fax: (001) 250 595 4460
> Email: <email address hidden>
> Web: www.PrimeBase.com
>
> SNAP Innovation Softwareentwicklung GmbH, D-22765 Hamburg,
> Max-Brauer-Allee 50, Germany
> Amtsgericht Hamburg HRB 61066, Geschäftsführer: Ulrich Zimmer, Paul
> McCullagh
> -------------------------------------------------------------------------
>
>
>
>

Can you help with this problem?

Provide an answer of your own, or ask Barry Leslie for more information if necessary.

To post a message you must log in.