Using ColdFusion's CFDBInfo to Dynamically Output Database Columns and Tables

The ColdFusion tag CFDBInfo was introduced in ColdFusion 8. I finally got around to playing with it and thought someone other than me might find this useful.


<!--- this dsn is used throughout the examples --->
<cfset REQUEST.dsn="cfartgallery" />

<!--- databases --->
<h4>DATABASES</h4>
<cfdbinfo datasource="#REQUEST.dsn#" name="getDBs" type="dbnames" />
<cfdump var="#getDBs#" />

This should return something similar to:

List all tables associated with the dsn:


<!--- tables --->
<h4>ALL TABLES</h4>
<cfdbinfo datasource="#REQUEST.dsn#" name="getTables" type="tables" />
<cfdump var="#getTables#" />

You should now see something similar to:

As you can see, you might not want all tables returned. So, unless you want or need information on all of the system tables, you could use something like this:


<h4>NON SYSTEM TABLES</h4>
<!--- using query of query to scrap any sys tables --->
<cfquery name="getNonSysTables" dbtype="query">
SELECT REMARKS, TABLE_NAME, TABLE_TYPE
FROM getTables
WHERE TABLE_TYPE <> 'SYSTEM TABLE'
</cfquery>
<cfdump var="#getNonSysTables#" />

Now you should see this:

Dynamically generate all tables along with its detailed information:


<!--- columns --->
<h4>ALL TABLES: DETAILS</h4>
<hr size="1" />
<cfoutput query="getTables">
    <h4>#getTables.TABLE_NAME#</h4>
    <cfdbinfo datasource="#REQUEST.dsn#" name="getColumns" type="columns" table="#getTables.TABLE_NAME#" />
    <cfdump var="#getColumns#" />
</cfoutput>

This begins to generate a long list of tables and the info:

Once again, maybe you don't want all tables. If that's the case, then you could use a method similar to the following to ignore system tables:


<h4>NON-SYS TABLES: DETAILS (Using CFIF on getTables query)</h4>
<hr size="1" />
<cfoutput query="getTables">
    <!--- scrap the system tables --->
    <cfif left(getTables.TABLE_NAME, 3) NEQ 'SYS'>
        <h4>#getTables.TABLE_NAME#</h4>
        <cfdbinfo datasource="#REQUEST.dsn#" name="getColumns" type="columns" table="#getTables.TABLE_NAME#" />
        <cfdump var="#getColumns#" />
    </cfif>
</cfoutput>

Here you'll see only non-system tables and their related information:

And yet, another method to list non-system related tables:


<h4>NON-SYS TABLES: DETAILS (Using output of Query of Query - getNonSysTables)</h4>
<hr size="1" />
<cfoutput query="getNonSysTables">
    <h4>#getNonSysTables.TABLE_NAME#</h4>
    <cfdbinfo datasource="#REQUEST.dsn#" name="getColumns" type="columns" table="#getNonSysTables.TABLE_NAME#" />
    <cfdump var="#getColumns#" />
</cfoutput>

As you can see, CFDBInfo is quite a powerful little tag which can return a ton of useful information. Hope it helps you in your next project. Enjoy!

Comments
Steve, good stuff. Thanks. I was just looking at cfdbinfo the other day. You are doing some things here with it that I had not thought of. Very nice.

On of the things I do not like about cfdbinfo is too slow to run in production. But since most of the metadata about a DB does not change, you got me thinking, would it make sense to run the cfdbinfo queries in onApplicationStart() and store the results in the Application Scope. Then run the Query-of-Queries against the cached results.

I think this would greatly improve performance if you were to use these things in production. What do you think?
# Posted By Jason Dean | 9/18/08 10:46 AM
@Jason,
I suppose it would depend on how you would want to use the information. As you pointed out, once a database has been created, the general structure _usually_ doesn't change much (unless you're creating tables on the fly, etc.). Another point you made is true, I noticed how sluggish ColdFusion seems when running some of these "queries."

I used some of the similar methods to quickly obtain info on a db that I didn't have access to otherwise (i.e., using SQL Server Management Studio or MySQL Admin, etc.). I wasn't necessarily using the code in a production app, but needed the information to see the db structure (tables, keys, relationships ...). CFDBInfo worked like a charm in this case.

So, I guess the roundabout answer to your question is I'm not sure if I would use it in a production app specifically. I would have to think more about exactly _how_ to use it in that way. The only thing I would have (at this point anyway) about storing it in the Application scope would be possible security issues. If you don't recommend storing things like your DSN in your App scope, then I probably wouldn't want to keep a complete schema of my db in there either. I'll have to think about this a bit more.

Nevertheless, I sure am glad to have CFDBInfo in my CFToolbox.
# Posted By Stephen Withington | 9/18/08 11:32 AM
@Jason,
Something else I thought of though and I'm not exactly sure if this would work per se, but ...

What if you could use the information obtained in the CFDBInfo query, and then dynamically create an XML file which contains all of the tables and their relationships? Also, how could something like this help someone using ORM (i.e., Transfer, DataFaucet, etc.)?
# Posted By Stephen Withington | 9/18/08 11:41 AM
That's along the lines of what I was think. I was thinking of the Validator object that Brian Kotek discusses in the comments of this post http://tinyurl.com/3h6968
# Posted By Jason Dean | 9/18/08 12:22 PM
@Jason,
Ahh, ok. Yeah, that makes perfect sense. Pretty cool actually. Now, who's gonna build it? ;-)
# Posted By Stephen Withington | 9/18/08 12:52 PM
Well I was a little hesitant to comment at first (who me?), but since DataFaucet's already been mentioned. :P

I'm pretty certain actually that I was the person who submitted the ER that resulted in CFDBInfo during the CF8 alpha. Of course I wasn't the first person to use metadata with CF. Even on CF5, Claude Schneegans had published an ODBC-based CFX tag for getting meta data. I'd been doing some metadata stuff *without* ODBC on CF5 that was really cryptic and slow because it relied on doing something different to get the metadata for each type of db. And then once MX had been released it became a lot easier. I was ecstatic when I was finally able to use JDBC and the technique became semi-consistent. But you still have to watch out for inconsistencies because different databases still return non-standard data, like MS SQL Server returns "int identity" as the data type for a column, which is non-standard.

I think I also wrote the first major article on the use of metadata for CFDJ shortly after that and it's interesting because that was my first article and because it almost didn't happen. The editor felt the original proposal was too advanced for their readers and then later someone else recommended I resubmit and I think put in a recommendation for me and it got accepted. At the time the article ended up with a short glossary of OO terms that you generally wouldn't find in any recent articles for ColdFusion. How the community has changed! :)

But that's enough history (and ego stroking). :) With regard to DataFaucet, metadata is still gathered via JDBC directly rather than through CFDBInfo. I feel a little guilty honestly because I was going through a rough time in 2006 and basically dropped out of the alpha about the time the tag was added, without testing it. And it wasn't until much later that I got around to looking at it and realized that it wasn't realy compatible with the tools I'd already built. I do want at some point to have a version of DataFaucet that uses CFDBInfo so that it will work across all the CFML engines once they all implement the tag. But up to this point that hasn't managed to get up to the top of my to do list.

With regard to caching metadata, yes DataFaucet does. It doesn't write any XML files, it just caches it in memory. I don't think table names are cached, because that method isn't used with enough frequency to be problematic. What does get cached are the column definitions and primary and foreign key constraint information (the latter being the biggest problem with converting for me).

@Jason - personally I don't like the idea of loading the metadata onApplicationStart, simply because it could be a lot of data and the odds are you're not going to need all of it on whatever page initializes the application (and of course, you never know what page people will enter on, so you don't know what page will start the app). I much prefer a "lazy loading" system, where the app just loads up a metadata object onApplicationStart and then as data for different tables become needed it then performs the fetch and cashes it for the next time, the same way IoC frameworks like ColdSpring work for example.

And actually I just recently managed to get the same sort of lazy-loading thing to work for my function libraries in the latest version of the onTap framework, which has significantly improved performance on CF8. But not on CF7 because the lazy-loading libraries only work with onMissingMethod. :) But none the less I've been pretty happy about being able to finally get the libraries to load on-demand the way I always wanted them to. :)

I will say that the DataFaucet ORM strategy tends to be a bit different than other ORMs. The traditional philosophy is to start with an object model and deliberately force yourself to not think about any kind of data structure and then later make the database match your object model. And there's not necessarily anything wrong with that approach, although I disagree with the OO purists who say that all forms of thought that are not OO are obviously inferior in every way across all use cases to OO theory and therefore should never be allowed. I just don't find that kind of arbitrary rigidness to be a practical or useful ideology. DataFaucet will actually go both directions. You can choose to model the db off of your objects (and the ORM will even create tables for you), or you can go the other direction if you happen to already have a database (which as Brian Rinaldi pointed out after our CFUG meeting the other day is often the request from your employer), and then model the objects to populate the database.

I just released a scaffolding tool for the onTap framework last week or so that generates CFCs and views from your database schema (something PLUM also does). I probably won't be using the scaffolding tool myself, not because it creates bad code, but because I personally find it easier to just write the files out myself. I will however maintain it and add features if people request them. :)

But getting back to the comments about metadata ('cause I'm getting off-track again), my understanding of Transfer is that it's based on that notion of always starting with business objects and then creating a database schema to support that model, although it doesn't create tables (at least currently). And so when you use Transfer, you've got to create your database and then create an XML config file for Transfer separately that shows how each column in the database maps to each property in your business objects. And if you wanted to speed that up I suppose you could use CFDBInfo as the engine for a code generator that would generate your Transfer config. Though many OO purists would likely say that defeats the purpose of using an ORM tool like Transfer, because that means you're using non-OO thought (a relational db schema) to generate your objects. (See, there is a method to my madness.) :)
# Posted By ike | 9/18/08 3:45 PM
@Stephen - if you'd rather, I can copy this comment into the DataFaucet blog and you can replace this with a link over there instead?
# Posted By ike | 9/18/08 3:46 PM
p.s. not sure I clarified -- was thinking about the comment about how it could help someone using an ORM and I mentioned that with regard to Transfer at the end, but what I omitted is that DataFaucet kind of goes the other direction. It lets you get this info from the ORM, rather than getting it to help you use the ORM. And that allows the ORM to automate a lot of things that normally would require some kind of configuration. So it's actually eliminating the need to do a lot of config coding because it already has that meta data.
# Posted By ike | 9/18/08 3:55 PM
@ike,
First, thank you for submitting the enhancement request for CFDBInfo way back when. It's certainly a most useful tool. Especially, as I indicated earlier, when you need/want to know facts about a preexisting database that can't be accessed (for whatever reason) in the typical ways.

Secondly, thanks also for all of the other information. I've only recently begun to look at ORMs and DataFaucet definitely looks impressive. Having spent so much time learning and working with SQL, I guess it's just difficult to "give up" some of the tasks I enjoy doing ... such as building databases, writing the queries, etc. I can definitely see the value in using DataFaucet, and I should really spend some time to learn more about it.

You can copy the comment into the DataFaucet blog if you want, but I think it's definitely pertinent and useful here as well.

I also know very little about Transfer, but if it has an XML config file, then I agree that CFDBInfo (or it's underlying java methods) could be used to dynamically generate it.

I also want to learn more about Hibernate (http://www.hibernate.org/). I understand CF9 is going to have full support for Hibernate and I wonder what, if any, impact this might have on projects such as DataFaucet or Transfer. Just curious.

Anyway, thank you very much Isaac for your comments! Much appreciated.
# Posted By Stephen Withington | 9/19/08 7:39 AM
@Steve: Not sure about Doug Hughes (Reactor) or Steve Bryant (DataMgr) but I know that at least Mark Mandel (Transfer) and myself have written blog entries discussing our thoughts regarding the Transfer integration in ColdFusion 9.

Here's Mark's http://www.compoundtheory.com/?action=displayPost&...

And here are my biases :) http://datafaucet.riaforge.org/blog/index.cfm/2008...

Re: "giving up SQL": Y'know, there are a lot of ColdFusion programmers who've made those sorts of comments about using an ORM system. I actually just finished up an article for the next FAQU that talks about some of the theory behind ORM and gives some fairly general information about the various ORMs that are available. Truth is using an ORM really wouldn't take SQL away from you if you didn't want it to.

Something I didn't realize until Mark fact-checked the article is that Transfer has some custom tags for executing TQL that make it nearly identical to standard cfquery tags. TQL in the current version only works for select statements (no insert/update/delete), but it's on the roadmap and you can always get the datasource bean and use that to execute some standard cfquery tags if there's something you find difficult or unavailable with the Transfer features.

It's a similar story as far as I know for Reactor although the feature set and the syntax are fairly different.

Beyond that FourQ and DataFaucet both started out actually as attempts to abstract the SQL language on a lower level. So with DataFaucet you should be able to do most anything you can do with standard SQL, including joins, aggregates, concatenation and unions. I've strived to make the syntax for it intuitive from the perspective of someone who knows SQL, so ideally you should be able to look at some DF syntax and have a pretty good idea right away what it's doing -- ideally you'll see the SQL in your head, although you can also use statement.getSyntax() to actually return the SQL.

DataMgr isn't technically an ORM, but same sort of deal.
# Posted By ike | 9/19/08 11:02 AM
@ike,

Thanks again for pointing me towards more useful info! Both Mark and yourself make valid points regarding CF9+Hibernate.

Besides, Hibernate would be another animal for us CFers to learn if we're not already familiar with it. And from what I've seen so far, DataFaucet appears to be a fairly easy syntax to pick up and use. Again, I really need to take time to learn more about ORMs, and more specifically DataFaucet. ORMs definitely appear to be able to shorten development time _and_ lines of code.
# Posted By Stephen Withington | 9/19/08 11:36 AM
@Steve: yeah, definitely check out a couple and find one you like. At some point in the not too distant future I expect to be working on making the DDL support in DF a little more robust so it can have a schema-sync tool like the one that comes with DataMgr. And I know Mark seemed fairly impressed by DF's and/or keyword filtering. I believe his comment was "/me steals". :P

So we do get ideas from each other, though the syntax for doing things varies a lot from one to the next. And if it's syntax you're going to be using regularly, you want to make it something that you find logical to follow so you can spend your time working on your business model and not so much on trying to figure out your ORM tools. :)

Even in the FAQU article that's coming up I pointed out that where there's a small learning curve for DataFaucet, the learning curve for Transfer's TQL custom tags is almost nothing for someone familiar with CFML. So I'll readily admit when I see advantages to using someone else's tools. :)
# Posted By ike | 9/19/08 12:12 PM
Steve, you are a genius and my new best friend forever! VERY HELPFUL!!
# Posted By Kevin B | 12/22/12 4:43 AM
CFDBInfo is becoming quite popular now. I've seen quite a few people, who work for the cheap essay writing companies, talk about this database, as well. So, I wonder whether it's the time for me to get this database or not.
# Posted By cheap essay writing companies | 4/5/18 7:07 PM
This is the "Little Prince" watch the http://www.replicawatchesshop.co.uk most basic one, junior three-pin date http://www.replicasonline.me.uk display, the price of more than 30,000 to get started is http://www.rolexsreplicas.org.uk not so difficult, it is suitable for little money or the http://www.replicawatches0.co.uk first time to buy the table Friends.
# Posted By vsvs | 5/14/18 9:19 PM

High-temperature silk https://www.finesthairextensions.co.uk material, fluffy and realistic, easy to https://www.moptopz.co.uk handle, elastic breathable mesh cap, adjustable elastic buckle, super comfortable https://www.leez-extensions.co.uk skin-friendly cotton, comfortable to wear, and another https://www.cheaphairforextensions.co.uk five-piece care set.
# Posted By real hair wigs | 8/30/18 2:48 AM
I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post.
# Posted By DJ udstyr | 10/3/18 1:44 PM
You delivered such an impressive piece to read, giving every subject enlightenment for us to gain information. Thanks for sharing such information with us due to which my several concepts have been cleared.
# Posted By jasa pembuatan website | 10/4/18 12:04 AM
Super-Duper site! I am Loving it!! Will come back again, Im taking your feed also, Thanks.
# Posted By location voiture marrakech | 10/5/18 5:52 AM
i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me.
# Posted By Limo companies in East Hampton | 10/5/18 6:44 AM
We do custom patches, embroidered patches, printed patches, custom Velcro patches, clothing labels, PVC patches, custom leather patches, custom keychains, and other promotional products.
# Posted By Custom Embroidered Patches | 10/5/18 9:40 PM
It was very difficult to reach our goal without their help.
# Posted By web design companies in new york | 10/5/18 11:55 PM
We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends.
# Posted By guest post blog directory | 10/7/18 5:09 AM
I have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks!
# Posted By aliens | 10/7/18 6:02 AM
You have done a great job on this article. It’s very readable and highly intelligent.
# Posted By http://www.schluesseldienstberlin.de/ | 10/9/18 9:23 PM
N'attendez plus pour appeler le 0892 22 20 33 et profiter enfin d'une expérience inestimable : une voyance gratuite amour pour votre avenir sentimental, votre couple ou votre travail ; des réponses claires, précises, efficaces et sans attente. Votre voyance par téléphone vous attend 24h sur 24 et 365 jours par an.

# Posted By voyance gratuite amour | 10/11/18 5:04 AM
What a thrilling post. It is extremely chock-full of useful information. Thanks for such a great info.
# Posted By 918Kiss | 10/12/18 5:46 AM
Fabulous post, you have denoted out some fantastic points, I likewise think this s a very wonderful website. I will visit again for more quality contents and also, recommend this site to all. Thanks.
# Posted By igienizare aer conditionat | 10/12/18 11:44 PM
I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks
# Posted By ABCya | 10/13/18 9:59 AM
thanks for giving us go through info.Fantastic nice. I appreciate this post.
# Posted By Herbal Incense | 10/14/18 9:46 PM
Nos voyantes, voyants et médiums ont été selectionnés pour leur don. Vous pouvez compter sur leur capacité psychique, sur leur probité, sur leur honnêteté.
# Posted By voyance 20 | 10/15/18 10:01 AM
This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.
# Posted By Friv | 10/15/18 9:27 PM
Thank you for some other informative website. The place else may just I get that kind of information written in such a perfect method? I have a venture that I am simply now running on. and I’ve been at the glance out for such info
<a href="https://autoketing.com/project/sales-pop-master&qu...; pop up sales </a>
<a href="https://apps.shopify.com/sales-pop-master">...; recent sales notification popup</a>
<a href="https://autoketing.com/">; autoketing.com</a>
# Posted By Linh CP | 10/16/18 3:08 AM
Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else,
# Posted By www.alex1-berlin.de | 10/18/18 12:42 AM
Hey There. I found your blog using msn. This is a very well written article. I’ll be sure to bookmark it and come back to read more of your useful info. Thanks for the post. I’ll definitely return.
# Posted By http://www.tuk-design.de/ | 10/18/18 11:23 PM
Hi, I find reading this article a joy. It is extremely helpful and interesting and very much looking forward to reading more of your work..
# Posted By Grumpy cat memes | 10/20/18 2:41 AM
I'm glad to see the great detail here!.
# Posted By Theuniversitypapers.com | 10/20/18 6:14 AM
Our prices are affordable and they match a student budget. In addition, we have established a trusted brand where thousands of students rely on our services for success and improving academic standing.
# Posted By TUP Tutors- Do my master thesis help | 10/20/18 6:46 AM
I'm glad to see the great detail here!.
# Posted By Look MusicSkanner | 10/20/18 8:18 AM
It was very difficult to reach our goal without their help. Now the circle is around.
# Posted By www.MusicSkanner.com homepage | 10/20/18 9:33 AM
Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information.
# Posted By ABCya games | 10/20/18 10:08 PM
I am always looking for some free kinds of stuff over the internet. There are also some companies which give free samples. But after visiting your blog, I do not visit too many blogs. Thanks.
# Posted By location voiture marrakech aéroport | 10/21/18 12:29 AM
I will visit again for more quality contents and also, recommend this site to all. Thanks.
# Posted By location voiture marrakech pas cher | 10/21/18 1:10 AM
Great! it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot
<a href="https://autoketing.com/">; autoketing.com</a>
<a href="https://apps.shopify.com/shipping-bar-master?utm_s...; App Shipping Bar Master </a>
<a href="https://autoketing.com/project/shipping-bar-master...; Shipping Bar for Shopify </a>
# Posted By Linh CP | 10/21/18 11:45 PM
Perhaps you could write next articles referring to this article. I desire to read even more things about it!
# Posted By urns for human ashes | 10/22/18 5:53 AM
I know your expertise on this. I must say we should have an online discussion on this. Writing only comments will close the discussion straight away! And will restrict the benefits from this information.
# Posted By blank media printing | 10/22/18 10:23 PM
it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity..
# Posted By cd duplication service | 10/23/18 5:50 AM
I have been impressed after read this because of some quality work and informative thoughts. I just want to say thanks for the writer and wish you all the best for coming! Your exuberance is refreshing.
# Posted By gpg bh models | 10/23/18 10:15 PM
I have been impressed after read this because of some quality work and informative thoughts. I just want to say thanks for the writer and wish you all the best for coming! Your exuberance is refreshing.
# Posted By gpg bh models | 10/23/18 10:15 PM
Thank you very much for this great post.
# Posted By Fotografia em BH | 10/23/18 11:51 PM
I am definitely impressed with the photography here.
# Posted By www.dhhz.de | 10/27/18 10:04 PM
Outstanding article! I want people to know just how good this information is in your article. Your views are much like my own concerning this subject. I will visit daily your blog because I know. It may be very beneficial for me.
# Posted By single men women  | 10/28/18 10:16 PM
volunteers and new activities in the same specialty. Website gave us helpful data to work.
# Posted By single men women  | 10/29/18 12:26 AM
I needed to thank you for this phenomenal read!! I unquestionably adored each and every piece of it. I have you bookmarked your site to look at the new stuff you post
<a href="https://autoketing.com/">; https://autoketing.com</a>;
<a href="https://autoketing.com/project/discount-master?utm... master by autoketing </a>
<a href="https://apps.shopify.com/discount-master?utm_sourc...; Discount master app</a>
# Posted By Linh CP | 10/29/18 7:19 AM
I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post.
# Posted By Online Marketing | 10/30/18 1:22 AM
Thank you so much for the post you do. I like your post and all you share with us is up to date and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job.
# Posted By Nigerian Business News | 10/30/18 11:42 PM
I am continually amazed by the amount of information available on this subject. What you presented was well researched and well worded in order to get your stand on this across to all your readers.
# Posted By Free Job Search | 10/31/18 1:25 AM
Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign.
# Posted By Download Gangstar Vegas unlimited money apk | 11/1/18 1:25 AM
It’s appropriate time to make some plans for the future and it is time to be happy. I have read this post and if I could I wish to suggest you few interesting things or advice. Perhaps you could write next articles referring to this article. I desire to read even more things about it!
# Posted By new york neighborhood patrolling | 11/2/18 12:45 AM
It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks.
# Posted By Bloggers  | 11/3/18 12:43 AM
hello!! Very interesting discussion glad that I came across such informative post. Keep up the good work friend. Glad to be part of your net community.
# Posted By cd duplication near knoxville | 11/4/18 12:06 AM
Perhaps you could write next articles referring to this article. I desire to read even more things about it!
# Posted By link vao sbobet | 11/4/18 5:12 AM
I liked the way you discussed your thoughts on this article. Always, there are many interesting information her to learn
<a href="https://autoketing.com/">; autoketing</a>
<a href="https://autoketing.com/project/currency-converter-...; currency converter box free online</a>
<a href="https://apps.shopify.com/currency-converter-master...; currency converter box</a>
# Posted By Linh CP | 11/4/18 10:17 PM
L'astrologie, une branche de la voyance, d'origine grecque « astron » qui signifie étoile et logos lié au discours, représente un art divinatoire par lequel on prédit l'avenir d'une personne grâce à l'étude des astres (position des planètes et le mouvement solaire). Ainsi, l'énergie psychique de chaque être humain serait déterminée par chaque planète. Par conséquent, les traits de caractères d'une personne seraient variables grâce au signe et à la position de la planète au moment de sa naissance. La définition de cette théorie serait évoquée par le biais du centre qui est la Terre et le cercle qui est le Zodiaque.

I am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you.
# Posted By tri color staffordshire terrier | 11/6/18 11:34 PM
Hey what a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and will look for more postings from you.
# Posted By perfume carolina herrera | 11/7/18 7:29 AM
I know your expertise on this. I must say we should have an online discussion on this. Writing only comments will close the discussion straight away! And will restrict the benefits from this information.
# Posted By 7mcn | 11/7/18 9:10 PM
Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information..
# Posted By best gba games | 11/8/18 4:17 AM
Thanks for sharing nice information with us. i like your post and all you share with us is uptodate and quite informative,
# Posted By situs pkv | 11/10/18 12:18 AM
Your work is truly appreciated round the clock and the globe. It is incredibly a comprehensive and helpful blog.
# Posted By YOGA LEGGINGS | 11/12/18 11:41 PM
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
# Posted By Investimenti sicuri 2019 | 11/13/18 4:11 AM
This is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here!
# Posted By true fake id | 11/13/18 5:15 AM
My Essay Writer is the go-to source for the completion of academic assignments.https://www.myessaywriter.net/
If you are screaming out you’ve come to the most elite essay writing service
# Posted By afiya ali | 11/15/18 12:00 AM
Searching for BEST SUSHI NYC check out Sushi Sushi, for SUSHI NYC, SUSHI MANHATTAN, SUSHI HARLEM DELIVERY, SUSHI PRODUCTS, GREAT SUSHI NYC, SUSHI WEST VILLAGE NYC, BEST SUSHI IN WEST VILLAGE, THE BEST SUSHI, MANGO AVOCADO ROLL.
# Posted By SUSHI PRODUCTS | 11/15/18 4:55 AM
I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.
# Posted By christmas pictures | 11/16/18 12:35 AM
I think this article was written without much thought behind it. I got married at 26 and I’m divorced, and I have many friends who are in the same boat.
# Posted By Cheski | 11/16/18 3:35 AM
It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait reading. I am impressed with your work and skill. Thanks.
# Posted By visite website | 11/18/18 12:15 AM
This post has encouraged me to write some posts that I am going to write soon.
# Posted By Stay up to date with latest information | 11/18/18 11:07 PM
Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC.
# Posted By Stay up to date with latest information | 11/20/18 12:50 AM
Thanks, that was a really cool read!
# Posted By Stay up to date with latest information | 11/21/18 5:47 AM
i really like this article please keep it up.!!§§
# Posted By al3ab banat | 11/21/18 10:57 AM
Our experts will finish all your work before the asked time-frame. Use Programming Assignment Help services of StudentsAssignmentHelp.com at amazingly low prices. We have a team of programming experts that hold advanced degrees in the field and great academic writing knowledge.
# Posted By Programming Assignment Help | 11/27/18 1:34 AM
Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.
# Posted By Stay up to date with latest information | 11/28/18 11:53 PM
You have beaten yourself this time, and I appreciate you and hopping for some more informative posts in future. Thank you for sharing great information to us.
# Posted By Stay up to date with latest information | 11/30/18 10:57 PM
Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign.
# Posted By Stay up to date with latest information | 12/1/18 10:30 PM
Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign.
# Posted By Stay up to date with latest information | 12/1/18 10:30 PM
Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.
# Posted By Stay up to date with latest information | 12/1/18 11:22 PM

© 2018, Stephen J. Withington, Jr.  |  BlogCFC was created by Raymond Camden – Version 5.9.004

Creative Commons License  |  This work is licensed under a Creative Commons Attribution 3.0 Unported License.  |  Hosted by Hostek.com