Replies: 8 comments 2 replies
-
Yeah, exactly that. The first problem was that the "shell" component was missing (but that sounds like a bug). Once I had that, the GUI components I included started appearing - but I had to copy the first few lines of the example on github to make it work. I was playing around with making a simple inventory tracking system - it's basically a bunch of relational tables defining products, suppliers, customers, orders, shipments etc - with the idea that the total inventory can be summarised by outbound shipments - inbound shipments. I need interfaces to insert things, and then a bunch of pages for reporting the state of the database - basically rending a few different SQL queries to show total stock, lists of orders etc. It's mostly a toy project to replace a few excel spreadsheets that I've been trying over the past few months in various no-code tools, but always running up against limitations due to their implementation details. Most no-code tools do very well with simple mappings between a database table and what you see on screen, but fall apart with relational data (like having many-to-many relations defined by a separate table). I can handle all of that in SQL, but most no-code tools don't let you edit the SQL. The most important thing for me is that the underlying database structure is tool-agnostic - if I start hitting limitations with whatever low-code tool makes the CRUD part (and the database is useful enough to invest time in) I can port it to a "real" framework. |
Beta Was this translation helpful? Give feedback.
-
Thank you for opening this, and for all the feedback !
Features
|
Beta Was this translation helpful? Give feedback.
-
That could work - although to be useful it'd need to preserve the primary key of each row in people - so you can create a relationship with the subsequent information. You really need 2 lists for the options - the displayed string, and the underlying HTML value element. |
Beta Was this translation helpful? Give feedback.
-
Could you pass a list of markdown-rendered rows in the first SELECT? Something like
Maybe you'd want the _md to be mandatory, I don't know. Still possible to render markdown from the database, but at least it'd have to be explicit. |
Beta Was this translation helpful? Give feedback.
-
SELECT 'form' as component;
SELECT
'Friend' as name,
'select' as type,
group_concat(family_name, '\n') AS options
group_concat(id, '\n') AS option_values
FROM people; ? |
Beta Was this translation helpful? Give feedback.
-
Yes, that sounds better ! I'll see how feasible it is |
Beta Was this translation helpful? Give feedback.
-
I rewrote the landing page and the getting started instructions on the official website to try and make them easier to understand. @leoedin , can you tell me if the new version is better ? |
Beta Was this translation helpful? Give feedback.
-
Now that I've opened separate issues for the feature requests mentioned above, I'll convert this thread to a github discussion. |
Beta Was this translation helpful? Give feedback.
-
Hi,
I left a comment on HN - but I thought maybe an issue would be easier for you!
Docs
Features
I want a searchable table of database items with a way to edit each one - maybe an extension to the table view? Either a way to add a custom link to each row in the table, or an extension to it that allows editing of data. That's where a CRUD example would be good.
The form should have an input type "combo" or similar, which is constrained to the options I've queried from the database. That way I can use the form to insert relational data, or limit users to a set of selections. eg https://mui.com/material-ui/react-autocomplete/. Bonus if the displayed name and value are different - that way I can make the value the id and show a nice name to the user.
The "checkbox" type is either whatever it's value is, or NULL. If I've got an integer not null type in the database, I have to coalesce($myCheckbox, 0) when saving it - can you make it have a default unchecked value?
(I just added this one) - a JSON API component - you've got a CSV component, but it would be great if I could make a page which just renders JSON of my query, so my app can have an API as well as GUI.
Beta Was this translation helpful? Give feedback.
All reactions