Hi Rinigus,
Did you consider this recommendation?
"To simplify matters, SQLite is also available as a pre-packaged amalgamation
source code file: sqlite3.c. The amalgamation is a single file of ANSI-C code
that implements the entire SQLite library. The amalgamation is much easier to
deal with. Everything is contained within a single code file, so it is easy to
drop into the source tree of a larger C or C++ program. [...] For these
reasons, the amalgamation source file ("sqlite3.c") is recommended for all
applications."[1]
What are the reasons that prevent you from using the upstream recommended
approach? Are they worth your time and effort?
Thinking out loud: If an application (in its packaged form) is to be supported
on a variety of devices and (future) OS releases all its dependencies must be
satisfied in these environments. In order to make both the OS/devices vendors'
and app developers' life easier in this respect a minimal necessary subset of
all the APIs provided by the OS (at particular time) is defined that is
guaranteed to be universally available in some time frame. Feel free
(encouraged!) to use any other dependencies, even those completely missing in
the OS (yet), bundling these together with your application! Only where this is
not possible and/or implies an excessive effort and/or adds dozens of megabytes
etc. it is worth to wait for Harbour rules to change.
BR,
Martin
[1]
https://www.sqlite.org/howtocompile.html#amalgamation_versus_individual_source_files
________________________________
From: Devel [devel-boun...@lists.sailfishos.org] on behalf of rinigus
[rinigus....@gmail.com]
Sent: Saturday, March 04, 2017 2:46 PM
To: Sailfish OS Developers
Subject: Re: [SailfishDevel] SQLite linking
Hi,
thank you very much for the response and explanation. Looking forward to see
the new whitelist / harbour rules. Its fine to take time to do it properly,
thanks for the feedback.
Best wishes,
Rinigus
On Sat, Mar 4, 2017 at 3:15 PM, Andrew Branson
<andrew.bran...@jolla.com<redir.aspx?REF=IEvGy8dwNBPiyEWeDIPWRj1HVzqPtTv1lqbdu-QEZ6WBKCPJY2TUCAFtYWlsdG86YW5kcmV3LmJyYW5zb25Aam9sbGEuY29t>>
wrote:
Hi,
I've had a look internally about this, and it's caught up in a larger overhaul
of the whitelist and harbour rules aiming to make development more attractive
to developers while remaining maintainable. This is part of the reason you
haven't had any feedback yet, but also everyone's got caught up in the huge
amount of work lately that you've now seen some news about.
It's not great when external PRs and bugs on the merproject bugzilla appear to
look dead because they're blocked internally but not visibly, especially when
someone's taken the time and trouble to investigate and submit something. Sorry
about that. Even if the internal progress on such things can't be made public,
an acknowledgement would be nice. The apparent silence doesn't mean your
efforts aren't appreciated nor influential.
Hope that helps a bit,
Andrew
On Saturday, 4 March 2017, rinigus wrote:
> Re OpenRepos: Sure, and I do. And through bundling I am publishing @Harbour.
> But the main issue is the lack of response for a rather simple request. Even
> a negative response is a response.
>
>
> Sorry for complains. Enjoy the weekend and let's see if Jolla devs would
> respond during the work hours :)
>
>
> rinigus
>
>
> On Sat, Mar 4, 2017 at 2:22 PM, Marcin Mielniczuk
> <marmistrz...@gmail.com<redir.aspx?REF=s6Jft6uOf3T8GunBizEm5Jm7ySCM2o2L0UMz0FsClHmBKCPJY2TUCAFtYWlsdG86bWFybWlzdHJ6bWFyQGdtYWlsLmNvbQ..>>
> wrote:
>
> You can always use OpenRepos...
>
>
>
> On March 4, 2017 8:50:37 AM GMT+01:00, rinigus
> <rinigus....@gmail.com<redir.aspx?REF=S3uDHYViRHtcIysY7C9dUy6JiwlaDEbsq8CeEVHU6-SBKCPJY2TUCAFtYWlsdG86cmluaWd1cy5naXRAZ21haWwuY29t>>
> wrote:
> Hi,
>
>
> one month + 10 days later - no response for PR nor SQLite linking from
> Harbour / Jolla devs. Already had to ship few versions with SQLite bundled
> with application as well. I'd say its rather poor response times already now
> (with the response time not reached yet).
>
>
> Rinigus
>
>
>
>
> On Wed, Jan 18, 2017 at 4:30 PM, rinigus
> <rinigus....@gmail.com<redir.aspx?REF=S3uDHYViRHtcIysY7C9dUy6JiwlaDEbsq8CeEVHU6-SBKCPJY2TUCAFtYWlsdG86cmluaWd1cy5naXRAZ21haWwuY29t>>
> wrote:
>
> Slava,
>
>
> thank you for this constructive suggestion. I submitted PR
> https://github.com/sailfish-sdk/sdk-harbour-rpmvalidator/pull/86<redir.aspx?REF=jz7NO07vOY3xf_dlkaBrMfGfiO2rzQZiXZGBiZ-KYzuBKCPJY2TUCAFodHRwczovL2dpdGh1Yi5jb20vc2FpbGZpc2gtc2RrL3Nkay1oYXJib3VyLXJwbXZhbGlkYXRvci9wdWxsLzg2>
> to add sqlite into the list of allowed libraries. Hopefully, it will be
> accepted.
>
>
> Best wishes,
>
>
> Rinigus
>
>
> On Wed, Jan 18, 2017 at 3:29 PM, Slava Monich
> <slava.mon...@jolla.com<redir.aspx?REF=wBd98ninqRmMYped8tBTAWtpl98Yoe8D5SR64yVqi3qBKCPJY2TUCAFtYWlsdG86c2xhdmEubW9uaWNoQGpvbGxhLmNvbQ..>>
> wrote:
>
> I believe rpm automatically detects the dependencies, even if they are not in
> the spec. Removing the dependency from the spec might not help. There may be
> some hackish ways of removing a dependency from the rpm headers but I don't
> think that it would be a good idea. Better to spend time on hacking something
> more useful than that.
>
> Another approach is to load the library with dlopen, e.g.
> https://github.com/monich/harbour-books/blob/master/app/stubs/libmagic.c<redir.aspx?REF=J4jdRBZxixGtPud85EP-9fdq0I-xkQ5mlw_5lT-YmvWBKCPJY2TUCAFodHRwczovL2dpdGh1Yi5jb20vbW9uaWNoL2hhcmJvdXItYm9va3MvYmxvYi9tYXN0ZXIvYXBwL3N0dWJzL2xpYm1hZ2ljLmM.>
> This allows you to get around the harbour limitations and yet in every other
> respect it's as good as linking with the system library. Of course by doing
> so you assume the risk of using the unsupported api. Obviously, this kind of
> trick should only be done to very stable libraries that are extremely
> unlikely to disappear from the system and have a proven track record of
> evolving in a backward compatible manner.
> I think the best solution is to add sqlite3 to allowed_libraries.conf and
> submit a pull request:
> https://github.com/sailfish-sdk/sdk-harbour-rpmvalidator/blob/master/allowed_libraries.conf<redir.aspx?REF=1XOqNgbss4QKKLDTica-WYJZQ6xnU0ziq1QoV2yavumBKCPJY2TUCAFodHRwczovL2dpdGh1Yi5jb20vc2FpbGZpc2gtc2RrL3Nkay1oYXJib3VyLXJwbXZhbGlkYXRvci9ibG9iL21hc3Rlci9hbGxvd2VkX2xpYnJhcmllcy5jb25m>
>
> Cheers,
>
> -Slava
>
>
>
>
>
> Is the automatic checker not allowing it through with sqlite3 as a
> requirement? Are you sure that you used the packagename used on jolla systems
> for the requirement?
>
>
> During deployment as RPM, the specific error is
>
>
> Requires
> ========
> ERROR [libsqlite3.so.0] Cannot require shared library: 'libsqlite3.so.0'
> INFO [harbour-osmscout-server] Please see our FAQ here:
> https://harbour.jolla.com/faq#2.6.0<redir.aspx?REF=cetyL03AO4xhXp37DEjWv0prJ4mXaJ81nfTUr5lN9S2BKCPJY2TUCAFodHRwczovL2hhcmJvdXIuam9sbGEuY29tL2ZhcSMyLjYuMA..>
> how to use '__provides_exclude_from' and '__requires_exclude' .spec file to
> avoid that
> FAILED
>
>
> earlier versions of this app were published in the store without any issues.
> Its a part of the app evolution to require sqlite3 for its function, at least
> for a time being.
>
>
> I agree that static linking of sqlite3 is not necessary and can be considered
> as a bloat. Hence my question :)
>
>
> rinigus
>
>
>
> _______________________________________________
> SailfishOS.org Devel mailing list
> To unsubscribe, please send a mail to
> devel-unsubscr...@lists.sailfishos.org<redir.aspx?REF=zpIjCWZdNpWN6GgaUhiGJ7yh1-7wxzCqteS2hfH0sEyBKCPJY2TUCAFtYWlsdG86ZGV2ZWwtdW5zdWJzY3JpYmVAbGlzdHMuc2FpbGZpc2hvcy5vcmc.>
>
>
>
> _______________________________________________
> SailfishOS.org Devel mailing list
> To unsubscribe, please send a mail to
> devel-unsubscr...@lists.sailfishos.org<redir.aspx?REF=zpIjCWZdNpWN6GgaUhiGJ7yh1-7wxzCqteS2hfH0sEyBKCPJY2TUCAFtYWlsdG86ZGV2ZWwtdW5zdWJzY3JpYmVAbGlzdHMuc2FpbGZpc2hvcy5vcmc.>
>
>
>
>
>
>
>
> --
>
> Sent from my mobile. Please excuse my brevity.
>
>
--
Sent from my Jolla
_______________________________________________
SailfishOS.org Devel mailing list
To unsubscribe, please send a mail to
devel-unsubscr...@lists.sailfishos.org<redir.aspx?REF=zpIjCWZdNpWN6GgaUhiGJ7yh1-7wxzCqteS2hfH0sEyBKCPJY2TUCAFtYWlsdG86ZGV2ZWwtdW5zdWJzY3JpYmVAbGlzdHMuc2FpbGZpc2hvcy5vcmc.>
_______________________________________________
SailfishOS.org Devel mailing list
To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org
