Castiel Snow

Tim Holloway wrote:Apparently buildSessionFactory() was deprecated as far back as 2011. That's 10 years of software erosion there.

It's also, I assume, part of legacy Hibernate, not Hibernate JPA, and I've been recommending that people migrate to JPA for many years now.

It's not true that you can write software and it "never wears out". The software may remain unchanged, but the world that contains it does not, and eventually, not only is it more and more likely to fail in time and  there will be fewer and fewer people who can help.

And, alas, I'm not one of them.

Wow
I didnt know that!

How do I migrate to JPA? How do I start?
Im googling.. seems I can convert my actual code.

Something like this should work?

import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; import org.hibernate.service.ServiceRegistry; import org.hibernate.boot.registry.StandardServiceRegistryBuilder; .....    Configuration conf = new Configuration()              .configure();    ServiceRegistry sr = new StandardServiceRegistryBuilder().applySettings(conf.getProperties()).build();    SessionFactory sf = conf.buildSessionFactory(sr);    Session session = sf.openSession();    session.beginTransaction();    YourDominClass ydc = new YourDominClass();    ydc.setSomething("abcdefg");    session.save(ydc);    session.getTransaction().commit();    session.close();    sf.close();            ........

https://stackoverflow.com/questions/8640619/hibernate-serviceregistrybuilder


Or even this? https://www.theserverside.com/blog/Coffee-Talk-Java-News-Stories-and-Opinions/3-ways-to-build-a-Hibernate-SessionFactory-in-Java-by-example

How to Optimize Hibernate buildSessionFactory();"


Im trying to optimize my hibernate initialization.
'cfg.buildSessionFactory();' consumes a lot of CPU. And on low-end systems is taking more than 20 seconds.
Is there anyway I can cache it and just load manually?

Im stuck. I cant find a way to optimize this. Whats the proper way to
make 'cfg.buildSessionFactory();' faster?


    public static void initHibernate() throws Exception {             System.out.println("Initializing Hibernate.....");         String username = Cryptographer.decrypt(MySettings.getDb_username());         String password = Cryptographer.decrypt(MySettings.getDb_password());         String url = Cryptographer.decrypt(MySettings.getDb_url());                 cfg = new Configuration()                 .configure("hibernate.cfg.xml")                 .setProperty("hibernate.connection.url", url)                 .setProperty("hibernate.connection.username", username)                 .setProperty("hibernate.connection.password", password)                 .setProperty(username, url);                 //Error: Hibernate Could not deserialize cache file:         //File fileAux = new File("A:\\hibernate.cfg.xml");         //cfg.addCacheableFile(fileAux);                 sessions = cfg.buildSessionFactory();     }


**Additional Information:**

----
    compile group: 'org.hibernate', name: 'hibernate-c3p0', version: '5.4.27.Final'
----

Mapping xml file: (I redacted private information as REDACTED)

    <?xml version="1.0" encoding="UTF-8"?     <!DOCTYPE hibernate-configuration PUBLIC             "-//Hibernate/Hibernate Configuration DTD 3.0//EN"             "http://hibernate.org/dtd/hibernate-configuration-3.0.dtd"         <hibernate-configuration         <session-factory                 <!-- UPDATE OR NONE --             <property name ="hibernate.hbm2ddl.auto"none</property                 <!-- --             <property name="hibernate.connection.driver_class"com.mysql.cj.jdbc.Driver</property             <property name="hibernate.connection.url"</property             <property name="hibernate.connection.username"</property             <property name="hibernate.connection.password"</property                         <!-- --             <property name="hibernate.current_session_context_class"thread</property             <property name="hibernate.dialect"org.hibernate.dialect.MySQL8Dialect</property             <property name="hibernate.order_updates"true</property                 <!-- Just set the correct isolation to default(1). Stops logging messages --             <property name="hibernate.connection.isolation"1</property                 <!-- Might Improve Performance --             <property name="hibernate.jdbc.batch_versioned_data"true</property             <property name="hibernate.connection.autoReconnect"true</property             <property name="hibernate.connection.autoReconnectForPools"true</property                 <!-- fix time zone --             <property name="hibernate.jdbc.time_zone"UTC</property                 <!-- hibernate --             <property name="hibernate.temp.use_jdbc_metadata_defaults"false</property             <property name="hibernate.connection.pool_size"3</property             <property name="hibernate.show_sql"false</property             <property name="hibernate.format_sql"false</property             <property name="hibernate.jdbc.batch_size"360</property             <property name="hibernate.max_fetch_depth"30</property             <property name="hibernate.connection.provider_class"org.hibernate.connection.C3P0ConnectionProvider</property                 <!-- C3PO --             <property name="hibernate.c3p0.max_size"3</property             <property name="hibernate.c3p0.min_size"1</property             <property name="hibernate.c3p0.timeout"240</property             <property name="hibernate.c3p0.max_statements"180</property             <property name="hibernate.c3p0.idle_test_period"30</property             <property name="hibernate.c3p0.acquire_increment"1</property             <property name="hibernate.c3p0.testConnectionOnCheckout"false</property             <property name="hibernate.c3p0.testConnectionOnCheckin"true</property             <property name="hibernate.c3p0.preferredTestQuery"SELECT 1</property                 <!-- Mapping --                 <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/                         <mapping class="br.REDACTED.models.REDACTED"/             <mapping class="br.REDACTED.models.REDACTED"/                     </session-factory     </hibernate-configuration>


**References**

https://forum.hibernate.org/viewtopic.php?p=2242766

https://developer.jboss.org/thread/197521

https://github.com/spring-projects/spring-framework/issues/18305

https://docs.jboss.org/hibernate/orm/5.2/topical/html_single/bytecode/BytecodeEnhancement.html

Campbell Ritchie wrote:Please don't update an old post like that. Users will not notice the update after they have replied. I have reverted the edit. Please post a new post with the additional information.

Sorry, I thought was best to not pollute it. But I understand. Sorry.
Good thing I had a copy of this. Would be a pain to write all over lol

Im converting a DesktopApp(JavaFx) to a WebApp (Spring Boot).

The DesktopApp has a field called 'hyperlink', which is a String field. The User utilizes the JFileChooser to pick a file or even a folder and save the ABSOLUTE PATH to this file on the field called hyperlink. The user can also manually set the field and for example, set a internet URL (for example, a dropbox link with public access).

This field is then saved in the database.

Other users can then try to access this file. It usually works because users save the absolute path of the local network or even Internet URL's like 'https://redacted.something.com/file.txt.

In this case, a user could open the app, find this 'hyperlink' field and click open --> If its a URL, it will open a browser page. If its a network file, it will open explorer.exe on the absolute path given by the field.

However, this functionality must now exist on the spring boot version.

Problem

Was unknown to me that Browser's security forbid you to access local files. So now, I can neither get the absolute path with the HTML file chooser or access a local file with it.

How should I deal with this?

Someone mentioned me I should think about using either an extension in browser OR a java plugin (ew?).

Bear Bibeault wrote:No. Security concerns prevent the browser from having such access to the file system.

Is there anyway to bypass that?
Extensions?
Java apps?
Anything?
Im using SpringBoot

Is there local file manipulation that's been done with JavaScript that can actually get the absolute path to a file or folder when the user chooses with a directory or file picker?

Specifically, I'd like to read/show the ABSOLUTE PATH from a file and open the file if the user requests it. At this point I'm not worried about gaining permissions and am just assuming I already have full permissions to these files.

Thymeleaf - How to send a table as a list?

Greetings codeRanch. Hope you are all having a great end of 2020*.
I need help on how to solve a situation...

--Context--
I have a javafx Desktop Application. Im building now the Web version of this app.
I have a class called Tool, and it has the variable Collection<DistributionPoint> distributionPoints;
Im working on a page to add/update a Tool, like in the javafx app.



--Problem--
I have a combobox a Option/Combobox in my HTML that is filled with objects from the class "DistributionPoint" to pick from.
The user, can pick any they want and add to a table as long as its not added already in the table already (Doesnt allow repeated values).



From the UI side, everything works as it should.
When I press Save/Submit, it doesnt save the table as the distributionPoint list of 'tool'.
I've tried several things but none of them worked. Any tip on how to deal with this?



HTML file
.... <form method="POST" th:object="${tool}"  th:action="@{/tools/add}"> .... <!-- Ponto De Distribuição  (Distribution Points) --> <div class="w-100 col-md-6">                        <table id="tabledistributionPoints" class="w-100 tab" border="2" th:field="${tool.distributionPoints}" >                            <tr id="head">                                <th>Distribution Point</th>                            </tr>                            <tr th:each="ponto, index: ${tool.distributionPoints}">                                <td th:value="${ponto.id}" th:field="${tool.distributionPoints[index]}" th:text="${ponto.distributionPoint}"></td>                            </tr>                        </table> <div class="row col-md-6">                            <select id="distributionPoint" th:object="${distributionPoints}" class="form-control">                                <option></option>                                <option  th:id="${ponto.id}" th:each="ponto : ${distributionPoints}" th:value="${ponto.id}" th:text="${ponto.distributionPoint}"></option>                            </select>                            <input id="AddPonto" type="button" value="Add" name="Add" onclick="AdddistributionPoint()"/>                            <input id="RemovePonto" type="button" value="Remove"   name="Remove" onclick="RemovedistributionPoint()" /> </div> </div> .... </form> <script>            function AdddistributionPoint()            {                var ponto = $("#distributionPoint option:selected").text();                var pontoId = $("#distributionPoint option:selected").attr('id');                var pontoClean = cleanString(ponto);                var rows =  $('#tabledistributionPoints tr').length -1;                if (ponto.toString() !== "") {                                        //                    if ($("#tabledistributionPoints").find('#' + pontoClean).length === 0) {                          var k = '<input th:field="${tool.distributionPoints['+rows+'].id}" th:value="'+ponto+'"  th:name="${ponto.distributionPoint}" th:text="'+ponto+'" value="'+ponto+'" type="text" readonly="readonly "> </>';                                            $("#tabledistributionPoints > tBody:last").append(                            '<tr><td id=' + pontoClean + '   >' + k + '</td></tr>'                        );                    }                }                $("#tabledistributionPoints").on('click', 'tr', function () {                    $(this).addClass("clicked").siblings().removeClass("clicked");                });            }            ;            function RemovedistributionPoint() {                var rowCount = $("#tabledistributionPoints tr").length;                if (rowCount > 1) {                    var selected = $('#tabledistributionPoints > tbody > tr.clicked');                    if (selected !== null && selected.length > 0) {                        selected.remove();                    } else {                        $('#tabledistributionPoints  tr:last').remove();                    }                }            }            ;        </script>



   @GetMapping("/tools/add")    public ModelAndView formadd() {        ModelAndView mv = new ModelAndView("addtool");        Tool tool = new Tool();        mv.addObject(doc);        mv.addObject("distributionPoints",pontoDistribuicaoDAO.findAll());        return mv;    }    /**     * Save the tool object.     *     * @param tool     * @return     */    @RequestMapping(value = "/tools/add", method = RequestMethod.POST)    public String salvar(tool tool) {              System.out.println(tool.getdistributionPoints());                this.toolDAO.save(tool);                return "redirect:/tools";    }

Problem

Stuck on implementing change of schema after user login, following a StackOverFlow.

Description


Im following the stackoverflow solution at: https://stackoverflow.com/questions/39357367/change-database-schema-during-runtime-based-on-logged-in-user

The spring version im using is: :

   : Spring Boot ::        (v2.3.3.RELEASE)

I've created the class below. But I have no idea on how to use it properly.

What im trying to achieve is:

Springboot initializes in a default login database URL.
After login, it should use the class below to define which schema it should use based on the UserDetails class.

Im stuck. Im reading every tutorial, book I can find but im stuck. Please helpp


      import com.google.common.cache.CacheBuilder; import com.google.common.cache.CacheLoader; import com.google.common.cache.LoadingCache; import java.sql.Connection; import java.sql.ConnectionBuilder; import java.sql.SQLException; import java.util.concurrent.TimeUnit; import javax.sql.DataSource; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.jdbc.DataSourceBuilder; import org.springframework.core.env.Environment; import org.springframework.jdbc.datasource.AbstractDataSource; public class UserSchemaAwareRoutingDataSource extends AbstractDataSource {    @Autowired    UsuarioProvider customUserDetails;    @Autowired    Environment env;    private LoadingCache<String, DataSource> dataSources = createCache();    public UserSchemaAwareRoutingDataSource() {    }    public UserSchemaAwareRoutingDataSource(UsuarioProvider customUserDetails, Environment env) {        this.customUserDetails = customUserDetails;        this.env = env;    }    private LoadingCache<String, DataSource> createCache() {        return CacheBuilder.newBuilder()                .maximumSize(100)                .expireAfterWrite(10, TimeUnit.MINUTES)                .build(                        new CacheLoader<String, DataSource>() {                    public DataSource load(String key) throws Exception {                        return buildDataSourceForSchema(key);                    }                });    }    private DataSource buildDataSourceForSchema(String schema) {        System.out.println("schema:" + schema);        String url = "jdbc:mysql://REDACTED.com/" + schema;        String username = env.getRequiredProperty("spring.datasource.username");        String password = env.getRequiredProperty("spring.datasource.password");        System.out.println("Flag A");        DataSource build = (DataSource) DataSourceBuilder.create()                .driverClassName(env.getRequiredProperty("spring.datasource.driverClassName"))                .username(username)                .password(password)                .url(url)                .build();        System.out.println("Flag B");        return build;    }    @Override    public Connection getConnection() throws SQLException {        return determineTargetDataSource().getConnection();    }    @Override    public Connection getConnection(String username, String password) throws SQLException {        return determineTargetDataSource().getConnection(username, password);    }    private DataSource determineTargetDataSource() {        try {            Usuario usuario = customUserDetails.customUserDetails();            //            String db_schema = usuario.getTunnel().getDb_schema();            //            String schema = db_schema;            return dataSources.get(schema);        } catch (Exception ex) {            ex.printStackTrace();        }        return null;    }    @Override    public ConnectionBuilder createConnectionBuilder() throws SQLException {        return super.createConnectionBuilder();    } }

Hi!
I came up with a partial solution.

What Im planning to do is:

-Connect the spring boot directly to the login schema.
-Set up spring boot to use my custom User class.

-Login

-Change schema based on the login information.

--
Im a bit stuck on this part:
-Change schema based on the login information.

I found some information regarding people wanting to use 2 or 3 databases but in my case, it could be 'n' schemas GLOBALLY depending on which user log-in.

I have a message to my past self:

You can use Platform.isFxApplicationThread() to check if you are working on the UI thread or not.
You dont need or shouldnt  use Platform.runLater if you are already inside a UI thread.



https://docs.oracle.com/javase/8/javafx/api/javafx/application/Platform.html

You can use:

String s = Platform.isFxApplicationThread() ? "UI Thread" : "Background Thread";
System.out.println(s);

Inside a thread to find out whats going on.

Also, note that, when you are inside the @FXML initialize() method, you are in a UI thread. Which can be confirmed by the method above.

Question
How do I set up a custom login with Spring Boot? I need to use the same connection method of a legacy app I have.




Things to know before I explain

-I have a javafx App that connects to a data base using a php website as proxy/Login
-Obviously, this javafx app has the User class already defined.
-The javafx  application logs in with the web service and retrieves the database URL.
-The javafx  application uses the database URL to access a database directly.

Or, to simplify: The user put the login and password and click LOGIN -> The app,  goes to the webhost, sends the data to a certain php file and requests the database url and data that comes ENCRYPTED through JASPYR and it also comes through https. Once the data is returned, we decrypt it and login to the database directly.


-Im building a SpringBoot application to work with this legacy app.


Where Am I stuck?

I have built a Spring boot maven project and im reading a lot about Spring boot. My first step is to create a login page that behaves as the legacy app.

Currently, Im using a InMemorySecurityConfig as follows:

import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Configuration; import org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder; @Configuration public class InMemorySecurityConfig { @Autowired public void configureGlobal(AuthenticationManagerBuilder auth) throws Exception { auth.inMemoryAuthentication()                .withUser("user").password("{noop}123").roles("USER")                .and()                .withUser("admin").password("{noop}123").roles("ADMIN"); } }


I dont know how to start. I think I have to find away to define the correct User model and then use a class to login that actually allows me to manually login.




Here is the legacy class that I use on my javafx App below. How do I start to convert this to spring boot? Please help.

public JSONObject login(String usuario, String senha) throws MalformedURLException, IOException {        int timeout = 10;        RequestConfig config = RequestConfig.custom()                .setConnectTimeout(timeout * 1000)                .setConnectionRequestTimeout(timeout * 1000)                .setContentCompressionEnabled(true)                .setAuthenticationEnabled(true)                .setSocketTimeout(timeout * 1000)                .build();        CloseableHttpClient httpclient = HttpClientBuilder.create().setDefaultRequestConfig(config).build();        HttpPost httppost = new HttpPost(Settings.LOGIN_URL);        int CONNECTION_TIMEOUT_MS = timeout * 1000; // Timeout in millis.        RequestConfig requestConfig = RequestConfig.custom()                .setConnectionRequestTimeout(CONNECTION_TIMEOUT_MS)                .setConnectTimeout(CONNECTION_TIMEOUT_MS)                .setContentCompressionEnabled(true)                .setAuthenticationEnabled(true)                .setSocketTimeout(CONNECTION_TIMEOUT_MS)                .build();        httppost.setConfig(requestConfig);        // Request parameters and other properties.        ArrayList<NameValuePair> params = new ArrayList<NameValuePair>(2);        params.add(new BasicNameValuePair("usuario", usuario)); // user        params.add(new BasicNameValuePair("senha", senha)); // password        httppost.setEntity(new UrlEncodedFormEntity(params, "UTF-8"));        CloseableHttpResponse execute = null;        try {            execute = httpclient.execute(httppost);        } catch (Exception ex) {            try {                httppost.abort();                if (execute != null) {                    execute.close();                }            } catch (Exception x) {                ErrorLogger.log(x);            }            throw ex;        }        HttpEntity entity = execute.getEntity();        if (entity != null) {            JSONObject json = JsonTools.readJson(entity.getContent());                      return json;        }        return null;    }


@Override    protected Task<JSONObject> createTask() {        return new Task<JSONObject>() {            @Override            protected JSONObject call() throws InterruptedException, IOException {                StringProperty usuario = getUserName();                StringProperty senha = getPassword();                LoginDAO loginDAO = new LoginDAO();                JSONObject login = loginDAO.login(MyTools.encodeToBase64(usuario.get()), MyTools.encodeToBase64(senha.get()));                String db_url = login.getString("db_url");                String db_username = login.getString("db_username");                String db_password = login.getString("db_password");                String nomeEmpresa = login.getString("nomeEmpresa");                int idUsuario = login.getInt("idUsuario");                String nomeDoUsuario = login.getString("nomeUsuario");                int idTunnel = login.getInt("idTunnel");                Settings.setDb_password(db_password);                Settings.setDb_username(db_username);                Settings.setDb_url(db_url);                Settings.setDb_empresa(nomeEmpresa);                //Connect to the data base                HibernateUtil.init();                return login;            }        };    }


How do I start? Any tips on how to start is greatly appreciated.

Im expecting that I have to somehow tell spring boot which User class to use, to tell spring to NOT instantly connect to the database and wait for the database info to be retrieved by the login page, and a way to login using spring.




The following topic explains my login process: https://coderanch.com/t/731125/engineering/Encrypt-JAVA-jasypt-Decrypt-PHP


PS: If the topic is not clear, please let me know. English isnt my first language but im trying my best.
#ThisForumRocks



References:
https://coderanch.com/t/735809/frameworks/User-Authentication-Authorization-Spring-Boot

https://spring.io/guides/gs/securing-web/

https://coderanch.com/t/734572/databases/Changing-database-DNS-Cname-adjustment

Problem/Question

"Application developers need to update their connection strings to point to the new server, and your customers need to know the new server address as well."

I have a desktop software. This java software has the following logic:

1-User inserts username and password. He presses "login" button.The data is then sent to a web server for validation.

2-In case of success, a JSON is sent back to the java app with the database url, username, password and most importantly THE SCHEMA etc. Note that, while the server IP is normally the same, the schema changes, thats why the JSON sents the correct schema URL for the client.

3-The java app then uses information from the JSON to connect to the MySQL directly.

Thats how it works. However, Theres a problem:
When the software was installed, I had to ask the IT of a few companies  to make sure the mysql address, which is typically the same, to be allowed through the firewall.
And now, we are currently in need of changing our current database from Hosting X to Hosting Y.

So basically it falls to this:
If I want to move a database from one server to another, or stand up a new server and move everything over to it, I will have to ask each IT to allow the new IP on their firewalls.


Proposed Solution

Researching, Ive come up with a solution. Im not sure its valid So thats why I came here in the first place heh.

So here's the thing.

On step 2, described above, the JSON sends the database URL like this:

jdbc:mysql://192.X.X.X:3306/ACME_SCHEMA1

Where X was a number but Ive just redacted for the topic.

The solution is, for the JSON to deliver this instead:


jdbc:mysql://db.acme.com.br:3306/ACME_SCHEMA1


By doing that, I can change the Register of db.acme.com.br from hg.acme.com.br TO aws.acme.com.br.

And I can just ask every IT to allow db.acme.com.br in their firewalls. So whenever I change databases, their firewall wont disrupt the connection.

Will this work? I know its not perfect but im working with a Legacy software so the structure has to make do.

Thanks a lot!






References:


https://www.techrepublic.com/blog/data-center/use-the-dns-cname-for-database-connectivity/

https://port1433.com/2016/08/03/using-dns-aliases-to-manage-database-connections/

https://coderanch.com/t/731125/engineering/Encrypt-JAVA-jasypt-Decrypt-PHP

For my own use. But I also want to give back to the community.

Hello everyone,

I made a topic some hours ago that lead me to a public repository : https://github.com/biezhi/webp-io

However, I had to update the library used, cwebp and make changes to the code.
Since its my first public fork, I want it to be good enough so others can use it as well. I think its good to give back to the community.

My fork is located here: https://github.com/KenobySky/webp-io

I have questions and any help would  be appreciated. Critiques too.

1- Do I have to update POM with my data?
2- What other changes to the project, not code-related do I have to make?
3- When I try to include the project with gradle, I get a weird error:

maven {url "https://jitpack.io"} ... compile 'com.github.KenobySky:webp-io:master'

Execution failed for task ':compileJava'.
> Could not resolve all files for configuration ':compileClasspath'.
  > Could not find com.github.KenobySky:webp-io:master.
    Searched in the following locations:
      - https://repo.maven.apache.org/maven2/com/github/KenobySky/webp-io/master/webp-io-master.pom
    If the artifact you are trying to retrieve can be found in the repository but without metadata in 'Maven POM' format, you need to adjust the 'metadataSources { ... }' of the repository declaration.
    Required by:
        project :

* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

* Get more help at https://help.gradle.org

Thanks a lot.

I will report back once I get this feature rolling.
Hopefully will help others.

Tim Holloway wrote:Tone down the boldface a little. It makes it look like you are shouting. Your spacing is all that's needed to make your points visible.

You forgot a very common solution, which is to upload the images to an ordinary image file directory. So there's a third solution.

Although I should caution you that if you do that, don't upload into a directory within your WAR or your webapp server. That can fail or cause data to get lost when you update the WAR. Always upload to an external data directory. In Unix/Linux, the /var/lib directories are commonly used for purposes like that. For maximum flexibility, however, don't hard-code the upload directory path into the webapp logic. Put it in a webapp environment object so that you can set it when the app is deployed and the app can read it using JNDI.

As for S3, that's fine if you want to store images in the cloud. I'd say that storing images as BLOBs in a database would be last choice.

Alrighty. I tend to do that because well.. a known moose competitor forces users to write very styled texts or they downvote you hehe.

But, I cant store locally. Its Not possible due to restrictions.

Im looking into converting every image to webp with https://developers.google.com/speed/webp/download.

Ive just forked this https://github.com/biezhi/webp-io

Ive updated with the new binaries and im going to commit to my fork.