Select the Data tab to browse your table data:ĭBeaver is a free and open source cross-platform multi-purpose database tool with built-in support for CrateDB. Using this tree menu, navigate to doc, Tables, tweets: Once the driver files are downloaded, DBeaver should connect to CrateDB and a tree menu will be shown in the left-hand pane. On the next screen, all you have to change is the username and password.ĭBeaver will then prompt you to download and install the CrateDB driver files: From this window, select SQL from the tabbed menu on the left-hand side, and then select CrateDB: When you open DBeaver for the first time, you will be prompted to create a new database connection.
#DBEAVER JDBC DRIVER MAC OS X#
I'm running macOS, so I chose the Mac OS X (dmg) download for the Community Edition 6.0.3.
Head over to the DBeaver download page and select the version you want to download. You should end up here:įrom here, you can select QUERY TABLE, and then EXECUTE QUERY on the following screen to get a table view of your data: Once you're done, select the Tables icon from the left-hand navigation, and then select the tweets table. All this does is import a bunch of recent public tweets on Twitter. This isn’t going to post anything on your behalf. Select IMPORT TWEETS FOR TESTING and follow the instructions to authenticate your Twitter account.ĭon't worry. So head on over to the Help screen by selecting the question mark icon on the left-hand navigation menu. If you’re playing around with a fresh CrateDB install, chances are you don't have any data. If you're using the command above, it should pop open the CrateDB admin UI for you automatically once it has finished. If you'd like to actually install CrateDB a bit more permanently, or you are using Windows, check out our collection of one-step install guides. This will download CrateDB (version 3.3.2 at the time of writing) and runs it from the tarball.
Run this command: $ bash -c "$(curl -L )" If you don't already have CrateDB running locally, it's very easy to get set up. But these instructions should be trivially adaptable for Linux or Windows.
#DBEAVER JDBC DRIVER HOW TO#
In this post, I will show you how to get started with CrateDB and DBeaver as a desktop client for macOS. It runs on any platform and supports any database with a JDBC driver. CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.īecause CrateDB provides a JDBC driver, you can access CrateDB with any client tool that supports JDBC drivers.įor example: DBeaver is free and open source database tool for developers and database administrators.
0 kommentar(er)
