website·Indexed 32 days ago
https://dev.selectfromuser.comA tool for quickly building admin pages based on databases and APIs using YAML configurations. It supports connections to MySQL, PostgreSQL, Redis, MongoDB, DynamoDB, and BigQuery, and provides features for user property management, custom layouts, API security, and self-hosted CLI installation.
Select Admin reduces the cost of developing and maintaining administrative tools by replacing traditional coding (server frameworks, ORM, UI templates) with a specification-based configuration. Key design principles include:
Select Admin records and allows the retrieval of logs related to user access, account changes, and permission grants.
Access Logs: Records successful logins and failed login attempts, including instances where the device has changed.
Role access: User accessRole access denied: User access deniedPermission Logs: These can be enabled under Settings > Security by activating the 'Reason for Granting Permission' feature. Common event codes include:
Role create: New user invitation (permission added)Role update: User permission changeRole delete: User permission deletiongroup grant: User permission group addedgroup revoke: User permission group deletedServiceRole update: Admin page service permission changeproperty update: UserProperty changeDownload Logs: Enabled under Settings > Security by activating the 'Reason for Download' feature.
Activity download: User activity log downloadAudit download: Audit log downloadJavaScript transformation functions allow developers to implement validation logic or convert common codes before data is displayed or modified in the admin. The execution flow follows this sequence:
requestFn $\rightarrow$ requestSubmitFn $\rightarrow$ requestParamFnresponseFn $\rightarrow$ responseRowFn $\rightarrow$ responseErrorFnpath.Settings > Account.To connect a database (such as MySQL, PostgreSQL, or Redis) to the Select service for building admin pages, navigate to the Admin page and follow these steps:
Note: For security reasons, connection information cannot be viewed or modified once it has been added.
content field.- type: markdown
content: |
<p class="text-slate-600 font-bold text-2xl">Receipt Store List Page</p>
<ul class="text-slate-400 font-bold text-xs">
<li>Past data can be viewed on the <a href='#'>Transaction History</a> page.</li>
</ul>Select uses Bind Parameters/Prepared Statements by default for security. Depending on whether a search parameter is required or optional, use the following patterns:
CASE-WHEN or a logical OR with LENGTH() to ignore the condition when the parameter is empty.LENGTH(:param) = 0 to ignore the condition when the parameter is empty.-- Mandatory
SELECT * FROM users WHERE name = :name
-- Optional (MySQL)
SELECT * FROM users WHERE status = 'active' AND (!LENGTH(:name) OR name = :name)
-- Optional (PostgreSQL)
SELECT * FROM users WHERE status = 'active' AND (LENGTH(:name) = 0 OR name = :name)http block type with method: POST. When configured this way, the system operates in a 'Confirm before execution' mode to prevent accidental data changes.menus:
- path: test/http-post
name: HTTP-POST
pages:
- path: test/http-post
blocks:
- type: http
name: POST Sample
axios:
method: POST
url: https://httpbin.org/anything?query=1
data:
'customer_id': customer-{{id}}
'v': "{{API_VERSION}}"
params:
- key: id
label: 'Customer ID'
format: 'number'
- key: API_VERSION
valueFromEnv: trueparams property. This allows the UI to pass user input into the SQL query or HTTP request. For partial matches in SQL, use a combination of LENGTH and LIKE with the CONTACT function to handle empty inputs and wildcards.# SQL Example for partial email search
sql: >
SELECT *
FROM users
WHERE (LENGTH(:email) = 0 OR email LIKE CONTACT('%', :email, '%'))
params:
- key: email
# HTTP Example for email search
axios:
method: GET
url: https://api.example.com/v1/users?email={{email}}&limit=10
rowsPath: rows
params:
- key: email