{"repo":"kolchagov/java-crud-api","free":true,"listed":false,"github":"https://github.com/kolchagov/java-crud-api","clone":"git clone https://github.com/kolchagov/java-crud-api.git","description":null,"language":"Java","stars":28,"topics":["api-server","restful","mysql","geospatial","java","sql-server","postgresql","crud-api","postgis","crud"],"license":null,"category":"databases-storage","readme_excerpt":"UPDATED version 1.1 Several security vulerabilities have been closed: - Bump mysql-connector-java from 5.1.49 to 8.0.28 - org.postgresql:postgresql 42.2.26 - Bump gson from 2.8.7 to 2.8.9 Because of these updates, this version is no longer compatible with Java 7 This is a full Java port of the php-crud-api project (single file REST API). It implements almost full functionality (with the exception of Swagger tools), and uses JDBC (should be platform and SQL-dialect independent). It differs from the original project by some optimizations: - Result is transformed by default (if transform parameter is not specified, it is assumed to be 1) - Metadata cache (reading metadata is expensive, so it's cached for 1 minute, providing huge performance boost) - Streaming API in almost all cases (with the exception of relations: 'include' command). - Connection pooling through Hikari pool These features makes it a lot more responsive under heavy load than php version. Installation Install dependencies using: sudo apt-get install maven openjdk-8-jdk Then build the server. mvn compile Configuring Configuration has done through the class ApiConfig. Have a look at the constructor or tests for configuration examples Running To run the api (during development) type: mvn compile exec:java In production I recommend deploying the JAR file as described below. Usage You can do all CRUD (Create, Read, Update, Delete) operations and one extra List operation. Here is how: List List all records of a databa","default_branch":null,"files":null,"tree":[],"storefront":"/r/kolchagov","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kolchagov/java-crud-api/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}