iText PDF + Kotlin SpringBoot RestAPI + MySQL » grokonez

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/itext-pdf-kotlin-springboot-restapi-mysql

iText PDF + Kotlin SpringBoot RestAPI + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA & iText PDF library to extract data from MySQL records to a PDF file in table format.

Related posts:

Technologies

- Kotlin – SpringBoot – iText 5.0.6 – MySQL

Practice

Project Structure -> kotlin-springboot-restapi-download-pdf-file-spring-jpa-mysql-itextpdf-project-structure

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:

More at:
https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/itext-pdf-kotlin-springboot-restapi-mysql

#kotlin #springboot #itext #pdf #mysql

What is GEEK

Buddha Community

iText PDF + Kotlin SpringBoot RestAPI + MySQL » grokonez

iText PDF + Kotlin SpringBoot RestAPI + MySQL » grokonez

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/itext-pdf-kotlin-springboot-restapi-mysql

iText PDF + Kotlin SpringBoot RestAPI + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA & iText PDF library to extract data from MySQL records to a PDF file in table format.

Related posts:

Technologies

- Kotlin – SpringBoot – iText 5.0.6 – MySQL

Practice

Project Structure -> kotlin-springboot-restapi-download-pdf-file-spring-jpa-mysql-itextpdf-project-structure

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:

More at:
https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/itext-pdf-kotlin-springboot-restapi-mysql

#kotlin #springboot #itext #pdf #mysql

Joe  Hoppe

Joe Hoppe

1595905879

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

HTML to Markdown

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? In this post, we are going to compare the top two providers, DigitalOcean Managed Databases for MySQL vs. ScaleGrid MySQL hosting on DigitalOcean.

At a glance – TLDR
ScaleGrid Blog - At a glance overview - 1st pointCompare Throughput
ScaleGrid averages almost 40% higher throughput over DigitalOcean for MySQL, with up to 46% higher throughput in write-intensive workloads. Read now

ScaleGrid Blog - At a glance overview - 2nd pointCompare Latency
On average, ScaleGrid achieves almost 30% lower latency over DigitalOcean for the same deployment configurations. Read now

ScaleGrid Blog - At a glance overview - 3rd pointCompare Pricing
ScaleGrid provides 30% more storage on average vs. DigitalOcean for MySQL at the same affordable price. Read now

MySQL DigitalOcean Performance Benchmark
In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL. We are going to use a common, popular plan size using the below configurations for this performance benchmark:

Comparison Overview
ScaleGridDigitalOceanInstance TypeMedium: 4 vCPUsMedium: 4 vCPUsMySQL Version8.0.208.0.20RAM8GB8GBSSD140GB115GBDeployment TypeStandaloneStandaloneRegionSF03SF03SupportIncludedBusiness-level support included with account sizes over $500/monthMonthly Price$120$120

As you can see above, ScaleGrid and DigitalOcean offer the same plan configurations across this plan size, apart from SSD where ScaleGrid provides over 20% more storage for the same price.

To ensure the most accurate results in our performance tests, we run the benchmark four times for each comparison to find the average performance across throughput and latency over read-intensive workloads, balanced workloads, and write-intensive workloads.

Throughput
In this benchmark, we measure MySQL throughput in terms of queries per second (QPS) to measure our query efficiency. To quickly summarize the results, we display read-intensive, write-intensive and balanced workload averages below for 150 threads for ScaleGrid vs. DigitalOcean MySQL:

ScaleGrid MySQL vs DigitalOcean Managed Databases - Throughput Performance Graph

For the common 150 thread comparison, ScaleGrid averages almost 40% higher throughput over DigitalOcean for MySQL, with up to 46% higher throughput in write-intensive workloads.

#cloud #database #developer #digital ocean #mysql #performance #scalegrid #95th percentile latency #balanced workloads #developers cloud #digitalocean droplet #digitalocean managed databases #digitalocean performance #digitalocean pricing #higher throughput #latency benchmark #lower latency #mysql benchmark setup #mysql client threads #mysql configuration #mysql digitalocean #mysql latency #mysql on digitalocean #mysql throughput #performance benchmark #queries per second #read-intensive #scalegrid mysql #scalegrid vs. digitalocean #throughput benchmark #write-intensive

iText PDF + SpringBoot RestAPI - Extract MySQL Data to PDF File » grokonez

https://grokonez.com/spring-framework/spring-boot/pdf-file-with-itext-springboot-restapi-extract-mysql-data-to-pdf-file

iText PDF + SpringBoot RestAPI – Extract MySQL Data to PDF File

In the tutorial, we show you how to create a SpringBoot RestAPIs application that uses Spring JPA & iText library to extract data from MySQL records to a PDF file in table format.

Related posts:

Technologies

- SpringBoot - iText 5.0.6 - MySQL

Practice

Project Structure -> spring-boot-spring-jpa-export-data-pdf-table-file-by-itext-mysql-project-structure

Create SpringBoot project

Use SpringToolSuite to create a SpringBoot project with below dependencies:
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>      
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>      
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itextpdf</artifactId>
    <version>5.0.6</version>
</dependency>   
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

Customer Model

Customer.java ->

More at:

https://grokonez.com/spring-framework/spring-boot/pdf-file-with-itext-springboot-restapi-extract-mysql-data-to-pdf-file

iText PDF + SpringBoot RestAPI – Extract MySQL Data to PDF File

#springboot #mysql #itext #extract

Kotlin Spring Boot RestAPIs - Download Excel File - Apache POI + MySQL » grokonez

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-excel-file-apache-poi-mysql

Kotlin Spring Boot RestAPIs – Download Excel File – Apache POI + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA to get data from MySQL records and uses Apache POI library to write data to a Excel file.

Related posts:

Technologies

– Kotlin Spring Boot – 2.0.6.RELEASE – Spring JPA – MySQL – Apache POI

Practice

Project Structure -> kotlin-spring-boot-restapi-download-excel-file-spring-jpa-mysql-project-structure

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:
<dependency>
	<groupId>org.jetbrains.kotlin</groupId>
	<artifactId>kotlin-stdlib-jdk8</artifactId>
</dependency>
<dependency>
	<groupId>org.jetbrains.kotlin</groupId>
	<artifactId>kotlin-reflect</artifactId>
</dependency>
<dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>               
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-data-jpa</artifactId>
      </dependency>      
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.17</version>
</dependency>   
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>javax.xml.bind</groupId>
    <artifactId>jaxb-api</artifactId>
    <version>2.3.0</version>
</dependency>

Customer Model

Customer.kt ->

More at:

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-excel-file-apache-poi-mysql

Kotlin Spring Boot RestAPIs – Download Excel File – Apache POI + MySQL

#kotlin #springboot #restapi #excel #mysql #apachepoi

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-csv-file-example-apache-commons-csv-mysql

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA to get data from MySQL records and uses Apache Commons CSV library to write data to a CSV file.

Related posts:

Technologies

– Kotlin Spring Boot – 2.0.6.RELEASE – Spring JPA – MySQL – Apache Commons CSV

Practice

Project Structure -> kotlin-springboot-restapi-download-csv-file-spring-jpa-mysql-project-structure

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:
<dependency>
	<groupId>org.jetbrains.kotlin</groupId>
	<artifactId>kotlin-stdlib-jdk8</artifactId>
</dependency>
<dependency>
	<groupId>org.jetbrains.kotlin</groupId>
	<artifactId>kotlin-reflect</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>      
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>   
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
	<groupId>org.apache.commons</groupId>
	<artifactId>commons-csv</artifactId>
	<version>1.5</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>javax.xml.bind</groupId>
    <artifactId>jaxb-api</artifactId>
    <version>2.3.0</version>
</dependency>

Customer Model

- Customer.kt ->

More at:

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-csv-file-example-apache-commons-csv-mysql

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

#kotlin #springboot #mysql #apachecommons #restapi