← Back to team overview

maria-developers team mailing list archive

Re: Some clarifications requested for C client

 

Could I ask for a reply here - in particular to the 2nd point about SQLite?
What is the advantage of having the SQLite codebase as part of the MariaDB
C-API as compared to getting the SQLite library from the official SQLite
webiste and link in an application?

If there is more to it than just *including the SQLite codebase*
(functionalities of any kind added due to this), then some
explanation/documentation would be nice.

-- Peter Laursen (Webyog)


On Sun, Aug 25, 2013 at 3:25 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>wrote:

> This is probably for Georg Richter (and/or @Wlad). I have a few qeustion!
>
>
> 1)
>
> https://bazaar.launchpad.net/~maria-captains/mariadb-native-client/trunk/revision/80
> "Fix for CONC-44: LOAD DATA INFILE can't open utf16le encoded filenames"
> But we we can stil not specify UTF16LE as the CHARSET, I think?
>
> Say I have a file *named* "ÄÜÑБГД.csv".  (both Western special characters
> and cyrillic characters in the file name). This file I  will be able to
> read now (using revision 80), right?
>
> But if file *content* is this single line (one row, two columns)
>
> ÄÜÑ,БГД
>
> and if it is encoded as 'Windows Unicode'/utf16le I still will need to
> recode the file to utf8 before executing it with LOAD DATA (as UTF16LE
> still cannot be specified for CHARSET in LOAD DATA), right?
>
> Please confirm that I understand this!
>
>
> 2)
>
> https://bazaar.launchpad.net/~maria-captains/mariadb-native-client/trunk/revision/32
> "Added support for embedded (sqlite)".
> This happened by beginning of this year but I just noticed now.
>
> Now what can we actually do with SQLite and the MariaDB C-API and what we
> the purpose of this revision? Is it to make it easier to write client
> applications using SQLite for internal storage? Or to make the C client
> code 'a generic API' for connecting to both MySQL (of all flavors) and
> SQLite? Is the the code/files that that were added different from offical
> SQLite downloads from http://www.sqlite.org/? I am not able to find any
> documentation anywhere.  Also not a blog or whatever either. There must be
> some reason to add sqlite3 code?!
>
>
>
> 3)
> This seems to be the latest revision:
>
> https://bazaar.launchpad.net/~maria-captains/mariadb-native-client/trunk/revision/81
> "Added dyamic column api; Added character set conversion"
> ('dyamic' is misspelled BTW!)
>
> Won't we need some documentation here? The claim that MariaDB's connector
> "has exactly the same API as the MySQL Connector/C for MySQL 5.5" (
> https://kb.askmonty.org/en/mariadb-client-library-for-c/) cannot be true
> now as it adds funtionalities for managing MariaDB ' dymamic column waht
> oracle's API has not? The API from Oracle's library is now a *subset* or
> MariaDB API (or MariaDB's is a *superset* or Oracle). So much I can figure
> out, but should I need to code with it I would need description of
> functions' syntax, expected results and error listings.
>
> Also I am not able to figure out what the "character set conversion"
> referred to is doing and why it was added.
>
>
> 4)
> Why does the changelog here
> https://kb.askmonty.org/en/mariadb-client-library-for-c-100-changelog/stop at revision 77?
>
>
> -- Peter Laursen
> -- Webyog
>

References