Is there a header only code I can include in my program to make it possible to connect and interact with mysql? I hate dealing with dependencies and shared libs, it's always a nightmare as from system to system you never know what issues you'll run into at compile or run time. I just want something that is purely code, no libs, and that just works and I just include in my program so that my program can be dropped on any machine and compile and work with no issues.

I'm even thinking of writing my own if such thing does not exist, I'd have to find some specs on how the protocol works at the tcp/ip level though.

I'm trying to get mysql++ to work with a program on my server and since I migrated to a new server it just refuses to work properly. I just hate dealing with shared libs and wasting time getting them to work, I just want to get to coding. So is there such library out there that is strictly a header that I can include? If not, where can I find info on the mysql protocol so I can write my own?

Hi,

if you don't want to use shared libraries you can statically link.

Evo2.

1 members found this post helpful.

I've been trying to figure out how to do that but so far no luck. When I bring the binary on another system it's still looking for the libraries to be at a very specific spot.

ex:

This is the string I'm using, is there a better way?

Hi,

you need the static versions of the libraries installed on the build machine (the .a files which usually come with the -dev package that provides the headers) and you need to use the -static option.

See for example:
http://www.linuxquestions.org/questi...raries-696714/

HTH,

Evo2.

How do I tell it to use the static files? Ex: What would I change in my compile string? What happens if the package does not come with .a files?

I did a /usr wide search on the dev machine to see what I could find and this is what I found:

/usr/lib64/mysql/libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient.so.18
/usr/lib64/mysql/libmysqlclient.so.18.0.0
/usr/lib64/mysql/libmysqlclient.so.16.0.0


So am I out of luck for that specific lib? Can I just copy it over to the other system to the same location or is that going to cause issues? It does exist on the other system but it's not at the same place, which is often the cause of issues with this whole shard library thing. It would be nice if there was a standard place for them.

You should have to have a file called libmysqlclient.a somewhere (the location depends on your distribution)