DevHeads.net

SQL Query tool - incubator

Hi all,

i would like to check if there is some interest into including SQL tool
into KDE and helping with development. So far the project has (had) two
developers, me and asw-dev (from github, do not know his actual name).

This was started because, afaik, there is no application in Qt5 that fits
into KDE that provides this functionality.

Anyhow, the code and how it looks like is here:
<a href="https://github.com/mispp/goat" title="https://github.com/mispp/goat">https://github.com/mispp/goat</a>
Some things are missing, some things are not working best, but overall it
does work.

Incubator requirements, per point:

- Compliance with the KDE Manifesto -> this is currently hosted on
github, but it is not a problem to move it to kde infrastructure (gitlab)
- Governance similar to the other KDE projects -> i cant really judge
this since this has been a small effort. what does this exactly mean?
- Clear product vision -> product vision is described in readme. not
sure if this enough.
- Healthy team (healthy proportion of volunteers, inclusive towards new
contributors, ideally more than one developer) -> this is one of the
issues. reason for reaching out is lack of developer time.
- Uses English for code and communication -> ok
- Continuity agreement must be in place with KDE e.V. for domains and
trademarks if the authors disappear -> ok
- Recommended to attend Akademy -> this generally is ok, but cannot
promise since i have to take days off for this.

According to asw-dev, it is ok to put it into KDE incubator if the license
stays the same (GPLv3), so this could be a potential issue i guess.

Let me know what you think.

BR, Miroslav.

Comments

Re: SQL Query tool - incubator

By Albert Astals Cid at 08/13/2019 - 17:06

El divendres, 9 d’agost de 2019, a les 14:45:23 CEST, Miroslav Špehar va escriure:
Your code doesn't build.

CMake Error at CMakeLists.txt:19 (add_executable):
Cannot find source file:

src/ConnectionStandardItem.cpp

It means that once you joing KDE it's not yours anymore, it's ours, because you are now us.

Having a small team is "ok but not great".

But what's not going to happen for you importing your code to KDE's gitlab is that suddenly you get 10 new contributors (unless you do some noise about the app and sell it to developers) everyone here is already very busy.

I see that the last "code" commit was 10 months ago, that makes me a bit scared to be honest.

Cheers,
Albert

Re: SQL Query tool - incubator

By =?UTF-8?Q?Miros... at 08/14/2019 - 07:24

Hi Albert,

Probably not with cmake. I tried to convert .pro into cmake, but didnt
manage to do it since i never touched cmake before.
To be honest, i actually do not need cmake since qmake works just
fine, so i just left it for later in the state it is... The idea was
to move to cmake since kde uses it.

Very clear explanation. I would suggest using this sentence in the wiki page.

Not great, not terrible :)

Yes, i am aware of that. one can hope at least for at least some
casual commits and/or advice / internal design help..
If not to the application itself, maybe in KPart if someone helps with
replacement of the custom component with KPart one.
But one of the reasons for joining into the community is to have support, right?

Yes, this is actually an issue. I reached the point where it
more-or-less worked for me, some other design aspects i had an issue
with, so i kinda just thought to left it for a while.
I am thinking to put some effort into it once kubuntu 19.10 (plasma
5.17?) comes out, so let's see if i get distracted with stuff like
golang/rust.

As i said, this is just a check to see what you guys think about this
idea, especially since there is no alternative for this development
tool in kde ecosystem (not considering jetlabs and java apps).
I can also keep it as it is and come back when it is more mature.

Thanks for reading.

Best regards,
Miroslav.

Re: SQL Query tool - incubator

By Alexander Semke at 08/22/2019 - 15:19

Hi Miroslav,

You mentioned couple of TODOs on your github page and the goal is stated as to
be something similar as HeidiSQL. This goal is not reached yet I'd say and the
TODO-list can be easily extended by many other feature requests for such a
tool. This contradicts a bit with your plans to leave the project for a while.
Are you just looking for somebody who can take over the maintanance and
further develpment of this project?

Best Regards,
Alexander

Re: SQL Query tool - incubator

By =?UTF-8?Q?Miros... at 08/23/2019 - 09:24

Hi Alexander

On Thu, Aug 22, 2019 at 10:19 PM Alexander Semke <alexander. ... at web dot de> wrote:
The problem with those TODOs and generally why i turned for help -
because i got bored of rewriting what i did in a bad way This is the
part of the learning process, but still annoying and demotivating.
"Leaving the project" already happened, so this is me actually
thinking of doing a few improvements in the following months.

No, i am not looking for someone to take over, one of the goals is
that i learn, so i have to / want to be in this. Also, there is no
maintenance yet since it is not finished nor ready for release.
What i actually need in one word is - mentoring. To tell me if my
design/structure/code is wrong and prevent me from burning my time on
something that is not worth it.

BR, Miroslav.

Re: SQL Query tool - incubator

By Konstantin Kharlamov at 08/23/2019 - 10:10

On Пт, авг 23, 2019 at 16:24, Miroslav Špehar < ... at gmail dot com>
wrote:
About learning to design code properly, I can give a recommendation.
Learn Haskell, until you more or less comfortable with it. You may stop
using it right after that, however just the fact that you know the
language gonna pay you back big time in just about any other that you
happen to use in the future.

Since you're using C++, this would make you more comfortable with
various constructions that may otherwise look too clumsy to get used to
them quickly, such as: unions/std::variant, templates, lambdas, various
functions that traverse containers… Especially so with templates: you
can "think" in Haskell due to its elegant syntax, and then reapply your
understanding of how types gets shuffled around in a template
construction to C++ templates.

In general, this language forces one to learn when it's a good time to
break a function to multiple ones, how to encapsulate a logic as much
as possible. This is the language that popularized Category Theory
among programmers (even though mathematicians argue that Hask is not a
category, but there's enough similarity to get a grasp of it).

Be ready to get frustrated at first though, this may be like learning
programming anew, like, when you can't even figure out how to write a
hello world.

Re: SQL Query tool - incubator

By Albert Astals Cid at 08/21/2019 - 15:22

El dimecres, 14 d’agost de 2019, a les 14:24:09 CEST, Miroslav Špehar va escriure:
Oh, then remove the file, or fix it, but don't leave it there for people like me to try to use it, fail and then be sad.

Yes, we will try to help you, but unless you have a good selling story, people are not going to show up and develop stuff.

This last paragraph leaves me with a "i don't know what to say" feeling, it seems that it works for you, which is nice, but if you want to move from "pet project" to "this is something i want people to use" you can't say "let's see if i get distracted" because what we don't want is to incubate projects to have them just die the second after they join.

So I guess the real question here is, how commit are you to make this a serious project? One where you make releases and tell the world "hey there's this nice thing, come and use it" and then take all the [potentially negative] feedback and try to make the app better, and then rinse and repeat.

Cheers,
Albert

Re: SQL Query tool - incubator

By =?UTF-8?Q?Miros... at 08/23/2019 - 09:10

Hi Albert,

On Wed, Aug 21, 2019 at 10:23 PM Albert Astals Cid < ... at kde dot org> wrote:
Fixed rather quickly after you said it didnt work. I also copied the
repo to gitlab to run automated test there since they have it
included.
It gets tested on both, qmake and cmake.

understood.

Due to my day job, this will probably never be something that i can
invest a lot of time into, so i do not see it becoming something
drastically different from "pet project".
I guess it comes down to how much time i can spend on this and
hopefully more in the winter than during the summer.
I am interested into improving it, but also with limited time. This
further means slow and irregular progress.

Since this seems to be an issue here, i have no problem to continue as
i did before.
Not being incubated will not have an impact of what i planned to do either way.

Thanks a lot for a discussion here and i really appreciate the consideration.

Regards,
Miroslav

Re: SQL Query tool - incubator

By Alexander Potashev at 08/09/2019 - 17:40

пт, 9 авг. 2019 г. в 21:57, Miroslav Špehar < ... at gmail dot com>:
Hi Miroslav,

Check out Kexi ( <a href="https://www.calligra.org/kexi/" title="https://www.calligra.org/kexi/">https://www.calligra.org/kexi/</a> ), it probably has
most of the functions available in your project.

Re: SQL Query tool - incubator

By Luigi Toscano at 08/09/2019 - 17:47

Alexander Potashev ha scritto:

I'd say that the two projects do not overlap. KEXI "is an open source visual
database applications creator, a long-awaited competitor for programs like MS
Access or Filemaker." and it does not really allow you to access a random
database (it needs to be imported).
This new tool looks more like a generic interface to any SQL database (similar
to sqlitebrowser, phpmyadmin and so on). Of course it may be possible to share
some code.