News for hackers. Stuff that matters.

jstaniek

Regarding Access-type of apps: IMHO they are as needed as spreadsheets, just less frequently. Like cars for 6 person families are needed too even if for cars for 4 are more popular.

It's not complaining but: if the percentage of people using such apps isn't increasing this is maybe also because of average level of technical education among computer users decreasing. Average user wouldn't operate at this level of specialization. Even scientists... those I know don't reject using simple spreadsheets risking numeric inaccuracies. Weak and prototype tools become the standard for them.

So simple spreadsheet apps (excel-like) that got very feature-laden over the years (statistical stuff, etc.) that clearly introduce on a concept of a strict matrix structure are very popular and they don't get replaced by web interfaces. Conversely, the web interfaces try to emulate the original UX with more or less success (Google Sheets, MS Office online).

Simplistic explanation of Access type of apps could be that they introduce data types and more on top of what's know in spreadsheets. There's always market for that but the demand needs to be realized (created?).

Ideally the database type of apps could learn some agility from the spreadsheets world. Newer MS Accesses offer implicit adding of fields in a 'spreadsheet' way in the data view and altering form/report design in the data view as well. I'd like to have that in Kexi too. Maybe even the app should welcome the user with an empty sheet of cells by default?

We have a place for discussions on the forums https://forum.kde.org/kexi and also mailing lists if someone is interested.

Yes I believe so. how do you feel about SQLite for local storage?

Kexi picked SQLite as the default backend in 2004, and it was a good bet. For native mobile there's Qt Quick for the GUI with which large part of Kexi is compatible. A database creation/handling layer has been extracted years ago and now it matures under name KDb: https://community.kde.org/KDb

Thanks, very nice, bookmarked as usual at https://community.kde.org/Kexi/Links#Competition
Right, in 2006 this was a target for quite an investment thanks to Google's SoC funds. We had a lighttpd server bundled with Kexi and it was all the way to expose Kexi projects to the web environment with a 'single click deploy' to server. Unmaintained since then, but we know how to do that properly and for the modern web.

In some way it's even better the 2006's solution isn't in use, we can start fresh. For this volunteers are needed: web developers/users/designer, not necessarily C++ hackers.

Some jquery/bootstrap components can make the data grids and forms work well.

Priority fixes and features for Kexi can be implemented based on donations:

https://community.kde.org/Kexi/Contact#Donations

Thanks, these are very good points.

Coincidentally, yeah, comparison and feature sheet is what we want to have soon, probably near the come back of the Windows version.

And we're looking for talented volunteers to prepare a new more modern web page. Something like https://marble.kde.org and mobile-friendly.

Hi, Jaroslaw Staniek, Kexi maintainer here. Nice to meet you and I find the comments interesting. Feel free to ask me anything about Kexi :)

I'll try to answer some questions.

PS: came here alerted by this post :) https://www.reddit.com/r/hackernews/comments/3p8e9z