Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start.
Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples
Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs.
This PL/SQL package converts a query with a sdo_geometry into an ESRI shape file and a shape file into a Oracle table. It can also convert a Oracle table into a dBase file and vice versa.
Sample 1 - create a shape file (alk.shp, alk.shx, alk.dbf) of type 5 (=Polygon) from table MYTABLE with sdo-column="geo" and SDO_GTYPE=3003:
select zvk_shape.write_shp('DATA_PUMP_DIR','alk',
'select t.C01 "NAME",
t.C20 "FLST",
t.GEO
from MYTABLE t
where t.C02 = ''ALK''
order by t.C01','GEO',5) "alk" FROM dual;
...From my experience generating code from XML using XSLT is one of the best and fastest solutions.
This is just the base of the framework presenting the idea, any code template can be implemented upon request.
Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java
The main target is to generate DTO/BDO/POJO objects based on the database definitions in multiple languages aligning all technologies used by a development team.
If you are willing to contribute drop a message.
PRTG Catches Network Issues Before They Cause Downtime
Threshold-based alerts flag problems early, so your team can act before users notice, not after.
Reactive troubleshooting usually means hearing about a problem from frustrated users, not your monitoring tool. PRTG sets threshold-based alerts across devices, servers and applications, notifying your team by email, SMS or push the moment a metric crosses a set limit. That means catching a failing disk or overloaded server before it becomes an outage and getting time back from firefighting. Start a free trial and set your first alerts today.