Re: HELP - HSQLDB-specific question and more general comments

Fred Toussi via Hsqldb-user <[email protected]> Tue, 02 Aug 2022 12:55:21 +0100
Newsgroups	gmane.comp.java.hsqldb.user
Message-ID	<[email protected]>
--===============8489238854854641671==
Content-Type: multipart/alternative;
 boundary=344061b6221d4371bd179b2959884911

--344061b6221d4371bd179b2959884911
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: quoted-printable

You can use HSQLDB with LibreOffice for your usage. If you do not need

HSQLDB supports the INTERVAL data type. INTERVAL MINUTES(6) TO SECONDS(3=
) The minutes:seconds:milliseconds values. In the example below the DURA=
TION column supports values such as INTERVAL '4:50.123'

CREATE TABLE TB (ID INT PRIMARY KEY, DURATION INTERVAL MINUTE(6) TO SECO=
ND(3))

See chapter 2 of the HyperSQL Guide for details.

For LibreOffice setup and usage please see the link below. You can get s=
upport in that forum:

https://forum.openoffice.org/en/forum/viewtopic.php?t=3D61183

On Mon, Aug 1, 2022, at 23:00, CHRIS MILLER wrote:
> Hello HSQLDB team,=20
>=20
> I am new here as I have just recently started to do a lot of research =
relative to creating relational databases for my own use. My first proje=
ct (which I may regret even more in the coming weeks) is to design a dat=
abase to record my resistance workouts.
>=20
> *BACKGROUND - *I have been researching open-source databases and tools=
 and have landed on Libre Office and HSQLDB (v7.2) (although I am not ma=
rried to them if you would suggest a different set of tools).
>=20
> I am having some issues with the correct setups and configurations of =
the tools to databases in trying to run split databases from Libre Offic=
e but am coming up short in finding on-line or print resources to simpli=
fy the conversation for me (I have the Libre Office User Guides for Gett=
ing Stated and for Base). Any suggestions would be appreciated. I am try=
ing to implement on a 2017 iMac desktop running the latest version of th=
e OS but, unfortunately, I am not very facile with the internal technolo=
gies (especially managing drives and file paths) on the Mac.
>=20
> *SPECIFIC HSQLDB question* - Will I be able to record (in the data set=
) set durations consisting of minutes:seconds.milliseconds *AND* use the=
m in calculations (as in, Totals; for select dates or select exercise ty=
pes for instance)?
>=20
> Lastly, is there some simpler, more directive resource explaining setu=
p and making connections using the HSQLDB; LibreOffice Base; the Java JD=
K; and the correct pathways? I understand I have a lot more to learn; so=
metimes I just don=E2=80=99t know the right sequence of learning that I =
need
>=20
> Regards,
>=20
> Chris M
>=20
>=20
> Sent from my iPad
>=20
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>=20

--344061b6221d4371bd179b2959884911
Content-Type: text/html;charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div style=3D"font-f=
amily:Arial;">You can use HSQLDB with LibreOffice for your usage. If you=
 do not need<br></div><div style=3D"font-family:Arial;"><br></div><div s=
tyle=3D"font-family:Arial;">HSQLDB supports the INTERVAL data type. INTE=
RVAL MINUTES(6) TO SECONDS(3) The minutes:seconds:milliseconds values. I=
n the example below the DURATION column supports values such as INTERVAL=
 '4:50.123'<br></div><div style=3D"font-family:Arial;"><br></div><div st=
yle=3D"font-family:Arial;">CREATE TABLE TB (ID INT PRIMARY KEY, DURATION=
 INTERVAL MINUTE(6) TO SECOND(3))<br></div><div style=3D"font-family:Ari=
al;"><br></div><div style=3D"font-family:Arial;">See chapter 2 of the Hy=
perSQL Guide for details.<br></div><div style=3D"font-family:Arial;"><br=
></div><div style=3D"font-family:Arial;">For LibreOffice setup and usage=
 please see the link below. You can get support in that forum:<br></div>=
<div style=3D"font-family:Arial;"><br></div><div style=3D"font-family:Ar=
ial;"><a href=3D"https://forum.openoffice.org/en/forum/viewtopic.php?t=3D=
61183">https://forum.openoffice.org/en/forum/viewtopic.php?t=3D61183</a>=
</div><div style=3D"font-family:Arial;"><br></div><div>On Mon, Aug 1, 20=
22, at 23:00, CHRIS MILLER wrote:<br></div><blockquote type=3D"cite" id=3D=
"qt" style=3D""><div>Hello HSQLDB team, <br></div><div><br></div><div>I =
am new here as I have just recently started to do a lot of research rela=
tive to creating relational databases for my own use. My first project (=
which I may regret even more in the coming weeks) is to design a databas=
e to record my resistance workouts.<br></div><div><br></div><div><b>BACK=
GROUND - </b>I have been researching open-source databases and tools and=
 have landed on Libre Office and HSQLDB (v7.2) (although I am not marrie=
d to them if you would suggest a different set of tools).<br></div><div>=
<br></div><div>I am having some issues with the correct setups and confi=
gurations of the tools to databases in trying to run split databases fro=
m Libre Office but am coming up short in finding on-line or print resour=
ces to simplify the conversation for me (I have the
 Libre Office User Guides for Getting Stated and for Base). Any suggesti=
ons would be appreciated. I am trying to implement on a 2017 iMac deskto=
p running the latest version of the OS but, unfortunately, I am not very=
 facile with the internal technologies (especially
 managing drives and file paths) on the Mac.<br></div><div><br></div><di=
v><b>SPECIFIC HSQLDB question</b> - Will I be able to record (in the dat=
a set) set durations consisting of minutes:seconds.milliseconds <b>AND</=
b> use them in calculations (as in, Totals; for select dates or select e=
xercise types for instance)?<br></div><div><br></div><div>Lastly, is the=
re some simpler, more directive resource explaining setup and making con=
nections using the HSQLDB; LibreOffice Base; the Java JDK; and the corre=
ct pathways? I understand I have a lot more to learn; sometimes I just d=
on=E2=80=99t know the right sequence
 of learning that I need<br></div><div><br></div><div>Regards,<br></div>=
<div><br></div><div>Chris M<br></div><div><br></div><div><div><br></div>=
<div dir=3D"ltr">Sent from my iPad<br></div></div><div><br></div><div>__=
_____________________________________________<br></div><div>Hsqldb-user =
mailing list<br></div><div><a href=3D"mailto:[email protected]=
ge.net">[email protected]</a><br></div><div><a href=3D"h=
ttps://lists.sourceforge.net/lists/listinfo/hsqldb-user">https://lists.s=
ourceforge.net/lists/listinfo/hsqldb-user</a><br></div><div><br></div></=
blockquote><div style=3D"font-family:Arial;"><br></div></body></html>
--344061b6221d4371bd179b2959884911--


--===============8489238854854641671==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============8489238854854641671==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============8489238854854641671==--