Grios - BLOG

jueves, 18 de septiembre de 2014

SQL Data Workshop v.0.8.6.r1 released!

A few hours ago, the new version 0.8.6.r1 of SQL Data Workshop was available on the sourceforge site.

The "r1" in this version means "revision 1" because some important bugs were corrected in this version.

Major changes include:

SQL Server Visual Editor issue was corrected.
Quick search over query results was implemented.
Now is posible load and save connection settings files in your storage drives and devices.
Connection dialog now displays a connection hint for each DBMS.
Aditional JDBC Drivers were added. Now is posible connect to CSV Files and Oracle-Thin-Client
Some icons were changed.
Minor issues was corrected.

Here some screenshots of this new version:

Improved Connection dialog.

Visual Query Editor minor issues corrected.

Fast-Query Results Search mechanism was implemented.

Also, a first-fast site attempt was designed. You can visit and leave your comments here: http://sqldw.sourceforge.net.

Direct download link is here: http://sourceforge.net/projects/sqldw/.

Greetings!

+ Miguel Angel

jueves, 21 de agosto de 2014

SQL Data Workshop ~~0.8.7~~ 0.8.6 is now released!

Changes include:

Visual Query Builder is now based on SQLeo 2014.07.rc1
Visual Queries now are builded by drag and drop table and view objects directly from the databases tree general panel.
Improved integration of SQLeo with SQL Data Workshop
Query pagination was implemented. This is done using the native dialect for each DBMS
Query results table and fields metadata were improved. They uses too a monospaced font in order to provide more clear read.
Data Analysis Project module was turned off until more and better features are implemented.
Toolbars were rearranged.
Aditional Drivers were added.
The Driver Specification File was improved by adding native dialect for pagination in each DBMS that supports it.
Export query data to text file now allows to the user to specify custom fields delimiters.
Application is now based on Java 8 and it is ready to use JavaFX features in next releases.

Next minor versión (0.8.6.1) will include:

Repair minor errors on current version
Add a fast-search feature that acts over the query results.
Implement some charts based on JavaFX

Here are some pictures of this new version

Visual query designer is better integrated:

Query results looks better:

Paginated results using native DBMS/SQL dialect:

You can download it from: http://sourceforge.net/projects/sqldw/

Greetings!

sábado, 5 de julio de 2014

Using webcam in your Java Applications without pain.

When you need to implement webcam access in your Java applications, the first thing to do is perform a google search: http://www.google.com.mx/webhp?q=java%20webcam&gws_rd=ssl#q=java+webcam

With that, a huge amount of results are found by the search engine. However, things can be confusing in the begining because a wide variety of methods to achieve the goal are described.

Luckly, I found a very easy method to achieve the goal in this blog: http://www.sleepingdumpling.com/blog/download/jvideoinput/. The method described by the author was very easy to implement compared with other solutions.

Based in the above description, I was able to wrote a java library in order to get access to webcam in desktop Java apps (swing/JavaFX) avoiding me and others to write a lot of repetitive code simplifying the work. You can download the library from sourceforge.

Swing example usage:

    import org.grios.swing.jwebcam.JWebCamSimple;

    public class Test extends javax.swing.JFrame
    {
        public Test()
        {
            String[] devices = null;
            initComponents();
            jwcs = new JWebCamSimple();

            try
            {
                devices = JWebCamSimple.getDeviceNames();
                for (String s : devices)
                    jComboBox1.addItem(s);
            } 
            catch (Exception e)
            {
                e.printStackTrace();
                System.exit(0);
            }
        }
        private void initComponents()
        {
            jLabel1 = new javax.swing.JLabel();
            jComboBox1 = new javax.swing.JComboBox();
            jButton1 = new javax.swing.JButton();
            jDesktopPane1 = new javax.swing.JDesktopPane();
            jInternalFrame1 = new javax.swing.JInternalFrame();
            jLabel2 = new javax.swing.JLabel();
            jButton2 = new javax.swing.JButton();

            setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

            jLabel1.setText("Available Devices:");

            jButton1.setText("Start");
            jButton1.addActionListener(new java.awt.event.ActionListener()
            {
                public void actionPerformed(java.awt.event.ActionEvent evt)
                {
                    jButton1ActionPerformed(evt);
                }
            });

            jDesktopPane1.setBackground(new java.awt.Color(255, 255, 255));

            jInternalFrame1.setMaximizable(true);
            jInternalFrame1.setResizable(true);
            jInternalFrame1.setTitle("No Device");
            jInternalFrame1.setVisible(true);

            jLabel2.setBackground(new java.awt.Color(255, 255, 255));
            jLabel2.setOpaque(true);
            jInternalFrame1.getContentPane().add(jLabel2, java.awt.BorderLayout.CENTER);

            jDesktopPane1.add(jInternalFrame1);
            jInternalFrame1.setBounds(10, 11, 160, 162);

            jButton2.setText("Stop");
            jButton2.addActionListener(new java.awt.event.ActionListener()
            {
                public void actionPerformed(java.awt.event.ActionEvent evt)
                {
                    jButton2ActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
            getContentPane().setLayout(layout);
            layout.setHorizontalGroup(
                layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jLabel1)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 188, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jButton1)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jButton2)
                    .addContainerGap(67, Short.MAX_VALUE))
                .addComponent(jDesktopPane1)
            );
            layout.setVerticalGroup(
                layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel1)
                        .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jButton1)
                        .addComponent(jButton2))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jDesktopPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 260, Short.MAX_VALUE))
            );

            setBounds(0, 0, 496, 339);
        }            

        private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)                                         
        {                                             
            try
            {
                jComboBox1.setEnabled(false);
                jButton1.setEnabled(false);
                jwcs.start(jComboBox1.getSelectedItem().toString(), jLabel2);

            } 
            catch (Exception e)
            {
                e.printStackTrace();
                System.exit(0);
            }
        }                                        

        private void jButton2ActionPerformed(java.awt.event.ActionEvent evt)                                         
        {                                             
            if (jwcs.isRunning())
                jwcs.stop();            

            jButton1.setEnabled(true);
            jComboBox1.setEnabled(true);
        }                                        

        public static void main(String args[])
        {
                    try
                    {
                            javax.swing.UIManager.setLookAndFeel(javax.swing.UIManager.getSystemLookAndFeelClassName());
                    }
                    catch (Exception ex)
                    {
                    }
            java.awt.EventQueue.invokeLater(new Runnable()
            {
                public void run()
                {
                    new Test().setVisible(true);
                }
            });
        }

        private javax.swing.JButton jButton1;
        private javax.swing.JButton jButton2;
        private javax.swing.JComboBox jComboBox1;
        private javax.swing.JDesktopPane jDesktopPane1;
        private javax.swing.JInternalFrame jInternalFrame1;
        private javax.swing.JLabel jLabel1;
        private javax.swing.JLabel jLabel2;    
        JWebCamSimple jwcs;
    }

On the above code, in line 151 we are declaring a JWebCamSimple object named jwcs. With JWebCamSimple we will able to play our web cam after of create an instance of it (line 9).
Finally, you can start the webcam calling to start() (line 107) method by passing two arguments:

The Device Name, specified as a String value.
The Swing component (JComponent) where the webcam video will be displayed. The most easy solution is passing a JLabel object.

For the device name, you sould let the user to select the video device. In above example, this is done firstly on lines 13-15, where the program ask for the video devices available (line 13) and after, a JComboBox object is filled with each found device's name (lines 14 and 15).

And a JavaFX example:

        import javafx.application.Application;
        import javafx.collections.FXCollections;
        import javafx.geometry.Insets;
        import javafx.scene.Scene;
        import javafx.scene.control.Button;
        import javafx.scene.control.ComboBox;
        import javafx.scene.control.Label;
        import javafx.scene.image.ImageView;
        import javafx.scene.layout.BorderPane;
        import javafx.scene.layout.ColumnConstraints;
        import javafx.scene.layout.GridPane;
        import javafx.scene.layout.Priority;
        import javafx.scene.layout.RowConstraints;
        import javafx.stage.Stage;
        import org.grios.jwebcam.fx.FXWebCamSimple;

        public class Test extends Application
        {   
            Scene scene;
            BorderPane mainPane;
            GridPane topPane;
            ComboBox<String> cmbVideoDevices;
            Label lblVideoDevices;
            ImageView imgvDisplay;
            Button btnStartDevice;
            Button btnStopDevice;

            FXWebCamSimple fxWebCam;   

           Override
            public void start(Stage primaryStage) throws Exception
            {
                initComponents();

                scene = new Scene(mainPane);
                primaryStage.setWidth(480);
                primaryStage.setHeight(240);
                primaryStage.setTitle("JWebCamFX Demo");
                primaryStage.setScene(scene);
                primaryStage.setOnCloseRequest((evt) -&gt;
                {
                    System.exit(0);
                });
                primaryStage.show();

                fxWebCam = new FXWebCamSimple();

            }

            private void initComponents()
            {
                lblVideoDevices = new Label("Available Video Devices:");
                cmbVideoDevices = new ComboBox<String>(FXCollections.observableArrayList());
                btnStartDevice = new Button("Start");
                btnStopDevice = new Button("Stop");
                imgvDisplay = new ImageView();        

                lblVideoDevices.setPrefSize(135, 21);
                cmbVideoDevices.setPrefSize(140, 21);
                btnStartDevice.setPrefSize(50, 21);
                btnStopDevice.setPrefSize(50, 21);

                btnStartDevice.setOnAction((evt) -&gt; 
                {

                    try
                    {
                        btnStartDevice.setDisable(true);
                        lblVideoDevices.setDisable(true);
                        cmbVideoDevices.setDisable(true);

                        fxWebCam.start(cmbVideoDevices.getSelectionModel().getSelectedItem(), imgvDisplay);
                    } 
                    catch (Exception e)
                    {
                        e.printStackTrace();
                        System.exit(0);
                    }
                });

                btnStopDevice.setOnAction((evt) -&gt;
                {
                    try
                    {
                        fxWebCam.stop();                
                        btnStartDevice.setDisable(false);
                        lblVideoDevices.setDisable(false);
                        cmbVideoDevices.setDisable(false);
                    } 
                    catch (Exception e)
                    {
                        e.printStackTrace();
                        System.exit(0);
                    }
                });


                fillComboBox();

                topPane = new GridPane();
                topPane.setPadding(new Insets(5));
                topPane.setHgap(10);
                topPane.setVgap(10);
                topPane.add(lblVideoDevices, 0, 0);
                topPane.add(cmbVideoDevices, 1, 0);
                topPane.add(btnStartDevice, 2, 0);
                topPane.add(btnStopDevice, 3, 0);

                mainPane = new BorderPane();
                imgvDisplay.fitWidthProperty().bind(mainPane.widthProperty());
                imgvDisplay.fitHeightProperty().bind(mainPane.heightProperty());
                imgvDisplay.setSmooth(true);
                imgvDisplay.setCache(true);
                mainPane.setCenter(imgvDisplay);
                mainPane.setTop(topPane);
            }

            private void fillComboBox()
            {
                try
                {
                    cmbVideoDevices.getItems().clear();
                    for (String str : FXWebCamSimple.getDeviceNames())
                        cmbVideoDevices.getItems().add(str);
                    if (cmbVideoDevices.getItems().size() &gt; 0)
                        cmbVideoDevices.getSelectionModel().selectFirst();
                } 
                catch (Exception e)
                {
                    e.printStackTrace();
                    System.exit(0);
                }
            }

            public static void main(String[] args)
            {
                launch(args);
            }
        }

Good luck!

+ Grios

domingo, 1 de diciembre de 2013

SQL Data Workshop - First version (0.8.5) released

Approximately, eighteen months ago, I began to work with SQL queries that returned large data amounts. The database server was SQL Server 2005 and I used the SQL Server Management Studio 2005 and 2008 with no successful results.

Then, in my free times I developed a small application using java and swing in order to execute those queries. This time, I have success. This is a screenshot of the very earlier versions with it’s initial name “Bringer Query Executor”:

Over time, I was adding more features. At the beginning of this year, I realized that I could share this application with more people if I made some adjusts and improvements to the GUI (graphical user interface) and correct some errors and bugs.

For the GUI, I began using the flamingo ribbon bar but, I felt the application's performance very poor. Interacting with controls and it's response was not good. Additionally, I do not found some way to remove the ribbon’s upper toolbar when using other look and feel that substance.

This is a screenshot of the application using the native look and feel under Windows 7 Operating System:

The same application with substance look and feel:

But, using the substance look and feel, sometimes the application freezes unexpectedly or throws a Java Heap Memory Exception.

Then, I decided to leave the GUI ribbon-based approach and tried the jidesoft framework (http://www.jidesoft.com). This time, the application has a very good performance.

The latest feature that I added it was a visual query engine. I implemented this engine based on the SQL Leonardo application (https://sourceforge.net/projects/sqleo/).

Finally, I host it in sourceforge: http://sourceforge.net/projects/sqldw/.

Here are some screenshots.

This is the main application window running on Windows 7:

The Visual Query Builder running on Ubuntu Linux:

The results populated by the query:

A correlation matrix calculated using values retrieved by a query:

A grouped histogram chart using the integrated charting feature:

A scatter chart using a short dataset:

A scientific scatter chart using a large dataset:

And finaly, a spider-web chart:

There are some of the program's features. But, there are more to explore.

At this moment, last released version is 0.8.5.2.

Changes in 0.8.5.2 compared with 0.8.5.1, are related only with certain parts of code in order to provide back compatibility with jre 1.6.x. This changes were made because many users ask me for compatibility at least with jdk 1.6.x.

I'm planning improvements and major changes for the next version. For example, I'm thinking seriously to write some parts using java fx, including css stylying in order to integrate uniformly the jide native swing look and feel with the new javafx controls. Another change includes too quit the current statistical core and replace it by the apache commons math library since it is more robust and efficient for nearly all tasks. But, until all this changes are commited, I hope that you enjoy work with this current version (0.8.5.x).

Thanks to +Dolores Juárez by support with the project documentation. Now, she is in charge for the user experience improvements.

Greetings!

+ M. Angel

domingo, 5 de febrero de 2012

Primera versión de JGreep

A través de esta entrada quiero compartir con la comunidad una pequeña herramienta que desarrollé hace tiempo para buscar palabras dentro de archivos de texto. No tengo la menor duda de que actualmente puedo encontrar casi infinitas opciones "googleando". Sin embargo, cuando tuve la necesidad de esas herramientas, curiosamente no encontré una que me agradara. Lo que más extrañaba en ese momento era el comando "greep" de linux ya que soy usuario de windows principalmente. Así que comencé a desarrollar una herramienta para lo que necesitaba. Con el tiempo, añadí un par de funcionalidades, corregí algunos errores de programación, le dí una "pintada" más "mona" a la interfaz y la publiqué en la red con todo y código fuente por si a alguien más pudiera serle útil. He aquí un pantallazo de la interfaz de la herramienta:

Una vez explicado el génesis de este proyecto, os comento de la utilidad. Esta herramienta está diseñada para buscar palabras dentro de archivos de texto plano. Esta construida completamente en Java. Para utilizarla simplemente hay que seleccionar un directorio y la aplicación carga todos los archivos encontrados en ese directorio con la opción de cargar archivos en directorios anidados:

Una vez que la carga de archivos termina, se escribe el término o palabra que se desea buscar y la herramienta comienza a realizar una búsqueda de esa palabra dentro de los archivos previamente cargados:

Adicionalmente, la aplicación permite ordenar los datos por cualquier campo así como también el uso de filtros para mostrar solo aquellos archivos que coinciden con un criterio de búsqueda:

Y como no podía faltar, permite visualizar el contenido de los archivos junto con las ocurrencias de la palabra buscada:

Finalmente, comentar que tiene soporte para el idioma español, inglés y alemán así como también agradecer a la gente de desarrollo de las librerías que utilicé en la herramienta:

Infonode Docking Windows

RSyntaxTextArea

A continuación os comparto la página del proyecto en sourceforge:

http://sourceforge.net/projects/jgreep/

Quedo a la espera de vuestros comentarios y sugerencias.

Saludos y hasta pronto en la siguiente entrega, que espero no tarde tanto.

domingo, 26 de septiembre de 2010

Publicada la Versión 0.3 de jgrial.

Pues como el título lo dice, he publicado ya la versión 0.3 de mi librería jgrial para Java, la cual sirve básicamente para graficar grandes volúmenes de información con un buen desempeño, ya que el proceso se realiza a través de llamadas a OpenGL.

He aprovechado también, para cambiar el nombre de la librería, de gschart a jgrial, debido a que ya hay un proyecto con el nombre gschart.

sábado, 21 de agosto de 2010

Primera versión alfa de gschart: Mi librería de graficación OpenGL para Java

Después de varios meses sin actividad en el blog, pongo a vuestra disposición una librería en versión alfa para graficar grandes cantidades de datos utilizando la potencia de la aceleración gráfica basada en OpenGL para Java.