Re: Data entry / data editing tools (more end-user focus).

2019-05-23 Thread bret_st...@machinemanagement.com
Not exactly sure how much coding you are interested in doing.I use access and 
Libre Base to prototype data entry from time to time.Been pretty happy with 
Lazarus lately. A free Delphi/Pascal IDE, that runs x-platform.You can put 
stuff together pretty quickly.Best
 Original message From: Tony Shelver  Date: 
5/23/19  2:52 AM  (GMT-08:00) To: Stefan Keller  Cc: 
pgsql-general  Subject: Re: Data entry / data 
editing tools (more end-user focus). 
I looked at quite a few options.   Some constraints on my side that our 
direction is open source, with Linux development and servers.Radzen is .NET:  I 
could just as well use MS Access to cobble together a front end.
CUBA and OpenXava are Java based and seem to require writing Java for logic: I 
last used nearly 20 years ago and 'fast' development and Java IMHO is an 
oxymoron.
Aurelia looks a bit promising, but I am not sure if it gains anything over the 
current crop of JS libraries and frameworks, such as Vue, React et al, and then 
libraries / frameworks built on top of those such as  Nuxt / Vue, Quasar / Vue 
or Vuetify / Vue, which seem to have far more activity on Github.
I managed to set up a quick and dirty front end using LibreOffice Base over a 
weekend, next iteration i will probably move over to a Vue framework, probably 
using Quasar..

On Sat, 18 May 2019 at 00:26, Stefan Keller  wrote:
Dear all



What about following „Rapid App Development Tools"?

* OpenXava (Java): https://www.openxava.org/ate/visual-studio-lightswitch

* Radzen (.NET): https://www.radzen.com/visual-studio-lightswitch-alternative/

* Other: https://aurelia.io/ (JS) or CUBA https://www.cuba-platform.com/ (Java)



:Stefan



Am Do., 28. März 2019 um 15:39 Uhr schrieb Adrian Klaver

:

>

> On 3/27/19 11:49 PM, Tony Shelver wrote:

>

> Please reply to list also, more eyes on the the problem.

> Ccing list

>

> My take on below is since you are feeding a Website why not use Web

> technologies for your data entry. My language of choice is Python. I

> have done something similar to this(on small scale) using the Django

> framework. For something lighter weight there is Flask. Then your client

> becomes a browser and you do not have to distribute forms around. You

> could integrate with the existing Web apps you are using e.g. SnipCart.

>

>

> > Actually I found a possibility.  LibreOffice Base on top of PG lets me

> > paste photos into a Postgresql bytea field no problem.  MS Access should

> > work well also, but I am not going to buy it, and running Ubuntu most of

> > the time.

> > Possibly will distribute the Base forms to select users to enter data.

> > We are a startup company, so this is an affordable temporary fix, until

> > the product I have been looking at matures, or we can roll our own.

> >

> > We are building a company website, including an eStore, and have a few

> > hundred products to load and maintain. Our product data currently isn't

> > suitable for a sales catalog.

> > (Brands, categories, products, pricing and deal info, specials, images,

> > product comparisons and so on).

> >

> > Right now I input / maintain this via CSV files maintained through a

> > spreadsheet  (LibreOffice Calc) which our site generator (Jekyll) uses

> > to build out the static HTML product [pages automatically.

> > This is really quick to enter basic data, but I have to manually

> > maintain image uploads, image names and so on manually in the

> > spreadsheet and through individual file uploads. We have at least one,

> > preferably 3 and up to 6 photos per product to maintain.  Call it a 1000

> > images right now, and that will only go up.

> > Invalid text / characters in product descriptions and so on can break

> > the CSV as well.

> >

> > There are headless CMS solutions out on the market targeting this same

> > area, but for various reasons the suitable ones are still maturing and

> > shaking out in the marketplace, so I am not in a hurry to make a choice.

> >

> > So the goal is to replace CSV with JSON file input.  This will also make

> > my life easier for more complex structures such as multiple categories

> > and specs per product.

> > I also want to migrate text that can change from the HTML pages into the

> > database for easier changes by end users. For this the users could use

> > a WYSIWIG MarkDown editor, and just cut and past the MarkDown into Base

> > forms when finished.  This will be converted to HTML at build time by

> > Jekyll static site generator or a script.

> >

> > So the proposed solution:

> > 1. Create the database in Postgresql.

> > 2. Link Base or other tool to it and design input forms where necessary

> >

> > 3. Enter the data through Base into PG including images, MarkDown / HTML

> > text, long descriptions and so on.

> > 3a. If I don't get a suitable CMS going, I could spend some time

> > developing a Vue/Quasar/Nuxt whatever front end to handle this, in

> > several months time.

> >

> > 4

Re: Sort question - Fractions, Metric etc

2021-08-14 Thread bret_st...@machinemanagement.com
Of course it's a complete disorganized mess..That'a the world I live in.Best 
thing is, I'm walking away with some new strategies.You guys rock
 Original message From: Sándor Daku  
Date: 8/14/21  10:19 AM  (GMT-08:00) To: Tom Lane  Cc: 
Adrian Klaver , Bret Stern 
, pgsql-general@lists.postgresql.org Subject: 
Re: Sort question - Fractions, Metric etc On Sat, 14 Aug 2021 at 19:03, Tom 
Lane  wrote:Adrian Klaver  
writes:
> On 8/14/21 9:37 AM, Bret Stern wrote:
>> I haven't explored doing this with numeric types, but some columns 
>> needed alpha chars eg 13mm.

> Two columns:

> data_val(numeric)     data_unit(varchar)
> 13                    mm

It sounds like your data is a completely disorganized mess :-(.
You might be able to bring some semblance of coherence to it with
an extension like postgresql-unit [1], but it will take a lot of
effort to get the data into a representation that can sort reasonably.
There's no "easy button" here.

                        regards, tom lane

[1] https://github.com/df7cb/postgresql-unitI'm not sure, but maybe a kind of 
cast function that cast everything into a reasonable common unit(Khm... 
millimeters) and sort on that? It seems relatively simple to pick up the value 
and unit from a string with a regexp. Admittedly the data would still be a 
mess.  Regards,Sándor