That’s a pretty useful plug though! It’s kind of funny that after I reviewed the file I found myself agreeing with everything in it and I had like 95% the same ideas. I take it as a compliment. 
Thank you, this has been both enlightening and reassuring at the same time.
dimitarvp
1
dimitarvp
You are far ahead of me. Pooling I’ll delegate to db_connection – which I need to do when I get to the Ecto 3.1+ adapter anyway so, you know, double win. I’ll prefer configuration that’s local for each sqlite DB handle.
Like @LostKobrakai and @wojtekmach, I believe OTP wiring should not be mandatory unless it is absolutely technically unavoidable. To me it’s just a way to have the users of the library follow a 2-3 step tutorial on the library’s GitHub README page and have all their databases automatically managed by OTP while they only call an API that takes an atom name instead of an sqlite handle as a first argument. They can just as easily never register the GenServer wrapper I’ll provide in the library under their app’s Supervisor and use their own way to manage multiple sqlite handles, like a process dict, application configuration, ETS, or whatever else.
Speaking of that though, I figure (both by myself and reading yours and the other guys’ comments) that having a pure FP structure one can pass around should be the default and the bare minimum a library provides. Having any kind of OTP wiring should just be a convenience in terms of “how do I have something else manage all my NIF handles and I just call this API with names of the handles I choose and not care how it all happens under the hood”.
So if you don’t have a pure FP data structure that can be passed around then I’d say go for that and make processes optional.
Same as my reasoning. Coming from 15 years of imperative and OOP languages before Elixir, I am avoiding surprise mechanics like the plague. Thanks for validation! 
2
dimitarvp
Not sure mine and your point of view contradict each other. To me making a thin GenServer wrapper that the user of the library can plug into their app’s Supervisor is exactly to “plug things into the places they belong” (with the caveat that the user does not want to only pass a self-contained state structure around; if they are not satisfied by that then IMO a thin OTP wiring is quite a good way to go beyond the pure FP approach).
Unless I am reading you wrong?
I realise that my library, when ready, can be criticised that it comprises of 3 parts in one instead of having 1 base library and 2 plugins for it (baseline: sqlite client, plugins: OTP wiring and Ecto 3.1+ adapter) but it’s my personal programmer philosophy that having 30KB extra .beam files is worth the reduced complexity, as opposed to every user of the library having to manually wire the core library with its plugins – which might turn out to be an error-prone process and ruin the experience.
So I prefer to give you a library with some batteries included, provided the batteries are strictly opt-in and aren’t forcing you to deal with them even when you don’t need them.
If the batteries grow too big though then I’ll reconsider breaking the library down to smaller components. I believe it’s too early to over-optimise like this just yet though.
1
OvermindDL1
What I try to do is:
-
If a standalone application, then put the configs in the application environment along with a function to call to have it perform things that it needs notifications about (like pool size), with override on individual function calls when appropriate.
-
If a set of GenServer’s then default application environment with override of options passed to start_link with override on individual function calls when appropriate, with a needed function call to have it be notified of config changes on things like pool size or whatever.
-
If loose modules then default application environment with override of options on individual function calls when appropriate.
In addition, if defaults don’t exist in the application environment then it should call a ‘provider’ (whatever that is, database, system environment, a remote server, whatever) to populate the application environment values.
I want a library to make all this pattern work, yes it will require a lot of macro magic to not balloon to huge amounts of user code, but still, it should be simple to use, inline, no annoying large schema definitions just for function options, etc…
1
dimitarvp
Sounds like yet another library you aren’t going to write. 
But otherwise, I partially agree. The part I wouldn’t do is to invest a lot in config providers – at least for now. Another thing I wouldn’t do is application environment – it’s unsuitable for libraries.
The priority order is going to be a self-sufficient structure containing both DB handle and configuration and if you find that annoying, you’ll be able to pass that configuration via start_link in a thin GenServer wrapper and not think about configurations and DB handles.
0
OvermindDL1
Oh how I wish I had infinite free time… ^.^;
But yes, that is why I described it, so maybe someone else will make it. 
That would be nothing but a simple interface/behaviour, I wouldn’t expect anything more complicated then reading from the system environment being included with it, most of the times these are very platform-dependent.
Libraries should still always register an application, it makes handling updates far cleaner, and by registering an application they still get an application environment, even if the application is otherwise empty.
But for example, I wrote my task_after | Hex library in this way.
1
dimitarvp
OvermindDL1
It doesn’t need to, just when you need to use a configuration thing just do Application.get_env/3. This is all Erlang stuff, not even Elixir. 
0
dimitarvp
Nope, still don’t want to! I am making a DB access library after all; everything in it should be configurable per connection / NIF handle. There’s simply no place for any global configuration there.
1
OvermindDL1
Only defaults, unless you want to force the user to pass in every configuration when needed, which is of course possible too if a bit wordy at times (though explicit is clear!). ^.^
1